Question 1

The FOLLOWS trigger option enables a developer to control the firing order of triggers.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following statements is correct?

Accepted Answer

A)  If multiple triggers exist on a table, the order in which the triggers will be fired can be set. 
B)  A BEFORE statement level trigger will fire before a BEFORE row level trigger. 
C)  If you have two statement level triggers, the order in which they are fired is dependent on the order in which they were written. 
D)  Only one trigger can be constructed per table. 
A)  If multiple triggers exist on a table, the order in which the triggers will be fired can be set. 
B)  A BEFORE statement level trigger will fire before a BEFORE row level trigger. 
C)  If you have two statement level triggers, the order in which they are fired is dependent on the order in which they were written. 
D)  Only one trigger can be constructed per table.

Question 3

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

Accepted Answer

The answer of A(n) ___________________________ is one that is referenced...

Question 4

A database ___________________________ is a block of PL/SQL code that runs automatically when a particular database event occurs.

Accepted Answer

The answer of A database ___________________________ is a block of...

Question 5

Row level options are only applicable for ____ events.

Accepted Answer

A)  CREATE 
B)  INSERT 
C)  DECLARE 
D)  UPDATE and DELETE 
A)  CREATE 
B)  INSERT 
C)  DECLARE 
D)  UPDATE and DELETE

Question 6

A constraining table is one that is being modified by a DML action when a trigger is fired.

Accepted Answer

A) True 
 B)False

Question 7

A(n) ____ table is one that is involved in a join and the keys of the original table are included in the keys of the resultant join.

Accepted Answer

A)  mutating 
B)  system 
C)  database 
D)  key-preserved 
A)  mutating 
B)  system 
C)  database 
D)  key-preserved

Question 8

A(n) ___________________________ is a PL/SQL block that executes in place of a DML action on a database view.

Accepted Answer

The answer of A(n) ___________________________ is a PL/SQL block that...

Question 9

Correlation identifiers allow us to refer to and use the row data values of a DML action. _________________________

Accepted Answer

A) True 
 B)False

Question 10

If multiple triggers exist on a table, there is no guarantee about the order in which the triggers will be fired.

Accepted Answer

A) True 
 B)False

Question 11

All of the following would cause a trigger to fire, except ____.

Accepted Answer

A)  BEFORE 
B)  INSERT 
C)  DELETE 
D)  UPDATE 
A)  BEFORE 
B)  INSERT 
C)  DELETE 
D)  UPDATE

Question 12

CURSOR basketitem_curIS
SELECT idproduct, quantity, option1
FROM bb_basketitem
WHERE idbasket = :NEW.idbasket;
In the code fragment above, which of the following represents the correlation identifier?

Accepted Answer

A)  idproduct 
B)  bb_basketitem 
C)  quantity 
D)  :NEW.idbasket 
A)  idproduct 
B)  bb_basketitem 
C)  quantity 
D)  :NEW.idbasket

Question 13

Using the MULITPLE TRIGGER clause will allow more than one triggering event to be included in a single trigger.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following statements is True about mutating tables?

Accepted Answer

A)  A table in an UPDATE statement that fires a row level trigger affecting the same table is not considered a mutating table unless the UPDATE includes a subquery. 
B)  A table in a DELETE statement that fires a row level trigger affecting the same table is not considered a mutating table unless the DELETE includes a subquery. 
C)  A table in an INSERT statement that fires a row level trigger affecting the same table is not considered a mutating table unless the INSERT includes a subquery. 
D)  A table in a DROP statement that fires a row level trigger affecting the same table is not considered a mutating table unless the DROP includes a subquery. 
A)  A table in an UPDATE statement that fires a row level trigger affecting the same table is not considered a mutating table unless the UPDATE includes a subquery. 
B)  A table in a DELETE statement that fires a row level trigger affecting the same table is not considered a mutating table unless the DELETE includes a subquery. 
C)  A table in an INSERT statement that fires a row level trigger affecting the same table is not considered a mutating table unless the INSERT includes a subquery. 
D)  A table in a DROP statement that fires a row level trigger affecting the same table is not considered a mutating table unless the DROP includes a subquery.

Question 15

One prominent limitation in the use of triggers is that they cannot issue transaction control statements of COMMIT, ROLLBACK, and SAVEPOINT.

Accepted Answer

A) True 
 B)False

Question 16

CREATE [OR REPLACE] TRIGGER trigger_name [BEFORE, AFTER]
[List of DDL or Database System Events] [ON DATABASE |
SCHEMA] Trigger body;
The syntax above represents that of a(n) ____ trigger.

Accepted Answer

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

Question 17

The ALTER TRIGGER statement is used to recompile, enable, or disable a trigger.

Accepted Answer

A) True 
 B)False

Question 18

Only one triggering event can be addressed in a single trigger.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following events will cause the trigger to fire?
AFTER UPDATE OF orderplaced ON bb_basket

Accepted Answer

A)  INSERT 
B)  UPDATE 
C)  DELETE 
D)  AFTER 
A)  INSERT 
B)  UPDATE 
C)  DELETE 
D)  AFTER

Question 20

Numerous triggers can be constructed on one table and, therefore, a DML action on that table can fire off more than one trigger.

Accepted Answer

A) True 
 B)False

The FOLLOWS trigger option enables a developer to control the firing order of triggers.

Which of the following statements is correct?

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

A database ___________________________ is a block of PL/SQL code that runs automatically when a particular database event occurs.

Row level options are only applicable for ____ events.

A constraining table is one that is being modified by a DML action when a trigger is fired.

A(n) ____ table is one that is involved in a join and the keys of the original table are included in the keys of the resultant join.

A(n) ___________________________ is a PL/SQL block that executes in place of a DML action on a database view.

Correlation identifiers allow us to refer to and use the row data values of a DML action. _________________________

If multiple triggers exist on a table, there is no guarantee about the order in which the triggers will be fired.

All of the following would cause a trigger to fire, except ____.

CURSOR basketitem_curIS SELECT idproduct, quantity, option1 FROM bb_basketitem WHERE idbasket = :NEW.idbasket; In the code fragment above, which of the following represents the correlation identifier?

Using the MULITPLE TRIGGER clause will allow more than one triggering event to be included in a single trigger.

Which of the following statements is True about mutating tables?

One prominent limitation in the use of triggers is that they cannot issue transaction control statements of COMMIT, ROLLBACK, and SAVEPOINT.

CREATE [OR REPLACE] TRIGGER trigger_name [BEFORE, AFTER] [List of DDL or Database System Events] [ON DATABASE | SCHEMA] Trigger body; The syntax above represents that of a(n) ____ trigger.

The ALTER TRIGGER statement is used to recompile, enable, or disable a trigger.

Only one triggering event can be addressed in a single trigger.

Which of the following events will cause the trigger to fire? AFTER UPDATE OF orderplaced ON bb_basket

Numerous triggers can be constructed on one table and, therefore, a DML action on that table can fire off more than one trigger.

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 FOLLOWS trigger option enables a developer to control the firing order of triggers.

Which of the following statements is correct?

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

A database ___________________________ is a block of PL/SQL code that runs automatically when a particular database event occurs.

Row level options are only applicable for ____ events.

A constraining table is one that is being modified by a DML action when a trigger is fired.

A(n) ____ table is one that is involved in a join and the keys of the original table are included in the keys of the resultant join.

A(n) ___________________________ is a PL/SQL block that executes in place of a DML action on a database view.

Correlation identifiers allow us to refer to and use the row data values of a DML action. _________________________

If multiple triggers exist on a table, there is no guarantee about the order in which the triggers will be fired.

All of the following would cause a trigger to fire, except ____.

CURSOR basketitem_curIS SELECT idproduct, quantity, option1 FROM bb_basketitem WHERE idbasket = :NEW.idbasket; In the code fragment above, which of the following represents the correlation identifier?

Using the MULITPLE TRIGGER clause will allow more than one triggering event to be included in a single trigger.

Which of the following statements is True about mutating tables?

One prominent limitation in the use of triggers is that they cannot issue transaction control statements of COMMIT, ROLLBACK, and SAVEPOINT.

CREATE [OR REPLACE] TRIGGER trigger_name [BEFORE, AFTER] [List of DDL or Database System Events] [ON DATABASE | SCHEMA] Trigger body; The syntax above represents that of a(n) ____ trigger.

The ALTER TRIGGER statement is used to recompile, enable, or disable a trigger.

Only one triggering event can be addressed in a single trigger.

Which of the following events will cause the trigger to fire? AFTER UPDATE OF orderplaced ON bb_basket

Numerous triggers can be constructed on one table and, therefore, a DML action on that table can fire off more than one trigger.

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