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 metadatadirectory and file directory are linked correctly. Check that ASM metadata directories do not have unreachableallocated blocks.Which command accomplishes these tasks? A. ALTER […]

Read More

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_historyMERGE PARTITIONSFOR(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, […]

Read More