单选题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 CHECKB ALTER DISKGROUP data CHECK DISKC ALTER DISKGROUP data CHECK FILED 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 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


参考解析

解析: 暂无解析

相关考题:

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.

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;

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

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

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.

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.

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.

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.

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.

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

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.

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.

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 CHECKB、 ALTER DISKGROUP data CHECK DISKC、 ALTER DISKGROUP data CHECK FILED、 ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1

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 groupB、 when one of the disks in a disk group is accidentaly unpluggedC、 when the data file on an ASM disk group gets corruptedD、 when one or more disks in an ASM disk group are lost

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.

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

多选题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?()AThe au_size disk group attribute determines the size of allocation units in the disk group.BThe allocation unit size may vary but the extent size is fixed.CThe allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.DExtent management is completely automated.

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

多选题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?()AAt deploy time, Java EE containers add a directory called META-INF directly into the MyApp directory.BAt deploy time, Java EE containers add a file called MANIFEST.MF directly into the MyApp directory.CIt can instruct your Java EE container to verify, at deploy time, whether you have properly configured your application’s classes.DAt deploy time, Java EE containers add a directory call META-WAR directly into the MyApp directory.

多选题Which two are the uses of the ASM metadata backup and restore (AMBR) feature?()AIt can be used to back up all data on ASM disks.BIt can be used to recover the damaged ASM disk group along with the data.CIt 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.DIt can be used to re-create the ASM disk group with its attributes.

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

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

多选题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)AAssign the Allow - Modify NTFS permission on D:/Data/Sales to the Sales group.BAssign the Allow - Write NTFS permission on D:/Data/Engineering to the Engineering group.CShare D:/Data as Data and use the default share permissions.DShare D:/Data as Data and assign the Allow - Change share permission to the Everyone group.EAssign the Allow - Full Control NTFS permission on D:/Data to the Administrators group.FChange the share permission on D:/Data to assign the Allow - Modify permission to the Everyone group.GAssign the Allow - Read NTFS permission on D:/Data to the Users group.HAssign the Allow - Write NTFS permission on D:/Data/Sales and D:/Data/Engineering to the Creator Owner group.

单选题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?()Amount the new disk group in the ASM instanceBrestart the ASM instance and the production database instanceCregister the new disk groups in the production database instanceDrestart the ASM instance without restarting the production database instanceEinclude the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

单选题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?()Aflash back all the tables in the data file, one by oneBrestore the data file to a new location and perform a media recoveryCflash back the database; there is no need to restore the data fileDrestore the data file from the most recent backup and flash back the database

单选题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?()AThe command drops the file +tdgroupA·231.45678.BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.CThe command creates a copy of the +tdgroupA·231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.DThe command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the +tdgroupA·231.45678 file.EThe command creates a file, datafile.dbf, in +tdgroupA/data and removes the references for +tdgroupA·231.45678 from the data dictionary views.

单选题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?()AThe file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.BThe file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.CThe file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.DThe file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.