Which two statements are true about triggers? (Choose two.)
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 recompiled before the next invocation.
Explanation:
Answer is NOT “a” because of “ALTER TABLE … DISABLE ALL TRIGGERS” statement
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#CIHJJJHG
Answer is NOT “b” because http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#CIHCIIDG
So, the answer is “c” and “d”
C,D
c,d
http://docs.oracle.com/cd/B10500_01/server.920/a96524/c18trigs.htm
I think the answer is B,D
It is B and D.
B: “You have the ALTER privilege for the table specified in the triggering statement”
http://docs.oracle.com/cd/B28359_01/appdev.111/b28370/triggers.htm#CIHCIIDG
Not C: as it is written “local database or remote tables ..” while it should be only for remote tables in a distributed database:
http://docs.oracle.com/cd/B10500_01/server.920/a96524/c18trigs.htm
C,D