Home
  • Home
  • Database
  • Oracle Database 11g Administrator Certified Professional (OCP)
36.
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
  • Answer & Explanation
  • Report
Answer : [E]
Explanation :
The default AU size is 1MB, and 64MB is the maximum AU size for a disk group.
Report
Name Email  
37.
What is the result of increasing the value of the parameter ASM_POWER_LIMIT during a rebalance operation?
  • A.
    The ASM rebalance operation will likely consume fewer resources and complete in a shorter amount of time.
  • B.
    The ASM rebalance operation will consume fewer resources and complete in a longer amount of time.
  • C.
    The ASM rebalance operation will be parallelized and should complete in a shorter amount of time.
  • D.
    There is no ASM_POWER_LIMIT setting used in ASM.
  • E.
    None of the above.
  • Answer & Explanation
  • Report
Answer : [C]
Explanation :
Increasing the value of ASM_POWER_LIMIT will increase the degree of parallelism of the rebalance operation, which may help to increase the performance of that operation.
Report
Name Email  
38.
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.
  • Answer & Explanation
  • Report
Answer : [A]
Explanation :
When a disk fails, it is taken offline immediately but it is not dropped at that time. By default, you will have 3.6 hours to correct the problem before ASM will automatically drop the disk. You can configure this time by modifying the disk attributes.
Report
Name Email  
39.
What components are present in an ASM instance? (Choose three.)
  • A.
    SGA
  • B.
    Database processes
  • C.
    Database datafiles
  • D.
    Control files
  • E.
    Database parameter file or spfile
  • Answer & Explanation
  • Report
Answer : [A, B, E]
Explanation :
Option A is correct because the SGA is allocated when the ASM instance is started. Option B is correct because the Oracle processes are also started when the ASM instance is started. Option E is correct because the ASM instance requires either a parameter file or an spfile.
Report
Name Email  
40.
What are three benefits of using ASM? (Choose three.)
  • A.
    Ease of disk administration and maintenance
  • B.
    Load balancing across physical disks
  • C.
    Software RAID-1 data redundancy with double or triple mirrors.
  • D.
    Automatic recovery of failed disks
  • Answer & Explanation
  • Report
Answer : [A, B, C]
Explanation :
Option A is correct because ASM makes administration and maintenance of disks much easier. Option B is correct because ASM provides for load balancing across the physical disks for better performance. Answer C is correct because ASM provides RAID-1 redundancy via double or triple mirrors.
Report
Name Email