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 can only be enabled at the system level.

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

C.
Only the local instance is affected when changing theresumable timeout parameter in a
distributed transaction.

D.
The ALTER SESSION ENABLE RESUMABLE command is obsoletein Oracle
Database10g.

E.
Resumable statements cannot contain a distributed transaction.

F.
RESUMABLE_TIMEOUT = 0 disablesresumable space allocation for all sessions.

Explanation:



Leave a Reply 0

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