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 *