Wednesday, March 6, 2019

Oracle 1Z0-053 Exams dumps

Question 1

You want to perform the following operations for the DATA ASM disk group:
• Verify the consistency of the disk.
• Cross-check all the file extent maps and allocation tables for consistency.
• Check whether the alias metadata directory and file directory are linked correctly.
• Check that ASM metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

Answer: A 

Question 2

Which two statements are true regarding the functionality of the remap command in ASMCMD?
(Choose two.)

A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original
location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location
on disk if the blocks on the original location cannot be read properly.

Answer: A, D 

Question 3

What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration?

A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.

Answer: D

Explanation:
Preferred Read Failure Groups
When you configure Oracle ASM failure groups, it might be more efficient for a node to read from an
extent that is closest to the node, even if that extent is a secondary extent. In other words, you can
configure Oracle ASM to read from a secondary extent if that extent is closer to the node instead of
Oracle ASM reading from the primary copy which might be farther from the node. Using the
preferred read failure groups feature is most useful in extended clusters.

Question 4

Examine the following command:
ALTER DISKGROUP data MOUNT FORCE;
In which scenario can you use the above command to mount the disk group?

A. when ASM disk goes offline
B. when one or more ASM files are dropped
C. when some disks in a disk group are offline
D. when some disks in a failure group for a disk group are rebalancing

Answer: C 


Question 5

Which background process of a database instance, using Automatic Storage Management (ASM),
connects as a foreground process into the ASM instance?

A. ASMB
B. PMON
C. RBAL
D. SMON

Answer: A

Question 6


Identify three key features of ASM. (Choose three.)

A. file striping
B. allocation unit mirroring
C. automatic disk rebalancing
D. automatic file size increment
E. automatic undo management

Answer: A, B, C 

Question 7

You are managing an ASM instance. You previously issued the following statements:
ALTER DISKGROUP dg1 DROP DISK disk2;
ALTER DISKGROUP dg1 DROP DISK disk3;
ALTER DISKGROUP dg1 DROP DISK disk5;
You want to cancel the disk drops that are pending for the DG1 disk group.
Which statement should you issue?

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
B. ALTER DISKGROUP dg1 UNDROP;
C. ALTER DISKGROUP dg1 UNDROP DISKS;
D. You cannot cancel the pending disk drops.

Answer: C 

Question 8

What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?

A. The number of DBWR processes increases
B. The number of ASMB processes increases
C. The number of DBWR_TO_SLAVES increases
 7 / 20
D. The rebalancing operation in an ASM instance completes more quickly, but can result in higher I/O
overhead

Answer: D 

Question 9

ASM supports all but which of the following file types? (Choose all that apply.)

A. Database files
B. SPFILEs
C. Redo-log files
D. Archived log files
E. RMAN backup sets
F. Password files
G. init.ora files

Answer: F, G 

Question 10

Which of the following is not a configurable attribute for an individual disk group?

A. AU_SIZE
B. COMPATIBLE.RDBMS
C. COMPATIBLE.ASM
D. DISK_REPAIR_TIME
E. DG_DROP_TIME

Answer: E