FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: B: Managing Databases With Oracle Database 11g Release 2

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 51

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 52

Multiple Choice

Review LaterAdd Note

Review Later

Which of the following is not a transaction isolation level supported by Oracle Database?

A) Read Committed
B) Serializable
C) Repeatable Read
D) Read Only
E) All of the above are supported.

Correct Answer

verified

Show Answer

Question 53

Multiple Choice

Review LaterAdd Note

The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is ________.

Which of the following commands does Oracle Database not support?

The NextVal method provides the next value in a sequence.

The GUI tool for creating a new index is the Oracle SQL Developer ________.

Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related table,view,and other similar objects?

The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is ________.

Which type of trigger is commonly used to update views?

Oracle Database only reads committed changes,and therefore dirty reads are not possible.

The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

Which of the following is true about stored procedures in Oracle Database?

The Oracle Database variant of SQL with additional procedural language components is ________.

The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

You can use the Edit Table table editor to create an index in Oracle Database.

In Oracle Database,triggers that are fired once for each row that is changed in a table are called row triggers.

Explain the Oracle Database PL/SQL cursor statements.

All Oracle Database triggers work at the row level.

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

With Oracle Database,you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.