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 […]
Identify four uses of the Oracle Scheduler. (Choose four.)
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.)
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.)
On Monday, you dropped the DEPT table from your schema and then you re-created the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?
You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager (RMAN), you migrate the complete production database to use the ASM instance. Which statement is true?