试题详情
- 多项选择题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.
- A,C,E
关注下方微信公众号，在线模考后查看
热门试题
- Which three statemen
- Examine the structu
- You are w
- You have
- Examine the structu
- You run the SQL Tuni
- Given the&ensp
- ClicktheExhibitbutto
- Considerthefollowing
- You are u
- Data filesQ
- DRAGDROPClicktheTask
- A database&ensp
- View the E
- Which s
- You are d
- You wish to enable
- The CUSTOMERS table
- You are w
- The RECYCLEBIN