Oracle 11G OCP 1Z0-053 275

（275）You have enabled resumable space allocation in your database by setting the RESUMABLE_TIMEOUT parameter set to a nonzero value.

Which three statements about resumable space allocation are true? (Choose three.)

A.   Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.

B.   A resumable statement is suspended only if an out of space error occurs.

C.   When a resumable statement is suspended, the transaction that contains the statement is also suspended.

D.   A resumable statement can only be suspended and resumed once during the execution of the statement.

E.   You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.

答案：（A、C、E）

重複：208，211

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1269707/，如需轉載，請註明出處，否則將追究法律責任。