Question 1

The statement ____ can be used to disable or enable a specific trigger.

Accepted Answer

A)  ANALYZE TRIGGER trigger_name DISABLE|ENABLE; 
B)  ALTER TRIGGER trigger_name DISABLE|ENABLE; 
C)  AUDIT TRIGGER trigger_name DISABLE|ENABLE; 
D)  GRANT TRIGGER trigger_name DISABLE|ENABLE; 
A)  ANALYZE TRIGGER trigger_name DISABLE|ENABLE; 
B)  ALTER TRIGGER trigger_name DISABLE|ENABLE; 
C)  AUDIT TRIGGER trigger_name DISABLE|ENABLE; 
D)  GRANT TRIGGER trigger_name DISABLE|ENABLE;

Question 2

System triggers are typically used to allow the modification of data through a view on a view that is nonmodifiable.

Accepted Answer

A) True 
 B)False

Question 3

The values checked in the ___________________________ clause of a trigger must reference correlation identifiers.

Accepted Answer

The answer of The values checked in the ___________________________ clause...

Question 4

Which of the following statements is True?

Accepted Answer

A)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a constraining table. 
B)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a key-preserved table. 
C)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a mutating table. 
D)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a conditional table. 
A)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a constraining table. 
B)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a key-preserved table. 
C)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a mutating table. 
D)  The body of a trigger cannot read or modify the primary, unique, or foreign key columns of a conditional table.

Question 5

The default timing of a trigger is row level and no code is included to achieve this timing.

Accepted Answer

A) True 
 B)False

Question 6

____ triggers refer to database triggers that are fired by Data Definition Language (DDL) statements or database system events rather than DML actions.

Accepted Answer

A)  ALTER 
B)  CREATE 
C)  System 
D)  Instead-Of 
A)  ALTER 
B)  CREATE 
C)  System 
D)  Instead-Of

Question 7

In the syntax of the CREATE TRIGGER statement, the ____________________ clause can be used to change the OLD and NEW qualifier names to something of your choice.

Accepted Answer

The answer of In the syntax of the CREATE TRIGGER...

Question 8

Database system events include all of the following, except ____.

Accepted Answer

A)  LOGON 
B)  SHUTDOWN 
C)  GRANT 
D)  STARTUP 
A)  LOGON 
B)  SHUTDOWN 
C)  GRANT 
D)  STARTUP

Question 9

LOB and OBJECT columns can be referenced in a trigger and can also be modified.

Accepted Answer

A) True 
 B)False

Question 10

DDL events include all of the following, except ____.

Accepted Answer

A)  ALTER 
B)  DROP 
C)  GRANT 
D)  DECLARE 
A)  ALTER 
B)  DROP 
C)  GRANT 
D)  DECLARE

Question 11

Which trigger option will force the trigger to fire before the test_trg trigger.

Accepted Answer

A)  BEFORE test_trg 
B)  PRECEDES test_trg 
C)  PRIOR test_trg 
D)  no option is available to control the firing order 
A)  BEFORE test_trg 
B)  PRECEDES test_trg 
C)  PRIOR test_trg 
D)  no option is available to control the firing order

Question 12

The statement ____ recompiles the trigger named sales_trg.

Accepted Answer

A)  ENABLE TRIGGER sales_trg COMPILE; 
B)  DROP TRIGGER sales_trg COMPILE; 
C)  COMPILE TRIGGER sales_trg COMPILE; 
D)  ALTER TRIGGER sales_trg COMPILE; 
A)  ENABLE TRIGGER sales_trg COMPILE; 
B)  DROP TRIGGER sales_trg COMPILE; 
C)  COMPILE TRIGGER sales_trg COMPILE; 
D)  ALTER TRIGGER sales_trg COMPILE;

Question 13

The ____ trigger clause allows a trigger to include multiple triggering events in a single trigger.

Accepted Answer

A)  MULTIPLE 
B)  MULTIPLE TRIGGER 
C)  COMPOUND 
D)  COMPOUND TRIGGER 
A)  MULTIPLE 
B)  MULTIPLE TRIGGER 
C)  COMPOUND 
D)  COMPOUND TRIGGER

Question 14

The timing of triggers must be indicated as either BEGIN or END.

Accepted Answer

A) True 
 B)False

The statement ____ can be used to disable or enable a specific trigger.

System triggers are typically used to allow the modification of data through a view on a view that is nonmodifiable.

The values checked in the ___________________________ clause of a trigger must reference correlation identifiers.

Which of the following statements is True?

The default timing of a trigger is row level and no code is included to achieve this timing.

____ triggers refer to database triggers that are fired by Data Definition Language (DDL) statements or database system events rather than DML actions.

In the syntax of the CREATE TRIGGER statement, the ____________________ clause can be used to change the OLD and NEW qualifier names to something of your choice.

Database system events include all of the following, except ____.

LOB and OBJECT columns can be referenced in a trigger and can also be modified.

DDL events include all of the following, except ____.

Which trigger option will force the trigger to fire before the test_trg trigger.

The statement ____ recompiles the trigger named sales_trg.

The ____ trigger clause allows a trigger to include multiple triggering events in a single trigger.

The timing of triggers must be indicated as either BEGIN or END.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters

Exam 9: Database Triggers

The statement ____ can be used to disable or enable a specific trigger.

System triggers are typically used to allow the modification of data through a view on a view that is nonmodifiable.

The values checked in the ___________________________ clause of a trigger must reference correlation identifiers.

Which of the following statements is True?

The default timing of a trigger is row level and no code is included to achieve this timing.

____ triggers refer to database triggers that are fired by Data Definition Language (DDL) statements or database system events rather than DML actions.

In the syntax of the CREATE TRIGGER statement, the ____________________ clause can be used to change the OLD and NEW qualifier names to something of your choice.

Database system events include all of the following, except ____.

LOB and OBJECT columns can be referenced in a trigger and can also be modified.

DDL events include all of the following, except ____.

Which trigger option will force the trigger to fire before the test_trg trigger.

The statement ____ recompiles the trigger named sales_trg.

The ____ trigger clause allows a trigger to include multiple triggering events in a single trigger.

The timing of triggers must be indicated as either BEGIN or END.

Introduction To PL/SQL

Basic PL/SQL Block Structures

Handling Data In PL/SQL Blocks

Cursors and Exception Handling

Procedures

Functions

PL/SQL Packages

Program Unit Dependencies

Oracle-Supplied Packages, Dynamic SQL, and Hiding Source Code

Filters