Oracle Automatic Storage Management Quiz

 



Oracle Automatic Storage Management Quiz contain set of 10 MCQ questions for Oracle ASM MCQ which will help you to clear beginner level quiz.



1. ALTER DISKGROUP FRA1 REBALANCE POWER 624;
a) Above sql statement is not valid
b) Above sql statement is valid from Oracle 11g Release 2 
c) Above sql statement is valid from Oracle 11g Release 1
d) Rebalancing power limit cann’t exceed 11 slave process.
2. Verify below statement alter diskgroup data add disk ‘/dev/oracle/disk100′,’dev/oracle/disk101′,’dev/oracle/disk102’ drop disk ‘/dev/oracle/disk197′,’dev/oracle/disk198′,’dev/oracle/disk199’ rebalance power 5;
a) The SQL statement will fail.
b) The SQL statement will add only the diskgroup.
c) The SQL statement will work if we remove DROP key word.
d) The SQL statement will succeed with mentioned disk addition and drop.
3. Statement to check voting disk
a) crsctl query css votedisk
b) crsctl query votedisk
d) srvctl query votedisk
d) srvctl query crs votedisk
 
4. Which of the following statement are valid in preparing storage for ASM
1) Maximize the number of disks in a disk group for maximum data distribution and higher I/O bandwidth.
2) Create large LUNs to reduce LUN management overhead.
3) ASMLIB provides an alternative interface for the ASM-enabled kernel to discover and access block devices in Linux.
4) Create LUNs using the outside half of disk drives for higher performance. If possible, use small disks with the highest RPM.
a) 1 and 3 are valid
b) 1,2 and 3 are valid
c) 2 and 4 are valid
d) all 4 statements are valid.
 
5. The entry CRS-1604 in alert_hostname.log stands for :
a) Regular message in alert_hostname.log.
b) a voting disk is not available.
c) Unknown issue in cluster service
d) Issue with interconnect.
 
6. Which of the following is a potential error in “installActions.log”
1) PRIF-10: failed to initialize the cluster registry
2) Configuration assistant “Oracle Private Interconnect Configuration Assistant” failed
3) KFOD-0311: Error scanning device device_path_name
4) ignoring upgrade failure of ocr(-1073740972)
a) only 1
b) only 2
c) 2 and 4
d) 1,2,3 and 4
 
7. For Oracle RAC on Windows Server 2003, which of the following commands need to be issued on all nodes to mount the disk ?
a) C:\> diskpart  / DISKPART> automount enable
b) C:\> automount enable
c) C:\> disk  / DISK> automount enable
d) C:\> diskpart  / DISKPART> mount enable
 
8. You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?
a) Data Pump Export and Import
b) conventional export and import
c) the CONVERT command of RMAN
d) the BACKUP AS COPY.. command of RMAN
 
9. Oracle Database 11g ASM instance has a disk group dg01 having three disks. One of the disks  in the disk group becomes unavailable because of power failure. The following command is issued  to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours: ALTER DISKGROUP dg01 SET ATTRIBUTE ‘disk_repair_time’ = ‘5h’;To which disks in the disk group will the new value be applicable?
a) all disks in the disk group
b) all disks that are currently in OFFLINE mode
c) all disks that are not currently in OFFLINE mode
d) all disks in the disk group only if all of them are ONLINE
 
10. Oracle Database 11g instance is managed with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group, which of the following ASMCMD command need to be used ? ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?
a) The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.
b) The command produces an error because the ASM instance is down.
c) The command succeeds but it shows only the status of the ASM instance.
d) The command succeeds but it retrieves only the disk names.
 
11. In which situations will the ASM metadata backup help you recover the ASM disk in a disk group?
a) when one of the disks in a disk group is accidentally unplugged
b) when the data file on an ASM disk group gets corrupted
c) when one or more disks in an ASM disk group are lost or more file directory paths are accidentally deleted
d) when one  from an ASM disk group