Question 1

To remove a trigger from the system, the DEL TRIGGER statement is used. _________________________

Accepted Answer

A) True 
 B)False  False

Question 2

Discuss three critical pieces of information regarding the WHEN clause of a trigger.

Accepted Answer

First, a WHEN clause can be used only in row level triggers. Second, the values checked in the WHEN clause must reference correlation identifiers. Third, the condition must be enclosed in parentheses.

Question 3

The ___________________________ level option is applicable only for UPDATE and DELETE events.

Accepted Answer

row

Question 4

How can triggers be applied to accomplish referential integrity?

Accepted Answer

Foreign key constraints are used to enfo

Question 5

To rebuild a database from a script, if you are using SQL Developer, open the file and click the ____________________ button.

Accepted Answer

The answer of To rebuild a database from a script,...

Question 6

The trigger body is a PL/SQL block that contains the actions that take place when the trigger fires.

Accepted Answer

A) True 
 B)False

Question 7

What is the difference between a mutating table and a key-preserved table?

Accepted Answer

A key-preserved table is one that is inv

Question 8

LONG RAW variables cannot be declared in triggers. _________________________

Accepted Answer

A) True 
 B)False

Question 9

CREATE OR REPLACE TRIGGER logon_trg
AFTER logon ON SCHEMA
BEGIN
INSERT INTO bb_audit_logon
VALUES (USER, SYSDATE);
END;
In the code fragment above, which of the ____ statement represents the system event.

Accepted Answer

A)  logon 
B)  INSERT 
C)  SYSDATE 
D)  AFTER 
A)  logon 
B)  INSERT 
C)  SYSDATE 
D)  AFTER

Question 10

The default timing of a trigger is ____.

Accepted Answer

A)  statement level 
B)  system level 
C)  row level 
D)  header level 
A)  statement level 
B)  system level 
C)  row level 
D)  header level

Question 11

Which of the following indicates that the trigger is fired only once, regardless of the number of rows affected by the DML statement?

Accepted Answer

A)  Statement level 
B)  Event level 
C)  DML level 
D)  Row level 
A)  Statement level 
B)  Event level 
C)  DML level 
D)  Row level

Question 12

A database trigger is tied to a database table or view and is implicitly fired by the database system when that table or view is affected with the associated DML action.

Accepted Answer

A) True 
 B)False

Question 13

A(n) ____ trigger fires whenever the event occurs, regardless of the schema in which it occurs.

Accepted Answer

A)  row level 
B)  system level 
C)  Instead-Of 
D)  database level 
A)  row level 
B)  system level 
C)  Instead-Of 
D)  database level

Question 14

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

Accepted Answer

The answer of The default timing of a trigger is...

Question 15

A(n) ____ is a table that is being modified by a DML action when a trigger is fired.

Accepted Answer

A)  system table 
B)  mutating table 
C)  transaction table 
D)  correlation table 
A)  system table 
B)  mutating table 
C)  transaction table 
D)  correlation table

Question 16

The WHEN clause of a trigger can be used only in row level triggers. _________________________

Accepted Answer

A) True 
 B)False

Question 17

___________________________ are clauses available within a trigger to allow separate handling of different database triggering events within a single trigger.

Accepted Answer

Conditiona

Question 18

The statement ____ correctly deletes a trigger.

Accepted Answer

A)  DEL TRIGGER trigger_name; 
B)  DELETE TRIGGER trigger_name; 
C)  REMOVE TRIGGER trigger_name; 
D)  DROP TRIGGER trigger_name; 
A)  DEL TRIGGER trigger_name; 
B)  DELETE TRIGGER trigger_name; 
C)  REMOVE TRIGGER trigger_name; 
D)  DROP TRIGGER trigger_name;

Question 19

A(n) mutating table is one that is referenced via a foreign key constraint on the table that a trigger is modifying. _________________________

Accepted Answer

A) True 
 B)False

Question 20

LONG or LONG RAW variables can be declared in triggers and the NEW and OLD qualifiers cannot refer to these types of columns.

Accepted Answer

A) True 
 B)False

To remove a trigger from the system, the DEL TRIGGER statement is used. _________________________

Discuss three critical pieces of information regarding the WHEN clause of a trigger.

The ___________________________ level option is applicable only for UPDATE and DELETE events.

How can triggers be applied to accomplish referential integrity?

To rebuild a database from a script, if you are using SQL Developer, open the file and click the ____________________ button.

The trigger body is a PL/SQL block that contains the actions that take place when the trigger fires.

What is the difference between a mutating table and a key-preserved table?

LONG RAW variables cannot be declared in triggers. _________________________

CREATE OR REPLACE TRIGGER logon_trg AFTER logon ON SCHEMA BEGIN INSERT INTO bb_audit_logon VALUES (USER, SYSDATE); END; In the code fragment above, which of the ____ statement represents the system event.

The default timing of a trigger is ____.

Which of the following indicates that the trigger is fired only once, regardless of the number of rows affected by the DML statement?

A database trigger is tied to a database table or view and is implicitly fired by the database system when that table or view is affected with the associated DML action.

A(n) ____ trigger fires whenever the event occurs, regardless of the schema in which it occurs.

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

A(n) ____ is a table that is being modified by a DML action when a trigger is fired.

The WHEN clause of a trigger can be used only in row level triggers. _________________________

___________________________ are clauses available within a trigger to allow separate handling of different database triggering events within a single trigger.

The statement ____ correctly deletes a trigger.

A(n) mutating table is one that is referenced via a foreign key constraint on the table that a trigger is modifying. _________________________

LONG or LONG RAW variables can be declared in triggers and the NEW and OLD qualifiers cannot refer to these types of columns.

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

To remove a trigger from the system, the DEL TRIGGER statement is used. _________________________

Discuss three critical pieces of information regarding the WHEN clause of a trigger.

The ___________________________ level option is applicable only for UPDATE and DELETE events.

How can triggers be applied to accomplish referential integrity?

To rebuild a database from a script, if you are using SQL Developer, open the file and click the ____________________ button.

The trigger body is a PL/SQL block that contains the actions that take place when the trigger fires.

What is the difference between a mutating table and a key-preserved table?

LONG RAW variables cannot be declared in triggers. _________________________

CREATE OR REPLACE TRIGGER logon_trg AFTER logon ON SCHEMA BEGIN INSERT INTO bb_audit_logon VALUES (USER, SYSDATE); END; In the code fragment above, which of the ____ statement represents the system event.

The default timing of a trigger is ____.

Which of the following indicates that the trigger is fired only once, regardless of the number of rows affected by the DML statement?

A database trigger is tied to a database table or view and is implicitly fired by the database system when that table or view is affected with the associated DML action.

A(n) ____ trigger fires whenever the event occurs, regardless of the schema in which it occurs.

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

A(n) ____ is a table that is being modified by a DML action when a trigger is fired.

The WHEN clause of a trigger can be used only in row level triggers. _________________________

___________________________ are clauses available within a trigger to allow separate handling of different database triggering events within a single trigger.

The statement ____ correctly deletes a trigger.

A(n) mutating table is one that is referenced via a foreign key constraint on the table that a trigger is modifying. _________________________

LONG or LONG RAW variables can be declared in triggers and the NEW and OLD qualifiers cannot refer to these types of columns.

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