单选题You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the

第1题：

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

第2题：

You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）

• A、The rebalancing of the disk group would be stopped.
• B、The rebalancing of the disk group would be completed as fast as possible.
• C、The command would result in an error because the value of POWER cannot be 0.
• D、The rebalancing of the disk group would be completed without affecting the disk group DG3.
• E、The command would result in an error because the disk groups cannot be manually rebalanced.

第3题：

第4题：

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?（）

• A、The keep pool is not configured.
• B、Automatic Workarea Management is not configured.
• C、Automatic Shared Memory Management is not enabled.
• D、The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
• E、All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view

第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题：

What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；

• A、 The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.
• B、 The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.
• C、 The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.
• D、 This command will fail because you cannot drop a specific disk in an ASM disk group.
• E、 The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.

第7题：

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.

第8题：

第9题：

You work as a database administrator for Certkiller .com. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）

• A、All control files are opened
• B、All redo files are opened
• C、The password file is opened
• D、The parameter file is opened
• E、All online data files are opened

第10题：

You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）

• A、The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.
• B、The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.
• C、The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.
• D、The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.