网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?（）
A
100KB default, 10TB maximum
B
256KB default, 1024MB maximum
C
10MB default, 126PB maximum
D
64KB default, 1EB maximum
E
1MB default, 64MB maximum
参考答案
参考解析
解析：
暂无解析
更多 “单选题What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?（）A 100KB default, 10TB maximumB 256KB default, 1024MB maximumC 10MB default, 126PB maximumD 64KB default, 1EB maximumE 1MB default, 64MB maximum” 相关考题
考题
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:What happens when the whole CONTROLLER1 Failure group is damaged?()
A. The transactions that use the disk group will halt.B. The mirroring of allocation units occurs within the CONTROLLER2 failure group.C. The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D. The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
考题
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:There is enough free space in the disk group for mirroring to be done.What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
考题
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.
考题
When an ASM instance receives a SHUTDOWN NORMAL command，what command does it pass on to all database instances that rely on the ASM instances disk groups？（）A、 TRANSACTIONALB、 IMMEDIATEC、 ABORTD、 NORMAL
考题
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）A、The ASM compatibility attribute controls the format of the disk group metadata.B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.
考题
In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）A、 This command would result in an error because the disk group is not empty.B、 The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.C、 The command would result in the contents being moved to the parent disk group and dropping of the disk group.D、 The command would result in the disk group being marked as INVALID because it cannot be dropped.E、 The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
考题
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.
考题
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
考题
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）A、 Because the FRA disk group will not support dynamic rebalancingB、 Because the FRA disk group is not configured to support mirroringC、 Because disks in the FRA disk group are not formatted at this stageD、 Because the FRA disk group will support only a single size of allocation unit
考题
What is the default AU size of an ASM disk group? What is the maximum AU size in an ASM disk group?（）A、100KB default, 10TB maximumB、256KB default, 1024MB maximumC、10MB default, 126PB maximumD、64KB default, 1EB maximumE、1MB default, 64MB maximum
考题
单选题View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）. Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）A
Because the FRA disk group will not support dynamic rebalancingB
Because the FRA disk group is not configured to support mirroringC
Because disks in the FRA disk group are not formatted at this stageD
Because the FRA disk group will support only a single size of allocation unit
考题
单选题Which of the following is a benefit of ASM fast disk resync？（）A
Failed disks are taken offline immediately but are not dropped.B
Disk data is never lost.C
By default， the failed disk is not dropped from the disk group ever， protecting you from loss of that disk.D
The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.E
Hot spare disks are automatically configured and added to the disk group.
考题
多选题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 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
考题
单选题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
考题
多选题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 database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）A
Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.B
Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.C
The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.D
ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.E
Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
考题
单选题You have a computer that runs Windows 7. Multiple users share the computer. The computer is joined to adomain. You need to prevent the users from using more than 2 GB of disk space on drive C. What should you do?（）A
From a Group Policy object （GPO）， enable the Limit profile size setting.B
Enable System Protection for Local Disk （C） and set the disk space usage.C
Enable disk quota management on Computer1 and configure a default quota limit.D
From a Group Policy object （GPO）， enable the Limit the size of the entire roaming user profile cachesetting.
考题
单选题After executing the command alter diskgroup disk group2 drop disk dg2a； you issue the following command from the ASM instance： Select group_number， count（*） from v$asm_operation； What is the implication if the query against V$ASM_OPERATION returns zero rows？（）A
The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.B
The drop disk operation is complete and you can run the undrop disks command if needed.C
The drop disk operation is complete and you cannot run the undrop disk command.D
The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance. E
None of the above is true.
考题
单选题In your Automatic Storage Management （ASM） instance， one of the nonempty disk groups， DGROUP1， is no longer required and you want this disk group to be removed. You execute the following command to achieve this objective： DROP DISKGROUP dgroup1 EXCLUDING CONTENTS； What would be the result of this command？（）A
This command would result in an error because the disk group is not empty.B
The command would distribute the contents of the specified disk group among all other disk groups and then drop the specified disk group.C
The command would result in the contents being moved to the parent disk group and dropping of the disk group.D
The command would result in the disk group being marked as INVALID because it cannot be dropped.E
The command would drop the disk group， ignoring the EXCLUDING CONTENTS option.
考题
多选题In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）Awhen one or more file directory paths are accidentally deleted from an ASM disk groupBwhen one of the disks in a disk group is accidentaly unpluggedCwhen the data file on an ASM disk group gets corruptedDwhen one or more disks in an ASM disk group are lost
考题
多选题As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL select group_number， name， state from v$ASM_DISKGROUP； GROUP_NUMBER NAME STATE 0 DGROUP1 DISMOUNTED 2 DGROUP2 MOUNTED 3 DGROUP3 MOUNTEDAThe DGROUP1 disk group was unmounted by another DBA.BA datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateCOne of the redundant disks （DGROUP1） has been lost in a disk group.DThis query has no meaning in an ASM instance.EA disk associated with a disk group was discovered after the ASM instance initially opened.
考题
单选题A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）A
The transactions that use the disk group will halt.B
The mirroring of allocation units occurs within the CONTROLLER2 failure group.C
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.D
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
考题
多选题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？（）ASet the ASM compatibility attribute for the ASM disk group to 11.1.0.BSet the RDBMS compatibility attribute for the ASM disk group to 11.1.0.CSet the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.DSet the COMPATIBLE initialization parameter for the database instance to 11.1.0.
考题
单选题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.
考题
单选题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.
热门标签
最新试卷
