Exam information

Exam 1Z0-043: Database 10g - Administration II

Other exams

Which two statements are correct in this scenario?

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.)

Identify four uses of the Oracle Scheduler. (Choose four.)


You executed the following command in Recovery Manager (RMAN) against your database:RMAN> REPORT OBSOLETE;What would you see in the output?

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?

In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?

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?

In which two conditions are resumable statements suspended? (Choose two.)

In which two sources would you find the DBID?

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?

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.)

Which three background processes would be involved when a log switch happens?

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.)

Which statement is correct?

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?

Which statement is true?

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?

Page 1 of 1912345...10...Last »