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? ()

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. (Out of space condition Maximum extents reached condition,Space quota exceeded condition) 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.

时间:2022-09-22 19:30:27 所属题库:OCP 11G认证考试题库

相似题目