Exam information

Exam 1Z0-053: Oracle Database 11g: Administration II (update July 25th, 2016)

Other exams

What would be the outcome of this command?


The INV_HISTORY table is created using the command:The following data has been inserted into the INV_HISTORY table:You would like to store the data belonging to the year 2006 in a single partition and issue thecommand:SQL> ALTER TABLE inv_historyMERGE […]

Which command accomplishes these tasks?

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 […]

Which two statements are true regarding the functionality of the remap command in ASMCMD?

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

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

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

which scenario can you use the above command to mount the disk group?

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


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

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

Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?

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 additionor removal process is completed, and then gradually becomes normal.Which two activities would you perform to […]

(Choose three.)

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

What is the result of executing this command?

You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASMinstance. 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?

Which statement should you issue?

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?

Page 1 of 7012345...102030...Last »