Deck 10: Learn how to create a database in Oracle Database XE 11g Release 2

Question 1

What is the Oracle Database 11g XE utility?

Answer 1

The Oracle Database 11g XE utility is a Web-based administration utility that is the preferred tool for database instance management.It is not intended for application development,only database administration.It is used to create workspaces (databases),user accounts and other administrative tasks.

Question 2

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

Answer 2

C

Question 3

To log into a workspace connection in Oracle SQL Developer,use the username and password you created for Application Express.

Answer 3

True

Question 4

The Oracle Database GUI tool used for application development is the Oracle SQL Developer.

Question 5

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

Question 6

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

Question 7

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

Question 8

Oracle SQL Developer is a command-line interface for the creation of database objects.

Question 9

Oracle Database XE uses Application Express to create new workspaces.

Question 10

Oracle 12c is a/an ________ class DBMS.

Question 11

Oracle Database XE has no set maximum database size.

Question 12

Another name for Oracle Database Express Edition 11g Release 2 is Oracle Database XE.

Question 13

To log into Oracle Database XE,use your personal account information.

Question 14

Users log into the Oracle Database XE utility using the ________ account.

Question 15

There are four editions of Oracle Database 12c.

Question 16

You do not need administrative privileges on your Windows computer at any point of the Oracle Datatbase XE installation.

Question 17

Users in SQL Developer log into a workspace using the ________ account.

Question 18

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

Question 19

What is SQL Developer?

Question 20

Explain how you would import Microsoft Excel data via SQL Developer by creating the table while importing the data.

Question 21

All Excel worksheets imported into Oracle Database will have an appropriate column for a primary key.

Question 22

Database objects are displayed in the ________ navigator window in the SQL Developer.

Question 23

Which method returns the next value in a sequence?

A) CountVal
B) Next
C) UpVal
D) NextVal
E) Append

Question 24

When using Oracle Database,a sequence is an object that generates a sequential series of unique numbers.

Question 25

The default file extension for text files created for or within SQL Developer is .sql.

Question 26

With Oracle Database,using a sequence does not guarantee valid surrogate key values.

Question 27

Explain sequences and their relationship to surrogate keys.

Question 28

You may use simple text editors to create SQL scripts for Oracle Database XE.

Question 29

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

Question 30

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

Question 31

Sequences are most often used to provide values for surrogate keys.

Question 32

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

Question 33

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

Question 34

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

Question 35

The NextVal method provides the next value in a sequence.

Question 36

The Oracle Database ODBC Client is installed ________ when Oracle Database Express Edition 11g Release 2 is installed.

Question 37

The CurrVal method provides the current value in a sequence.

Question 38

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);

Question 39

With Oracle Database,data must be entered using SQL INSERT statements.

Question 40

The Oracle Database ODBC Client is automatically installed when Oracle Database XE is installed.

Question 41

To run an SQL script,click the ________ button.

Question 42

Describe how to create and run an SQL query in Oracle Database XE 11g Release 2.

Question 43

SQL query results are displayed in a tabbed ________ window.

Question 44

To create a new SQL query,click the ________ button.

Question 45

It is useful to have Microsoft Access 2016 to act as the application ________ for an Oracle Database XE database.

Question 46

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

Question 47

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

Question 48

What is an SQL script,and why are SQL scripts useful?

Question 49

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

Question 50

Describe how to create and run an SQL script in Oracle Database Express Edition 11g Release 2.

Question 51

Oracle Database Express Edition 11g Release 2 uses ________ to generate surrogate keys.

Question 52

To run an SQL query,click the ________ button.