After executing the command alter diskgroup disk group2 drop disk dg2a; you issue the following command from the ASM instance:
Select group_number, count(*) from v$asm_operation;
What is the implication if the query against V$ASM_OPERATION returns zero rows?
A. The drop disk operation is still proceeding and you cannot yet run the undrop disks operation.
B. The drop disk operation is complete and you can run the undrop disks command if needed.
C. The drop disk operation is complete and you cannot run the undrop disk command.
D. The query will fail since there is not a V$ASM_OPERATION view available in an ASM instance.
E. None of the above is true.
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups. Identify two options for completing this task. (Choose two.)
A. Reregistering the target database in recovery catalog
B. Transporting the new tablespaces to the recovery catalog database
C. Syncronizing the recovery catalog with the target database control file
D. Performing a fresh backup of the target database to include the new data files in the catalog database
Which three statements are true regarding persistent lightweight jobs? (Choose three.)
A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
B. The user cannot set privileges on persistent lightweight jobs.
C. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
D. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
E. The use of a template is mandatory to create persistent lightweight jobs.
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)
A. The user has dropped an important table that needs to be recovered.
B. The database files are corrupted when the database is open.
C. You are not able to start up the database instance because the required database files are missing.
D. The archived log files are missing for which backup is not available.