You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

A、 creating a table in your schema and you exceed your allocated space quota on the tablespace

B、 executing a long query that involves a sort operation and the statement runs out of temporary space

C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit

D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

相关问题推荐

• 以下程序不用第三个变量实现将两个数进行对调的操作，划线处应为()。 main() {int a，b； scanf(“%d%d”，&a，&b)； cin＞＞a＞＞b； tout＜＜“a＝”＜＜a＜＜“b＝”＜＜b； a＝a+b；b＝a-b；a＝______； cout＜＜“a＝”＜＜a＜＜“b＝”＜＜b＜＜end1； }

  A．a-Cb

  B．a-b

  C．b*a

  D．a/b

  查看答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  A、import the database from the last export

  B、restore all the members in the group from the last backup

  C、drop the lost member from the database， and then add a new member to the group

  D、restore all the database files from the backup， and then perform a complete recovery 

  E、restore all the database files from the backup， and then perform an incomplete recovery

  查看答案

• You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table：       Due to limited space， some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement： SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP；   What will be the implication of executing this statement？（）

  A、  Only the WAREHOUSE_DETAILS table is recovered， and none of the dependent objects are recovered.

  B、  The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints， primary key constraint， and the referential integrity constraints.

  C、  The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.

  D、  The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.

  查看答案

• You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）

  A、 V$BACKUP_CORRUPTION

  B、 V$COPY_CORRUPTION

  C、 V$DATABASE_BLOCK_CORRUPTION

  D、 RC_BACKUP_CORRUPTION

  查看答案

• （）不属于大型项目控制的三要素。

  A、项目绩效跟踪

  B、质量改进

  C、外部变更请求

  D、变更控制

  查看答案