单选题To reference existing ASM files， you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A， the database name is DEV19， and the ASM file that you want to reference is a datafile for the USERS02 tablespace.  W

第1题：

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）  

• A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
• B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
• C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
• D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

第2题：

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

• A、 Data Pump Export and Import
• B、 conventional export and import
• C、 the CONVERT command of RMAN
• D、 the BACKUP AS COPY. command of RMAN

第3题：

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.

第4题：

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

第5题：

You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

• A、 ASMB
• B、 ARBn
• C、 RBAL in the ASM instance
• D、 RBAL in the database instance

第6题：

Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

• A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
• B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
• C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
• D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

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

第14题：

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

第15题：

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

• A、The ASM compatibility attribute controls the format of the disk group metadata.
• B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
• C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
• D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
• E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

第16题：

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）

• A、ASM disk groups with ASM disks consisting of Exadata Grid Disks.
• B、ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
• C、ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
• D、Database files stored in ZFS and accessed using conventional NFS mounts.
• E、Database files stored in ZFS and accessed using the Oracle Direct NFS feature
• F、Database files stored in any file system and accessed using the Oracle Direct NFS feature
• G、ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

第17题：

You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

• A、the CONVERT command of RMAN
• B、Data Pump Export and Import into the same database
• C、conventional export and import into the same database
• D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
• E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN

第18题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM 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 database files to an ASM disk group.
• B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
• C、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）.
• D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：