1Z0-053 Free Sample Questions

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

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;