Deck 10: Getting Started With Oracle Database Express Edition 11g Release 2

Question 1

Oracle Database XE 11.2 uses Application Express to create new workspaces.

Answer 1

True

Question 2

Which of the following is the easiest tool for doing database development with Oracle Database?

A)The Oracle Database XE 11.2 utility
B)The Oracle SQL*Plus command utility program
C)The Oracle SQL Developer
D)A and C
E)A,B and C

Answer 2

C

Question 3

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

Answer 3

True

Question 4

An important reason for using Oracle Database Express Edition 11g Release 2 is that it has full SQL capabilities.

Question 5

Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.

Question 6

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

Question 7

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

Question 8

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

Question 9

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

Question 10

Which of the following is the easiest tool for creating a database with Oracle Database?

A)The Oracle Database XE 11.2 utility
B)The Oracle SQL*Plus command utility program
C)The Oracle SQL Developer
D)A and C
E)A,B and C

Question 11

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

Question 12

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

Question 13

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

Question 14

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)Your own personal login
B)The user login associated with the workspace
C)INTERNAL
D)A and B
E)A,B and C

Question 15

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

Question 16

The NextVal method provides the next value in a sequence.

Question 17

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

Question 18

The CurrVal method provides the current value in a sequence.

Question 19

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)A and B
E)A,B and C

Question 20

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)A and B
E)A,B and C

Question 21

What is SQL Developer?

Question 22

An important reason for using Oracle Database Express Edition 11g Release 2 is that it has ________.

Question 23

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

Question 24

SQL query results are displayed in a tabbed ________ window.

Question 25

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 26

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 27

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

Question 28

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

Question 29

When Oracle Database Express Edition 11g Release 2 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 30

To run an SQL script,click the ________ button.

Question 31

To run an SQL query,click the ________ button.

Question 32

To run an SQL script in Oracle Database Express Edition 11g Release 2:

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 33

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 34

Which method returns the next value in a sequence?

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

Question 35

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)Any of the above will work correctly.

Question 36

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

Question 37

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

Question 38

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

Question 39

What is the Oracle Database XE 11.2?

Question 40

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

Question 41

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

Question 42

Explain sequences and their relationship to surrogate keys.

Question 43

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