Identify four uses of the Oracle Scheduler. (Choose four.)
View the Exhibit.
A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery, you choose 2004343 as the Flashback SCN.
Which two statements are correct in this scenario? (Choose two.)
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager (RMAN) against your database:
RMAN> REPORT OBSOLETE;
What would you see in the output?
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?
In which two conditions are resumable statements suspended? (Choose two.)
You are connected to Recovery Manager (RMAN) without a recovery catalog.
There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup, you need the database ID (DBID).
In which two sources would you find the DBID? (Choose two.)
You executed the following command in Recovery Manager (RMAN) to perform a backup of the DETTBS tablespace:
RMAN> BACKUP TABLESPACE DETTBS;
Under which conditions would this command execute successfully? (Choose all that apply.)
You want to create a consumer group, GROUP1, and you execute the following command in the command-line interface:
SQL> EXEC DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(
COMMENT => ‘New Group’);
This command errors out displaying the following message:
ERROR at line 1:
ORA-29371: pending area is not active
ORA-06512: at “SYS.DBMS_RMIN”, line 115
ORA-06512: at “SYS.DBMS_RESOURCE_MANAGER”, line 108
ORA-06512: at line 1
What action would you take to overcome this error?
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? (Choose three.)