单选题You want to perform the following operations for the DATA ASM disk group： -Verify the consistency of the disk.  -Cross-check all the file extent maps and allocation tables for consistency. check whether the alias metadata directory and file directory a

第1题：

A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

• A、flash back all the tables in the data file， one by one
• B、restore the data file to a new location and perform a media recovery
• C、flash back the database; there is no need to restore the data file
• D、restore the data file from the most recent backup and flash back the database

第2题：

You want to create a valid directory structure for your Java EE web application， and you want to put yourweb application into a WAR file called MyApp.war. Which two are true about the WAR file？（）

• A、At deploy time， Java EE containers add a directory called META-INF directly into the MyApp directory.
• B、At deploy time， Java EE containers add a file called MANIFEST.MF directly into the MyApp directory.
• C、It can instruct your Java EE container to verify， at deploy time， whether you have properly configured your application’s classes.
• D、At deploy time， Java EE containers add a directory call META-WAR directly into the MyApp directory.

第3题：

第4题：

Consider the following scenario： You have a directory， data， under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command： ALTER DISKGROUP tdgroupA  ADD ALIAS ’+tdgroupA/data/datafile.dbf’  FOR ’+tdgroupA.231.45678’；  Which task would be accomplished by the command？（）

• A、The command drops the file +tdgroupA·231.45678.
• B、The command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
• C、The command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
• D、The command creates an alias， datafile.dbf， and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.
• E、The command creates a file， datafile.dbf， in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

第5题：

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.

第6题：

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

第7题：

Which two are the uses of the ASM metadata backup and restore （AMBR） feature？（）

• A、 It can be used to back up all data on ASM disks.
• B、 It can be used to recover the damaged ASM disk group along with the data.
• C、 It can be used to gather information about a preexisting ASM disk group with disk paths，disk name，failure groups，attributes templates，and alias directory structure.
• D、 It can be used to re-create the ASM disk group with its attributes.

第8题：

第9题：

Which two statements are true regarding the functionality of the remap command in ASMCMD?（）

• A、It repairs blocks that have read disk I/O errors.
• B、It checks whether the alias metadata directory and the file directory are linked correctly.
• C、It repairs blocks by always reading them from the mirror copy and writing them to the original location.
• D、It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

第10题：

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