FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 11: Managing Databases With Oracle Database 11g

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 21

True/False

Review LaterAdd Note

Review Later

Oracle Database triggers BEFORE and AFTER are placed on tables,while the INSTEAD OF trigger is placed on views.

Correct Answer

verified

Show Answer

Question 22

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 23

True/False

Review LaterAdd Note

The PL/SQL keyword STOP HERE is used to complete the basic PL/SQL block structure.

Which of the following is a GUI tool for application development with Oracle Database?

The PL/SQL keyword ISTHERE is used to look for the existence of a condition.

The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

Oracle Database uses the SQL ALTER TABLE command to change the structure of a table.

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

If the SQL statement SELECT C1,C2,C3 FROM T4 WHERE C2 = 'Smith'; Is frequently executed,which column(s) should be considered for indexing based only on the statement itself?

With Oracle Database,stored procedures can be invoked remotely.

Explain the Oracle Database PL/SQL control-of-flow statements.

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

Explain the Oracle Database PL/SQL cursor statements.

Explain sequences and their relationship to surrogate keys.

The CurrVal method provides the current value in a sequence.

The Read Only transaction isolation level is unique to Oracle Database.

If you include a slash as the last line in an Oracle stored procedure,the procedure will be compiled and stored when you run the block of code.

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 prefix :new is used with values of columns available to insert and update triggers.

The default isolation level in Oracle Database is Read Committed,which provides statement level isolation.