单选题To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）ARESUMABLE_SPACE_TIMEBRESUMABLE_SPACECRESUMABLE_TIMEDRESUMABLE_TIMEOUTETIME_RESUMABLE

第1题：

第2题：

In which two conditions are resumable statements suspended？（）

• A、 when a user exceeds the space quota
• B、 when a user session is terminated
• C、 when a table that is being accessed by the current transaction is not found
• D、 when a user manually suspends the statement
• E、 when the maximum extents of a segment is reached

第3题：

第4题：

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

第5题：

Which of the following actions will occur once the reorgvg command is used?（）

• A、The allocation policy for each logical volume will be set.
• B、The given allocation policy for each logical volume will be adhered to.
• C、Each logical volume's physical partitions will be moved to another volume group.
• D、Each logical volume's physical partitions will be moved to match its allocation policy, if there is sufficient space.

第6题：

第7题：

You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

• A、to enable the ASM instance to identify the alert log file
• B、to enable the ASM instance to identify the server parameter file
• C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
• D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

第8题：

第9题：

Which of the following describes how a distributed resumable transaction behaves？（）  

• A、 The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.
• B、 The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.
• C、 The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts  of the transaction.
• D、 None of the above.

第10题：

To enable resumable space allocation for the instance， which of the following initialization parameters should you set to a nonzero value？（）

• A、 RESUMABLE_SPACE_TIME
• B、 RESUMABLE_SPACE
• C、 RESUMABLE_TIME
• D、 RESUMABLE_TIMEOUT
• E、 TIME_RESUMABLE