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

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

相似考题

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

2. 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 oneB、restore the data file to a new location and perform a media recoveryC、flash back the database; there is no need to restore the data fileD、restore the data file from the most recent backup and flash back the database

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

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

    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.

    正确答案:A,C

  • 第2题：

    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.

    正确答案:A,D

  • 第3题：

    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

  • 第4题：

    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

  • 第5题：

    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

  • 第6题：

    You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）

    • A、 The au_size disk group attribute determines the size of allocation units in the disk group. 
    • B、 The allocation unit size may vary but the extent size is fixed.
    • C、 The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
    • D、 Extent management is completely automated.

    正确答案:A,D

  • 第7题：

    多选题
    You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）
    A

    The au_size disk group attribute determines the size of allocation units in the disk group.

    B

    The allocation unit size may vary but the extent size is fixed.

    C

    The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.

    D

    Extent management is completely automated.


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

  • 第8题：

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


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

  • 第9题：

    单选题
    A data file become 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 the database.


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

  • 第10题：

    多选题
    You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows 2003 Server, and all client computers run Windows XP Professional. A file server named TK1 has two hard drives. You format D:/ and use the default file permissions. Then you copy a directory named Data from another file server to D:/ on TK1. Now you need to create a network share and configure NTFS permissions settings for D:/Data. You must fulfil the following requirements: 1. All domain users need read access to D:/Data. 2. Members of the Sales group need the ability to add and delete files in a directory named D:/Data/Sales. 3. Members of the Engineering group need the ability to read and modify files in a directory named D:/Data/Enginering. Which three actions should you perform?（） (Each correct answer presents part of the solution. Choose three)
    A

    Assign the Allow - Modify NTFS permission on D:/Data/Sales to the Sales group.

    B

    Assign the Allow - Write NTFS permission on D:/Data/Engineering to the Engineering group.

    C

    Share D:/Data as Data and use the default share permissions.

    D

    Share D:/Data as Data and assign the Allow - Change share permission to the Everyone group.

    E

    Assign the Allow - Full Control NTFS permission on D:/Data to the Administrators group.

    F

    Change the share permission on D:/Data to assign the Allow - Modify permission to the Everyone group.

    G

    Assign the Allow - Read NTFS permission on D:/Data to the Users group.

    H

    Assign the Allow - Write NTFS permission on D:/Data/Sales and D:/Data/Engineering to the Creator Owner group.


    正确答案： F,G
    解析： 暂无解析

  • 第11题：

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


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

  • 第12题：

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


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

  • 第13题：

    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.

    正确答案:C,D

  • 第14题：

    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.

    正确答案:A,D

  • 第15题：

    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

  • 第16题：

    A data file become 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 the database.

    正确答案:B

  • 第17题：

    In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）

    • A、 when one or more file directory paths are accidentally deleted from an ASM disk group
    • B、 when one of the disks in a disk group is accidentaly unplugged
    • C、 when the data file on an ASM disk group gets corrupted
    • D、 when one or more disks in an ASM disk group are lost

    正确答案:A,D

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    单选题
    You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.  What do you do？（）
    A

     Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.

    B

     Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to  its original value.

    C

     You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.

    D

     If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.

    E

     Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.


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

  • 第20题：

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


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

  • 第21题：

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


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

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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
    解析： 暂无解析

相关内容