You work as a database administrator for Examsheets.net. In the EXAMSHEETSPRODUCTION
database you have granted RESUMABLE system privilege to the CONNECT role. Resumable
space operation has been enabled for all user session. 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 CREATE
B. AFTER SUSPEND
C. BEFORE CREATE
D. AFTER TRUNCATE
E. BEFORE SUSPEND
F. AFTER INSERT OR DELETE OR DELETE
G. BEFORE INSERT OR DELETE OR DELETE
Answer: B
这个题我怎么也看不懂什么意思,希望有谁能看的懂的话帮忙讲解一下,万分感激~!!!!!
When a resumable statement encounter a correctable error, the system internally generates the AFTER SUSPEND system event. Users can register triggers for this event at both the database and schema level. If a user registers a trigger to handle this system event, the trigger is executed after a SQL statement has been suspended.
SQL statements executed within a AFTER SUSPEND trigger are always non-resumable and are always autonomous. Transactions started within the trigger use the SYSTEM rollback segment. These conditions are imposed to overcome deadlocks and reduce the chance of the trigger experiencing the same error condition as the statement.