Oracle
1Z0-144 · Question #19
View Exhibit 1 and examine the structure of the EMP and dept tables. View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict…
The correct answer is B. It gives an error on compilation because it is not a row-level trigger. UPDATE and DELETE RESTRICT Trigger for Parent Table
Configuring JDBC Data Sources
Question
View Exhibit 1 and examine the structure of the EMP and dept tables. View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table. What is the outcome on compilation?
Exhibits
Options
- AIt compiles and executes successfully.
- BIt gives an error on compilation because it is not a row-level trigger.
- CIt gives an error on compilation because the exception section Is used in the trigger.
- DIt compiles successfully but gives an error on execution because it is not a row-level trigger.
How the community answered
(26 responses)- A15% (4)
- B73% (19)
- C4% (1)
- D8% (2)
Explanation
UPDATE and DELETE RESTRICT Trigger for Parent Table
Topics
#PL/SQL triggers#row-level trigger#referential integrity#trigger compilation
Community Discussion
No community discussion yet for this question.