Category: 1Z0-053 (v.3)

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

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 the
command:
SQL> ALTER TABLE inv_history
MERGE PARTITIONS
FOR(TO_DATE(’15-feb-2006′,’dd-mon-yyyy’)),
FOR(TO_DATE(’15-apr-2006′))
INTO PARTITION sys_py;
What would be the outcome of this command?

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 metadata directories do not have unreachable allocated blocks.
Which command accomplishes these tasks?

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

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.)


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