Oracle Database 11g: Program with PL/SQL — Question 6

Which two statements are true about triggers? (Choose two.)

Answer options

• A. All the triggers that are created on a table cannot be disabled simultaneously.
• B. Any user who has the alter privilege on a table can create a trigger using that table.
• C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
• D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually

Correct answer: C, D

Explanation

Option C is correct because Oracle's two-phase commit ensures data consistency during updates across local and remote databases. Option D is also correct, as triggers lose their validity if any invoked dependent object changes, requiring manual re-enablement. Options A and B are false; triggers can be disabled simultaneously and only users with specific privileges can create triggers.