Which combination of triggering time and event would you use to achieve this objective?

In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?

In the PROD database you have granted the RESUMABLE system privilege to the CONNECT role. Resumable space operation has been enabled for all user sessions. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically.

Which combination of triggering time and event would you use to achieve this objective?

A.
AFTER TRUNCATE

B.
BEFORE INSERT OR DELETE OR UPDATE

C.
BEFORE CREATE

D.
BEFORE SUSPEND

E.
AFTER CREATE

F.
AFTER INSERT OR DELETE OR UPDATE

G.
AFTER SUSPEND



Leave a Reply 0

Your email address will not be published. Required fields are marked *