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
SQL> ALTER TABLE inv_history
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
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?
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.)
Identify three key features of ASM. (Choose three.)
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM
instance. 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?
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?