Oracle Database 11g: Administration II
Question No: 41 – (Topic 1)
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows:
SQLgt; CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY
FAILGROUP controller1 DISK #39;/devices/diska1#39;, #39;/devices/diska2#39; FAILGROUP controller2 DISK #39;/devices/diskb1#39;, #39;/devices/diskb2#39;;
What happens when the whole CONTROLLER1 Failure group is damaged?
The transactions that use the disk group will halt.
The mirroring of allocation units occurs within the CONTROLLER2 failure group.
The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
Question No: 42 – (Topic 1)
Which two commands never trigger an implicit rebalancing within the disk group?. (Choose two.)
ALTER DISKGROUP misc MOUNT;
ALTER DISKGROUP misc DROP DISK misc2;
ALTER DISKGROUP misc CHECK ALL NOREPAIR;
ALTER DISKGROUP misc RESIZE ALL SIZE 1023m;
ALTER DISKGROUP dgroupA ADD DISK #39;/devices/A*#39;;
Answer: A,C Explanation: Altering Disk Groups
You can use the ALTER DISKGROUP SQL statement to alter a disk group configuration. You can add, resize, or drop disks while the database remains online. Whenever possible, multiple operations in a single ALTER DISKGROUP statement are recommended.
Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations.
Oracle ASM automatically rebalances when the configuration of a disk group changes. By default, the ALTER DISKGROUP statement does not wait until the operation is complete before returning. Query the V$ASM_OPERATION view to monitor the status of this operation.
Use this clause to add one or more disks to the disk group and specify attributes for the newly added disk. Oracle ASM automatically rebalances the disk group as part of this operation.
Use this clause to drop one or more disks from the disk group. DROP DISK
The DROP DISK clause lets you drop one or more disks from the disk group and automatically rebalance the disk group. When you drop a disk, Oracle ASM relocates all the data from the disk and clears the disk header so that it no longer is part of the disk group. The disk header is not cleared if you specify the FORCE keyword.
Question No: 43 – (Topic 1)
To reference existing ASM files, you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A, the database name is DEV19, and the ASM file that you want to reference is a datafile for the USERS02 tablespace.
Which of the following is a valid ASM filename for this ASM file?
A. dev19/ DG2A/datafile/users02.701.2
Answer: B Explanation:
Fully Qualified File Name Form (link)
A fully qualified file name has the following form:
diskgroup is the disk group name preceded by a plus sign. You can think of the plus sign ( ) as the root directory of the Oracle ASM file system, similar to the slash (/) on UNIX or Linux computers.
dbname is the DB_UNIQUE_NAME of the database to which the file belongs. filetype is the Oracle file type and can be one of the file types shown in Table 7-3.
filetypetag is type-specific information about the file and can be one of the tags shown in Table 7-3.
file.incarnation is the file/incarnation pair, used to ensure uniqueness. For example,
filetype = #39;DATAFILE#39;, Data files and data file copies
filetypetag = #39;tblspname#39;, Name of the tablespace into which the file is added
Question No: 44 – (Topic 1)
Which of the following ALTER DISKGROUP commands does not use
V$ASM_OPERATION to record the status of the operation?
Question No: 45 – (Topic 1)
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#39;t want to have to rebuild the disks from scratch.
What do you do?
Take the whole disk group offline and wait for the controller card to be installed. Once it#39;s installed, bring the disk group online again.
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.
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.
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.
Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.
Question No: 46 – (Topic 1)
What is the net effect of the following command? alter diskgroup dgroup1 drop disk abc;
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.
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.
The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete, the disk will be dropped.
This command will fail because you cannot drop a specific disk in an ASM disk group.
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.
Question No: 47 – (Topic 1)
Identify three key features of ASM. (Choose three.)
allocation unit mirroring
automatic disk rebalancing
automatic file size increment
automatic undo management
Question No: 48 – (Topic 1)
As DBA for the Rebalance, you have decided that you need to facilitate some redundancy in your database. Using ASM, you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data (you do not have advanced SAN mirroring technology available to you, unfortunately).
Which of the following commands would create a disk group that would offer the maximum in data redundancy?
Answer: C Explanation:
No SAN mirroring available means no external redundancy available.
The highest redundancy of ASM is the HIGH redundancy with 3 mirror copies.
Question No: 49 – (Topic 1)
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? (Choose all that apply.)
Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
Question No: 50 – (Topic 1)
View Exhibit1 to examine the CRS11G disk group when all the disks are online. View Exhibit2 to examine the CRS11G disk group when one disk is offline.
Why is the rebalancing not performed and the content of the disk group not empty in Exhibit2?
Because the disk group is created with NORMAL redundancy
Because the disk repair time attribute is set to a nonzero value
Because the mirrored extents cannot be rebalanced across the other three disks
Because the other three disks have 60% free space, the disk rebalancing is delayed
Answer: B Explanation: Key points:
The COMPATIBILITY.ASMgt;=11.1 and COMPATIBILITY.RDBMSgt;=11.1
The DISK_REPAIR_TIME is set to non-zero. by default it is 3.6hr. Refer to here.
Note: To use this feature, the disk group compatibility attributes must be set to 11.1 or higher. For more information, refer to quot;Disk Group Compatibilityquot;.
Oracle ASM fast resync keeps track of pending changes to extents on an OFFLINE disk during an outage. The extents are resynced when the disk is brought back online.
By default, Oracle ASM drops a disk in 3.6 hours after it is taken offline. You can set the DISK_REPAIR_TIME disk group attribute to delay the drop operation by specifying a time interval to repair the disk and bring it back online.
EnsurePass ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No