Online Access Free 1Z0-053 Exam Questions

You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire database. You noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?
1.STARTUP NOMOUNT
2.ALTER DATABASE OPEN RESETLOGS
3.SQL "ALTER DATABASE RENAME 'logfile1' path TO '+dgrp4'" # plus all other
4.SWITCH DATABASE TO COPY
5.BACKUP AS COPY DATABASE FORMAT '+dgrp4'
6.ALTER DATABASE MOUNT
7.RESTORE CONTROLFILE FROM 'controlfile_location'
logfiles

• A.5, 1, 2, 7, 4, 6, 3
• B.7, 3, 1, 5, 6, 2, 4
• C.2, 5, 3, 1, 7, 6, 4
• D.1, 7, 6, 5, 4, 3, 2

You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the following commands to compete this task?
a.restore controlfile until time '09/30/2008:18:00:00';
b.restore database until time '09/30/2008:18:00:00';
c.restore spfile until time '09/30/2008:18:00:00';
d.recover database until time '09/30/2008:18:00:00';
e.alter database open resetlogs;
f.alter database open;

• A.b, d, f
• B.c, a, b, d, e
• C.a, b, d, e
• D.c, a, b, d, f
• E.b, d, e

Which of the following options describes Segment Shrink?

• A.Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
• B.Deallocates space above the high-water mark that is currently not in use
• C.Reclaims space above and below the high-water mark without using additional space
• D.None of the above

Which statement about recovering from the loss of a redo log group is true?

• A.If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
• B.If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
• C.If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
• D.If the lost redo log group is CURRENT, you must clear the log file.

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A.Undo retention guarantee must be enabled.
• B.Automatic undo management must be enabled.
• C.The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).
• D.Database must be running in archivelog mode.