Which three statements regarding resumable statements are correct?

Which three statements regarding resumable statements are correct? (Choose three)

Which three statements regarding resumable statements are correct? (Choose three)

A.
Resumable statements cannot contain a distributed transaction.

B.
Resumable statements can only be enabled at the system level.

C.
Resumable statements can be enabled at the system level as well as the session level.

D.
RESUMABLE_TIMEOUT=0 disabled resumable space allocation for all sessions.

E.
The ALTER SESSION ENABLE RESUMABLE command is obsolete in Oracle Database 10g.

F.
Only the local instance is affected when changing the resumable timeout parameter in a distribution transaction.

Explanation:
C : At the system level:
ALTER SYSTEM SET RESUMABLE_TIMEOUT = 72000;
At the session level:
ALTER SESSION SET RESUMABLE_TIMEOUT = 72000;
E. ALTER SESSION ENABLE RESUMABLE; is still supported in oracle 10g



Leave a Reply 1

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