-
Which clause of the SHUTDOWN command, issued to an Automatic Storage Management (ASM) instance, causes all dependent databases along with the ASM instance to shut down in transactional mode?
The TRANSACTIONAL clause
-
When using ASM Fast Mirror Resync, what does the DISK_REPAIR_TIME attribute represent?
The time period for which ASM will track extents modified during an outage before dropping the disk
-
When the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes are set to 11.1, which sizes can be specified for AU_SIZE disk group attribute?
1, 2, 4, 8, 16, 32, or 64 MB
-
Which dictionary view displays the default permanent tablespace assigned for a database?
The DATABASE_PROPERTIES dictionary view
-
If you specify a value less than 11.1 for the COMPATIBLE.RDBMS disk group attribute, to what value must the COMPATIBILE initialization parameter of all databases using the disk group be set?
A value equal to or greater than the value specified for the COMPATIBLE.RDBMS disk group attribute
-
Which three components of an Oracle database get updated whenever a tablespace is renamed?
The control file, the data dictionary, and the online datafile headers
-
In Oracle 11g, which clauses of the ALTER DISKGROUP...CHECK statement have been deprecated and can now be performed using only the CHECK option?
The ALL, DISK, DISKS IN FAILGROUP, and FILE clauses
-
What is the primary benefit of using the Automatic Storage Management (ASM) Preferred Mirror Read feature in an extended cluster configuration?
Performance is better because you can configure ASM to read from another extent that is not the primary extent, which is closer to the node.
-
Which statement should you use to take disk4 in disk group dg1 offline and drop it immediately?
ALTER DISKGROUP dg1 OFFLINE DISK disk4 DROP AFTER 0;
-
Which clause of the SHUTDOWN command issued to an Automatic Storage Management (ASM) instance should you specify if you want the ASM instance to wait for all dependent databases to complete their shutdown before the ASM instance shuts down?
The NORMAL clause
-
Which initialization parameter specifies the discovery strings for an Automatic Storage Management (ASM) instance?
The ASM_DISKSTRING parameter
-
If you have previously set the DISK_REPAIR_TIME attribute and then issue an ALTER DISKGROUP...OFFLINE statement that includes a DROP AFTER clause, which value will take precedence?
The value specified in the DROP AFTER clause
-
Which disk group attribute indicates the minimum Oracle database version that can be used for clients accessing the disk group?
The COMPATIBLE.RDBMS attribute
-
Which attribute should you specify in the ALTER DISKGROUP statement to enable Automatic Storage Management (ASM) Fast Mirror Resync?
The DISK_REPAIR_TIME attribute
-
If you omit the -I flag of the lsdsk command, from which location will ASMCMD attempt to retrieve disk information from first?
From dynamic views in the Automatic Storage Management (ASM) instance
-
What information is backed up using the md_backup ASMCMD command?
Automatic Storage Management (ASM) metadata containing the exact structure of the disk group, including disk paths, disk names, failure groups, templates, and the alias directory structure
-
Which background process performs data extent movements for ASM disk groups?
The ASM rebalance process (ARBn)
-
Which action does the ASMCMD remap command perform?
It reads the blocks from an ASM mirror copy and rewrites them to a different disk location if the blocks cannot be read.
-
When using ASM Fast Mirror Resync, which statement should you use to bring all disks in failure group f4 of disk group dg1 online?
ALTER DISKGROUP dg1 ONLINE DISKS IN FAILGROUP f4;
-
When configuring the ASM Preferred Mirror Read feature, what should be specified in the ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter?
A list of failure group names to be used as preferred read disks
-
Which disk group attribute indicates the minimum Oracle database version that can be used for Automatic Storage Management (ASM)?
The COMPATIBLE.ASM attribute
-
What is the result of using the ALTER DISKGROUP...MOUNT statement with the NOFORCE option?
The mount succeeds if all disks in the disk group are online.
-
What does the -d option of the lsdsk command specify?
The disk group name
-
Which ASMCMD command can you use to re-create a lost disk group with its original configuration?
The md_restore command
-
Which Automatic Storage Management (ASM) feature improves memory usage of managing extent maps in the shared pool and allows larger file sizes and faster file opens?
ASM Variable Size Extents
-
In Oracle 11g, which metadata directories does the ALTER DISKGROUP...CHECK statement check by default?
All metadata directories
-
When using ASM Fast Mirror Resync, which two views can you query to identify how much longer ASM will keep an offlined disk before dropping it?
The V$ASM_DISK and V$ASM_DISK_IO_STAT views
-
Can the md_restore ASMCMD command be used to fully restore a disk group, including its data?
No, because the ASM metadata backup contains only information about the structure of the disk group, and does not contain any data
-
Which ALTER DISKGROUP statement should you use to bring disk3 in disk group dg1 online?
ALTER DISKGROUP dg1 ONLINE DISK disk3;
-
Which two DROP DISKGROUP statement clauses are required to drop a disk group that cannot be mounted?
The FORCE and INCLUDING CONTENTS clauses
-
Which option should you specify in your ALTER DISKGROUP...MOUNT statement if you want to mount a disk group that contains offline disks?
The FORCE option
-
Which statement should you use to take all disks in failure group fg1 of disk group dg2 offline and drop them after the time period specified by the DISK_REPAIR_TIME attribute?
ALTER DISKGROUP dg2 OFFLINE DISKS IN FAILGROUP fg1;
-
To use ASM Fast Mirror Resync, to which value must the ASM compatibility attribute and RDBMS compatibility attribute be set?
11.1, or later
-
In Oracle 11g, which five things are checked with the ALTER DISKGROUP...CHECK statement?
Disk consistency, consistency of file extent maps and allocation, linking of the metadata directory and file directory, linking of the alias directory tree, and the existence of unreachable allocated blocks in ASM metadata directories
-
Which ALTER DISKGROUP statement should you use to mount the disk group dg1 in restricted mode so that clients cannot access files in the disk group?
ALTER DISKGROUP dg1 MOUNT RESTRICT;
-
Which disk group attribute specifies the size of allocation units in the disk group?
The AU_SIZE disk group attribute
-
Which parameter of an Automatic Storage Management (ASM) instance takes an operating system dependent value and limits the set of disks to be discovered by an ASM instance?
The ASM_DISKSTRING parameter
-
To which value should you set the COMPATBILE.ASM and COMPATIBLE.RDBMS disk group attributes if you want to automatically use variable size extents for new or resized Automatic Storage Management (ASM) datafiles?
11.1, or later
-
If you set the DISK_REPAIR_TIME attribute in an ALTER DISKGROUP statement, which disks are affected?
All disks in the disk group that are currently online
-
In Oracle 11g, which feature can you use with an Automatic Storage Management (ASM) instance with redundancy to minimize the amount of time required to resynchronize disks after a transient failure, such as a power failure?
ASM Fast Mirror Resync
-
To what unit does the DISK_REPAIR_TIME attribute default if none is specified?
Hours (H or h)
-
Which initialization parameter is set to configure the ASM Preferred Mirror Read feature?
The ASM_PREFERRED_READ_FAILURE_GROUPS initialization parameter
-
When using Automatic Storage Management (ASM) Fast Mirror Resync, what happens when ASM cannot write to the disk due to a transient failure, such as a power failure?
ASM offlines the disk but continues to track extents modified for the time period specified by the DISK_REPAIR_TIME attribute.
-
What is the maximum number of data files you can add to a bigfile tablespace?
One
-
When managing an ASM instance with high redundancy, which statement should you use to take disk2 in disk group dg1 offline and drop it after four hours?
ALTER DISKGROUP dg1 OFFLINE DISK disk2 DROP AFTER 4h;
-
How is information about the available Automatic Storage Management (ASM) disks determined when using the -I flag of the lsdsk command?
It is retrieved by scanning disk headers using an ASM disk string.
-
Which clause of the SHUTDOWN command, issued to an Automatic Storage Management (ASM) instance, should you use if you do not want the ASM instance to wait for all dependent databases to complete their shutdown before the ASM instance shuts down?
The ABORT clause
-
What happens if you run the lsdsk command without the -I flag and the Automatic Storage Management (ASM) instance is not running?
You receive an error, and the lsdsk command runs in non-connected mode.
-
Does the md_backup ASMCMD command back up both metadata and data on disk, or metadata only?
Only metadata
-
To use Fast Mirror Resync, preferred read failure groups, and variable size extents, to what value must the COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes be set?
11.1, or later
-
Which RMAN command converts a non-ASM file to an ASM file?
The BACKUP AS COPY DATABASE command
-
In Oracle 11g, which clause must you specify in the ALTER DISKGROUP...CHECK statement to check the consistency of the disk?
None, because the CHECK clause alone now performs all checking, including checking the disk consistency.
-
What is the result if you attempt to use the ALTER DISKGROUP...MOUNT statement with FORCE and all disks in the disk group are currently online?
The mount fails.
-
Which parameter should you modify to increase the speed of rebalance operations?
The ASM_POWER_LIMIT parameter
-
Which ASMCMD command should you use to list disk information for the disks visible to Automatic Storage Management (ASM)?
The lsdsk command
-
Which statement would alter the power level of an ongoing rebalancing operation on disk group dgroupB and set the power level to maximum?
The ALTER DISKGROUP dgroupB REBALANCE POWER 11; statement would set the power level of an ongoing rebalance operation on disk group dgroupB to maximum.
-
Which initialization parameter specifies the disk groups that are mounted by the ASM instance on startup of the ASM instance?
The ASM_DISKGROUPS initialization parameter
|
|
