单选题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

题目
单选题
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.

相似考题

1.Examine the following command:ALTER DISKGROUP data MOUNT FORCE;In which scenario can you use the above command to mount the disk group? ()A. when ASM disk goes offlineB. when one or more ASM files are droppedC. when some disks in a disk group are offlineD. when some disks in a failure group for a disk group are rebalancing

2.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 instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

3. 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.

4.You want to perform the following operations for the DATA ASM disk group:Which command accomplishes these tasks?()A. ALTER DISKGROUP data CHECK;B. ALTER DISKGROUP data CHECK DISK;C. ALTER DISKGROUP data CHECK FILE;D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

更多“单选题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 r”相关问题

  • 第1题：

    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.

    正确答案:A

  • 第2题：

    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

    正确答案:A

  • 第3题：

    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

    正确答案:D

  • 第4题：

    Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）  

    • A、 when ASM disk goes offline
    • B、 when one or more ASM files are dropped
    • C、 when some disks in a disk group are offline
    • D、 when some disks in a failure group for a disk group are rebalancing

    正确答案:C

  • 第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

    正确答案:B

  • 第6题：

    You issued the following command to mount the DATA disk group in restricted mode：   ALTER DISKGROUP data MOUNT RESTRICT；   What is the implication of this command？（）

    • A、 The client RDBMS instance can access the file as a read-only file.
    • B、 A new disk cannot be added to a disk group.
    • C、 A disk in a disk group can be taken offline.
    • D、 The client RDBMS instance cannot access the files in the disk group.

    正确答案:D

  • 第7题：

    单选题
    Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）
    A

    when ASM disk goes offline

    B

    when one or more ASM files are dropped

    C

    when some disks in a disk group are offline

    D

    when some disks in a failure group for a disk group are rebalancing


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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 are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？
    A

     ALTER DISKGROUP data CHECK

    B

     ALTER DISKGROUP data CHECK DISK

    C

     ALTER DISKGROUP data CHECK FILE

    D

     ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1


    正确答案： B
    解析： 暂无解析

  • 第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-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


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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.

    正确答案:D

  • 第14题：

    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

    正确答案:B,E

  • 第15题：

    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.

    正确答案:C

  • 第16题：

    You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）

    • A、Use the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.
    • B、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.
    • C、Use the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.
    • D、Use the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.
    • E、Use the MD_RESTORE command to restore both the metadata and data for the failed disk group.
    • F、Use the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.

    正确答案:C,E,F

  • 第17题：

    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 are linked correctly.  -Check that ASM metadata directories do not have unreachable allocated blocks.   Which command accomplishes these tasks（）？

    • A、 ALTER DISKGROUP data CHECK
    • B、 ALTER DISKGROUP data CHECK DISK
    • C、 ALTER DISKGROUP data CHECK FILE
    • D、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

    正确答案:A

  • 第18题：

    单选题
    Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）
    A

     when ASM disk goes offline

    B

     when one or more ASM files are dropped

    C

     when some disks in a disk group are offline

    D

     when some disks in a failure group for a disk group are rebalancing


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    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


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF;  What would be the effect of this command on the existing flashback logs？（）
    A

    Flashback logs are not deleted.

    B

    Flashback logs are deleted automatically.

    C

    Flashback logs are deleted only if you are using Recovery Manager （RMAN）.

    D

    Flashback logs are deleted only if you are using Oracle Managed Files （OMF）.

    E

    Flashback logs are deleted only if you are using Automatic Storage Management （ASM）.


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You issued the following command to mount the DATA disk group in restricted mode：   ALTER DISKGROUP data MOUNT RESTRICT；   What is the implication of this command？（）
    A

     The client RDBMS instance can access the file as a read-only file.

    B

     A new disk cannot be added to a disk group.

    C

     A disk in a disk group can be taken offline.

    D

     The client RDBMS instance cannot access the files in the disk group.


    正确答案： D
    解析： 暂无解析

相关内容