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

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

Which of the following is an account name for which you would enter a password to connect to a workspace in Oracle SQL Developer?

SQL statements can be run individually or as part of a related group of SQL statements known as a:

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

The CurrVal method provides the current value in a sequence.

What is SQL Developer?

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

SQL query results are displayed in a tabbed ________ window.

SQL query results are displayed:

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

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

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

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

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

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

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

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

Explain sequences and their relationship to surrogate keys.

To run an SQL query,click the ________ button.

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