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.
c, d are correct
Hi Paul,
Why “B” (Any user who has the alter privilege on a table can create a trigger using that table) is correct ?
https://docs.oracle.com/cd/B19306_01/network.102/b14266/authoriz.htm#i1008214
…to create a trigger on a table, the user requires both the ALTER TABLE object privilege for the table and the CREATE TRIGGER system privilege…
I think correct answers are BD
Not A:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/general004.htm#ADMIN11534
“You can disable all triggers associated with a table at the same time using the ALTER TABLE statement with the DISABLE ALL TRIGGERS option.”
Not C:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/triggers.htm#CNCPT1681
“Oracle Database uses two-phase commit if a trigger updates remote tables in a distributed database.”
D:
“If a trigger references another object, such as a subprogram or package, and that object is modified or dropped, then the trigger becomes invalid. ”
https://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS751
I think BD are correct answers:
Not A:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/general004.htm#ADMIN11534
“You can disable all triggers associated with a table at the same time using the ALTER TABLE statement with the DISABLE ALL TRIGGERS option.”
Not C:
https://docs.oracle.com/cd/B28359_01/server.111/b28318/triggers.htm#CNCPT1681
“Oracle Database uses two-phase commit if a trigger updates remote tables in a distributed database.”
D:
“If a trigger references another object, such as a subprogram or package, and that object is modified or dropped, then the trigger becomes invalid. ”
https://docs.oracle.com/database/121/LNPLS/triggers.htm#LNPLS751