You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

A、ASM_POWER_LIMIT

B、ASM_DISKSTRING

C、ASM_DISKGROUPS

D、INSTANCE_TYPE

相关问题推荐

• You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for Recovery Manager (RMAN). To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Which two statements are true about the execution of the above command? （）(Choose two.)

  A

  The backup piece size will be limited to 300 MB

  B

  The RMAN uses multiplexing to perform backup

  C

  The operation is accomplished using the default channel available

  D

  The RMAN parallelizes the backup although the parallelism is not set for a channel

  查看答案

• Which statement about Automatic Memory Management with Oracle 11g is true?（）

  A、You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.

  B、Oracle can reallocate memory between the SGA and PGA automatically as needed.

  C、To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.

  D、You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size

  查看答案

• You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema. You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）

  A、 It retrieves the latest version of the table from the recycle bin

  B、 It retrieves the oldest version of the table from the recycle bin

  C、 It retrieves the version of the table for which undo information is available

  D、 It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

  查看答案

• The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

  A

  All the related indexes and views are automatically dropped

  B

  The flashback drop feature can recover only the table structure

  C

  Only the related indexes are dropped whereas views are invalidated

  D

  The flashback drop feature can recover both the table structure and its data

  查看答案

• Your production database is running in archivelog mode and you are using recovery manager （RMAN） with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday， the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted.   The steps to recover the damaged data files are follows：   1. Mount the database  2. Open the database  3. Recover the data file  4. Restore the data file  5. Make the data file offline  6. Make the data file online   Which option identifies the correct sequence that you must use to recover the data files？（）

  A、 2，4，3

  B、 1，4，3，2

  C、 2，5，4，3，6

  D、 5，2，4，3，6

  E、 1，5，4，3，6，2

  查看答案