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

第1题：

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

第3题：

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.

第4题：

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

第5题：

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.

第6题：

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 rebalancing
• B、 Because the FRA disk group is not configured to support mirroring
• C、 Because disks in the FRA disk group are not formatted at this stage
• D、 Because the FRA disk group will support only a single size of allocation unit

第7题：

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

第8题：

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.

第9题：

第10题：

第11题：

第12题：

第13题：

Which of the following tools restricts device installation?（）

• A、Default domain policy
• B、Group Policy
• C、Disk Management
• D、File share properties

第14题：

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.

第15题：

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.

第16题：

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.

第17题：

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 MOUNTED  

• A、 The DGROUP1 disk group was unmounted by another DBA.
• B、 A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
• C、 One of the redundant disks （DGROUP1） has been lost in a disk group.
• D、 This query has no meaning in an ASM instance.
• E、 A disk associated with a disk group was discovered after the ASM instance initially opened.

第18题：

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.

第19题：

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

第20题：

第21题：

第22题：

第23题：