Even with resumable space allocation enabled for your database, you can disable resumable space allocation for a single session.
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)
When a resumable statement is suspended, the transaction that contains the statement is also suspended.
A resumable statement can only be suspended and resumed once during the execution of the statement.
You can query the V$SESSION_WAIT dynamic performance view to identify the statements that are suspended for a session.
第1题:
A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=
第2题:
You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level?()
第3题:
A. 0
B. 10
C. 100
D. NULL
第4题:
You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?()
第5题:
You want to disable resumable space allocation for all sessions.Which value should be assigned to the RESUMABLE_TIMEOUT parameter to disable resumable space allocation for all sessions?()
第6题:
A.RESUMABLE_SPACE_TIME
B.RESUMABLE_SPACE
C.RESUMABLE_TIME
D.RESUMABLE_TIMEOUT
E.TIME_RESUMABLE
第7题:
You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose?()
第8题:
A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement
第9题:
Identify the three predefined server-generated alerts.()
第10题:
You want to enable resumable space allocation at the instance level. Which two actions would enable resumable space allocation at the instance level?()