FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

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

Show Answer

Share

---

All types

Filters

Study Flashcards

Question 1

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

True

Question 2

True/False

Review LaterAdd Note

Review Later

Oracle Database XE uses Application Express to create new workspaces.

A) True
B) False

Correct Answer

verified

Show Answer

Question 3

Essay

Review LaterAdd Note

What is SQL Developer?

The NextVal method provides the next value in a sequence.

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

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

To run an SQL script,click the ________ button.

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

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

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

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

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

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

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

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

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

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

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

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

Explain sequences and their relationship to surrogate keys.