Database Concepts, 8e (Kroenke)
Appendix B Getting Started with Oracle Database XE
1) Oracle Database XE uses Application Express to create new workspaces.
2) To log into a workspace connection in Oracle SQL Developer, use the username and password
you created for Application Express.
3) Which of the following is the easiest tool for creating a database with Oracle Database?
A) The Oracle Database 11g XE utility
B) The Oracle SQL*Plus command utility program
C) The Oracle SQL Developer
D) Both A and C
E) A, B and C
4) Which of the following is the easiest tool for doing database development with Oracle
Database?
A) The Oracle Database 11g XE utility
B) The Oracle SQL*Plus command utility program
C) The Oracle SQL Developer
D) Both A and C
E) A, B and C
2
5) Which of the following is an account name for which you are asked to enter a password for
the Oracle Database XE 11.2 utility?
A) SYSTEM
B) EXTERNAL
C) INTERNAL
D) Both A and B
E) A, B and C
6) Which of the following is an account name for which you would enter a password to connect
to a workspace in Oracle SQL Developer?
A) Database Username
B) Application Express Username
C) INTERNAL
D) Both A and B
E) A, B and C
7) Users log into the Oracle Database XE utility using the ________ account.
8) Users in SQL Developer log into a workspace using the ________ account.
9) What is imported from Excel in order to populate an Oracle Database XE Table?
A) Key
B) Workbook
C) Macro
D) Worksheet
E) All of the above
10) Explain how you would import Microsoft Excel data via SQL Developer by creating the
table while importing the data.
11) There are four editions of Oracle Database 12c.
12) Oracle Database XE has no set maximum database size.
13) Another name for Oracle Database Express Edition 11g Release 2 is Oracle Database XE.
14) To log into Oracle Database XE, use your personal account information.
15) You do not need administrative privileges on your Windows computer at any point of the
Oracle Datatbase XE installation.
16) Oracle 12c is a/an ________ class DBMS.
17) What is the Oracle Database 11g XE utility?
18) The Oracle Database GUI tool used for application development is the Oracle SQL
Developer.
19) Oracle SQL Developer is a command-line interface for the creation of database objects.
20) What is SQL Developer?
21) The Oracle Database ODBC Client is automatically installed when Oracle Database XE is
installed.
22) When Oracle Database XE is installed, the Oracle Database ODBC client is ________.
A) installed automatically as part of the installation
B) installed manually as a separate part of the installation process
C) not installed and must be downloaded and installed manually
D) not installed because there is no ODBC client for Oracle Database 11g Release 2 Express
Edition
E) Either A or B
23) The Oracle Database ODBC Client is installed ________ when Oracle Database Express
Edition 11g Release 2 is installed.
24) The default file extension for text files created for or within SQL Developer is .sql.
25) When using Oracle Database, a sequence is an object that generates a sequential series of
unique numbers.
26) You may use simple text editors to create SQL scripts for Oracle Database XE.
27) All Excel worksheets imported into Oracle Database will have an appropriate column for a
primary key.
28) Which of the following tasks can be done using the Oracle SQL Developer?
A) See the structure of a table
B) Add and remove columns from a table
C) Insert and delete data from a table
D) Both A and B
E) A, B and C
29) In SQL Developer, DBMS objects are displayed ________.
A) in the Navigation Pane
B) in the Object Browser
C) in the Connections area
D) in the tabbed document window
E) in the command tab
30) Database objects are displayed in the ________ navigator window in the SQL Developer.
31) Explain sequences and their relationship to surrogate keys.
32) Sequences are most often used to provide values for surrogate keys.
33) The NextVal method provides the next value in a sequence.
34) The CurrVal method provides the current value in a sequence.
35) With Oracle Database, using a sequence does not guarantee valid surrogate key values.
36) With Oracle Database, data must be entered using SQL INSERT statements.
37) The Oracle Database FORMAT_DATE function can be used to make sure that Oracle
Database interprets date data correctly.
38) SQL statements can be run individually or as part of a related group of SQL statements
known as a ________.
A) result
B) resultset
C) script
D) scriptset
E) commandset
39) Which method returns the next value in a sequence?
A) CountVal
B) Next
C) UpVal
D) NextVal
E) Append
40) If T3 is a table with three columns C1, C2 and C3, where C1 is integer data, C2 is character
data, and C3 is date data, which of the following would be the proper statement to have Oracle
Database enter the date 02/10/14 into a row in table T3 while making sure that it is formatted
correctly as shown?
A) SET INTO T3 VALUES (101, ‘Smith’, ’02/10/14′);
B) SET INTO T3 VALUES (101, ‘Smith’, TO_DATE (’02/10/14′, ‘DD/MM/YY’));
C) INSERT INTO T3 VALUES (101, ‘Smith’, ’02/10/2014′);
D) INSERT INTO T3 VALUES (101, ‘Smith’, TO_DATE (’02/10/14′, ‘DD/MM/YY’));
E) INSERT INTO T3 VALUES (‘Smith’, TO_DATE (’02/10/14′, ‘DD/MM/YY’), 101);
41) To run an SQL script, click the ________ button.
42) Oracle Database Express Edition 11g Release 2 uses ________ to generate surrogate keys.
43) To run an SQL script in Oracle Database XE ________.
A) click the Execute button
B) click the Execute Script button
C) click the Run Script button
D) click the Ready button
E) click the Results button
44) SQL query results are displayed ________.
A) in a tabbed Resultset window
B) in a tabbed Query Result window
C) in a tabbed Document window
D) in a tabbed Messages window
E) in a tabbed Finished window
45) To run an SQL query, click the ________ button.
46) To create a new SQL query, click the ________ button.
47) SQL query results are displayed in a tabbed ________ window.
48) What is an SQL script, and why are SQL scripts useful?
49) Describe how to create and run an SQL script in Oracle Database Express Edition 11g
Release 2.
50) Describe how to create and run an SQL query in Oracle Database XE 11g Release 2.
51) What kind of connection is needed to use Microsoft Access 2016 as an application
development frontend for an Oracle Database XE database?
A) XML
B) WP
C) XACCDB
D) JSON
E) ODBC
52) It is useful to have Microsoft Access 2016 to act as the application ________ for an Oracle
Database XE database.