Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?

If an undo segment has not reached its space limit, then a message is sent to the DBA and the statement is aborted

If any other recoverable error has occurred, the timeout interval is reset to 10 hours

Which effects will a trigger have in the AFTER SUSPEND trigger wheneve

1.	Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?
A.	If an undo segment has not reached its space limit, then a message is sent to the DBA and the statement is aborted
B.	If any other recoverable error has occurred, the timeout interval is reset to 10 hours
C.	Both A & B
D.	None of the above
Answer» E.

Discussion

No Comment Found

Related MCQs

Which of the following errors are correctable?
In Suspended Statements which view is used When a statement is suspended the session invoking the statement is put into a wait state. A row is inserted into this view for the session with the EVENT column containing "statement suspended, wait error to be cleared"?
Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?
Why do you analyze a schema object (table, index, or cluster)?
What can be included in the CREATE SCHEMA statement which is useful if you want to guarantee the creation of several tables, views, and grants in one operation?
DBMS_ADVISOR package procedures relevant to the segment advisor which package procedure name use this procedure to create the Segment Advisor task. Specify 'Segment Advisor as the value of the ADVISOR_NAME parameter?
In Schema Objects Data Dictionary Views which view List the name, type, and owner (USER view does not display owner) for all tables, views, synonyms, and sequences in the database?
The following query lists all of the base objects for the synonyms created by user jward. What is displayed by the following example?SELECT TABLE_OWNER, TABLE_NAME, SYNONYM_NAMEFROM DBA_SYNONYMSWHERE OWNER = 'JWARD';The following is the query output:TABLE_OWNER----TABLE_NAME----SYNONYM_NAME---------------------- ----------- -----------------SACHIN---------DEPT----------DEPTSACHIN---------EMP-----------EMP
Where are theLOBs and varrays stored?
How many levels can we request advice from the Segment Advisor?

Which effects will a trigger have in the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session?

Discussion

No Comment Found

Related MCQs

Reply to Comment