Oracle Database 11g Administration II Version: 3.1 (Course: 1z0-053 Exam) Part-I

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

Write Down the your Full Name? *

Write Down the your Mobile Number? *

Topic 1, Database Architecture and ASM QUESTION NO: 1 The INV_HISTORY table is created using the command: *

1 point

A. It executes successfully, and the transition point is set to '1-apr-2006'.

B. It executes successfully, and the transition point is set to '15-apr-2006'.

C. It produces an error because the partitions specified for merging are not adjacent.

D. It produces an error because the date values specified in the merge do not match the date values stored in the table.

QUESTION NO: 2 You want to perform the following operations for the DATA ASM disk group: *

1 point

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;

QUESTION NO: 3 Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.) *

1 point

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.

Required

QUESTION NO: 4 What is the advantage of setting the ASM-preferred mirror read for the stretch cluster configuration? *

1 point

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.

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

1 point

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

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

1 point

A. ASMB

B. PMON

C. RBAL

D. SMON

QUESTION NO: 7 Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks? (Choose two.) *

1 point

A. Define the POWER option while adding or removing the disks.

B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.

D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

Required

QUESTION NO: 8 Identify three key features of ASM. (Choose three.) *

1 point

A. file striping

B. allocation unit mirroring

C. automatic disk rebalancing

D. automatic file size increment

E. automatic undo management

Required

QUESTION NO: 9 You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance: SQL> shutdown immediate; What is the result of executing this command? *

1 point

A. The ASM instance is shut down, but the other instances are still running.

B. It results in an error because other database instances are connected to it.

C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.

D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.

QUESTION NO: 10 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? *

1 point

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.

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms