多项选择题
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.
单项选择题 The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBAs intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?()
多项选择题 Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?()
单项选择题 You issue the following RMAN command to set a retention policy on a database: RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2; What will be the outcome of issuing this command? ()