You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 =
'LOCATION=/disk2/arch'
LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch
LOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch'
LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.
What happens in an event of log switch?
A. The online redo log file is not allowed to be overwritten.
B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th.
A. Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
B. Tell them that their request cannot be met with the current backup strategy.
C. Restore the 19ths backup, apply the online redo logs, and open the database.
D. Switch the database into ARCHIVELOG mode, restore the 19th's backup, restore all archived redo logs, and recover the database to the 20th.
E. Use the recover database command to roll back the database from today to the 19th of the month.
What does the SCN represent?
A. The system change number, which is a point in time relative to transactions within a given database.
B. A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.
C. The security change number, which represents the security code that is needed to access any database structure.
D. A conversion factor that converts internal database time to external clock time.
E. UTC time in the database, providing a standardized way of tracking time in Oracle.
During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)
A. V$LOGFILE
B. V$RECOVER_LOG
C. V$RECOVER_DATABASE
D. V$LOG_RECOVER
E. V$LOG
How is block-change tracking enabled?
A. With alter database enable block change tracking
B. With alter system enable block change tracking
C. With an init.ora parameter change
D. With an spfile parameter change
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
A. The initialization parameter should be set to 0 when the RMAN repository is being used.
B. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.
C. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
D. The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.
E. The initialization parameter should never be set to 0 if you are using RMAN.
You run the following commands:
RMAN> list expired backup; RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command?
A. They will be renamed.
B. Nothing will happen to them. The backup set pieces do not exist.
C. They will be deleted immediately since they are not in the flash recovery area.
D. You will need to manually remove the physical files listed in the output of the commands.
E. They will become hidden files and removed 10 days later.
What does it mean if a backup is expired?
A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.
B. The backup set has one or more invalid blocks in it and is not usable for recovery.
C. The backup set contains one or more tablespaces no longer in the database.
D. The backup set contains one or more missing backup set pieces.
E. The backup set is from a previous version of RMAN and was not upgraded.
How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database;
A. 2 minutes
B. 2 hours
C. 2 days
D. The command will generate an error.
E. This backup is not constrained by any time limitation.
If a backup is expired, which of the following is true?
A. It can never be used for a restore/recover operation.
B. Oracle will remove the backup set pieces from the flash recovery area.
C. The backup has been used at least once to restore and recover the database.
D. The backup is no longer valid because of a resetlogs operation.
E. The physical backup set pieces are missing from the media.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-053 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.