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

Question 1

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

Answer 1

True

Question 2

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

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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 9

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

Question 10

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

Question 11

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 12

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

Question 13

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

Question 14

The NextVal method provides the next value in a sequence.

Question 15

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 16

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

Question 17

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

Question 18

The CurrVal method provides the current value in a sequence.

Question 19

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

Question 20

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 21

To run an SQL script in Oracle Database 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 22

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 23

Which method returns the next value in a sequence?

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

Question 24

When Oracle Database 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 25

What is the Oracle Database XE 11.2?

Question 26

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

Question 27

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

Question 28

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

Question 29

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

Question 30

To run an SQL script,click the ________ button.

Question 31

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

Question 32

SQL query results are displayed in a tabbed ________ window.

Question 33

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

Question 34

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

Question 35

To run an SQL query,click the ________ button.

Question 36

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 37

What is SQL Developer?

Question 38

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

Question 39

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 40

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 41

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

Question 42

Explain sequences and their relationship to surrogate keys.

Question 43

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