You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

A、 mount the new disk group in the ASM instance

B、 restart the ASM instance and the production database instance

C、 register the new disk groups in the production database instance

D、 restart the ASM instance without restarting the production database instance

E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

相关问题推荐

• In your production database， you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct？ （）

  A

   The parallel degree limit for DB_GRP will be the minimum of all the incoming values.

  B

   The parallel degree limit for DB_GRP will be the maximum of all the incoming values.

  C

   The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.

  D

   If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would not execute if the active session pool for the new consumer group was full.

  E

   Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time， then that session would execute even if the active session pool for the new consumer group was full.

  查看答案

• You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  

  A、 The statement will fail.

  B、 The statement will be executed successfully， and the new time zone will be set for the database.

  C、 The statement will be executed successfully， but the new time zone will be set for the current session.

  D、The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.

  查看答案

• You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）

  A、 flash back the corrupted blocks

  B、 use the DBMS_REPAIR package

  C、 use the RMAN TSPITR command

  D、 use the RMAN BLOCKRECOVER command

  E、 use the RESTORE DATABASE and RECOVER DATABASE commands

  F、 investigate the time at which the corruption occurred and perform a point-in-time recovery

  查看答案

• You executed the following command in Recovery Manager （RMAN）：  RMAN> RESTORE CONTROLFILE；  Which operation must you perform before this command is executed？（） 

  A、back up the control file to trace

  B、bring database to the MOUNT state

  C、open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database

  D、set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

  查看答案

• Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）

  A

   Backup of offline tablespaces.

  B

   Backup of read-only tablespaces.

  C

   Backup of system-critical tablespaces.

  D

   Backup of online， locally managed tablespaces.

  E

   Backup of read/write dictionary-managed tablespaces.

  查看答案