You executed the following query:SELECT oldest_flashback_scn, oldest_flashback_timeFROM V$FLASHBACK_DATABASE_LOG;Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the tablespace in backup mode:SQL> ALTER TABLESPACE users BEGIN BACKUP;While copying the file to the backup destination a power outage caused the instance to terminate abnormally.Which statement is true about the next database startup and the userstablespace?
Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:RMAN> RUN -{ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;DUPLICATE TARGET DATABASE TO auxdb;}Which statement is true about the duplicate database in this scenario?
The Automatic Workload Repository (AWR) snapshot interval is set to 1 hour. A user of your database notifies you that the system was slow between 10:00 PM and 10:10 PM, but the Automatic Database Diagnostic Management (ADDM) analysis for the time period between 10:00 PM and 11:00 PM does not show this performance problem.What would you suggest to analyze this performance problem for the user?
In which two situations would you rebuild an index using the ALTER INDEX----- REBUILD command?
