Oracle Database Administration and Development

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?

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 statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

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

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