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 […]
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 […]
Which two statements are true regarding the functionality of the remap command inASMCMD? (Choose two.)
What is the advantage of setting the ASM-preferred mirror read for the stretch clusterconfiguration?
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 additionor removal process is completed, and then gradually becomes normal.Which two activities would you perform to […]
Identify three key features of ASM. (Choose three.)
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASMinstance. 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?