单选题You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the A

第1题：

You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

• A、 Reregistering the target database in recovery catalog
• B、 Transporting the new tablespaces to the recovery catalog database
• C、 Syncronizing the recovery catalog with the target database control file
• D、 Performing a fresh backup of the target database to include the new data files in the catalog database

第2题：

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

第3题：

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

第4题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

• A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
• B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
• C、 RMAN would relocate all the database files to an ASM disk group.
• D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

第5题：

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

第6题：

n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、 Oracle Migration Assistant
• B、 Recovery Manager （RMAN）
• C、 Oracle Data Pump Export and Import
• D、 conventional Oracle Export and Import
• E、 operating system utilities to copy the files to the ASM instance

第7题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

• A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
• B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
• C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
• D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
• E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

第8题：

You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process？（）

• A、 Database Identifier （DBID）
• B、 names and location of datafiles
• C、 names and location of control files
• D、 names and location of online redo log files

第9题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance

第10题：

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files.  Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）

• A、Oracle Migration Assistant
• B、Recovery Manager （RMAN）
• C、Oracle Data Pump Export and Import
• D、conventional Oracle Export and Import
• E、operating system utilities to copy the files to the ASM instance