Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (181-190)

QUESTION 181
You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?

A.    Restore and recover the datafile.
B.    Restore and recover the tablespace.
C.    Restore and recover the database.
D.    Restore and recover the control file.
E.    Restore and recover the parameter file.

Answer: A

QUESTION 182
You are trying to recover your database. During the recovery process, you receive the following error:
ORA-00279: change 5033391 generated at 08/17/2008 06:37:40 needed for thread 1ORA-00289: suggestion : /oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc
ORA-00280: change 5033391 for thread 1 is in sequence #11
ORA-00278: log file ,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17
/o1_mf_1_10_4bj6wnqm_.arc no longer needed for this recovery Specify log:
{<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
,,/oracle01/flash_recovery_area/ORCL/archivelog/2008_08_17 /o1_mf_1_11_%u_.arc
ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3
How do you respond to this error? (Choose two.)

A.    Restore the archived redo log that is missing and attempt recovery again.
B.    Recovery is complete and you can open the database.
C.    Recovery needs redo that is not available in any archived redo log. Attempt to apply an online redo
log if available.
D.    Recover the entire database and apply all archived redo logs again.
E.    Recovery is not possible because an archived redo log has been lost.

Answer: AC

QUESTION 183
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

Answer: AE

QUESTION 184
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

Answer: A
Explanation:
You can enable block change tracking when the database is either open or mounted.
To enable block change tracking:
Start SQL*Plus and connect to a target database with administrator privileges.
Ensure that the DB_CREATE_FILE_DEST initialization parameter is set.
SHOW PARAMETER DB_CREATE_FILE_DEST
If the parameter is not set, and if the database is open, then you can set the parameter with the following form of the ALTER SYSTEM statement:
ALTER SYSTEM SET
DB_CREATE_FILE_DEST = ‘/disk1/bct/’
SCOPE=BOTH SID=’*’;
Enable block change tracking.
Execute the following ALTER DATABASE statement:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
You can also create the change tracking file in a location that you choose yourself by using the following form of SQL statement:
ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
USING FILE ‘/mydir/rman_change_track.f’ REUSE;
The REUSE option tells Oracle Database to overwrite any existing block change tracking file with the specified name.
http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmbckba.htm#BRADV8125

QUESTION 185
What type of backup is stored in a proprietary RMAN format?

A.    Backup set
B.    Image copy
C.    Backup section
D.    Backup group

Answer: A
Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV90108
Backup set
A backup of one or more data files, control files, server parameter files, and archived redo log files. Each backup set consists of one or more binary files. Each binary file is called a backup piece. Backup pieces are written in a proprietary format that can only be created or restored by RMAN.
Backup sets are produced by the RMAN BACKUP command. A backup set usually consists of only one backup piece. RMAN divides the contents of a backup set among multiple backup pieces only if you limit the backup piece size using the MAXPIECESIZE option of the ALLOCATE CHANNEL or CONFIGURE CHANNEL command.

QUESTION 186
Consider the following command:
Backup database plus archivelog delete input;
How many backup sets would be created by this command if the following were true:
Control-file a NN uto backups were enabled.
NN The size of backup sets was not restricted.
NN One channel was allocated.

A.    1
B.    2
C.    3
D.    4
E.    5

Answer: D

QUESTION 187
Compressed backups work with which of the following commands?

A.    copy as backup
B.    backup as copy
C.    backup
D.    copy

Answer: C

QUESTION 188
Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

A.    backup database
B.    backup database and archivelogs
C.    backup database plus archivelogs
D.    backup database plus archivelog delete input
E.    backup database and archivelog delete input

Answer: D

QUESTION 189
Which of the following best describes a full backup?

A.    All datafiles of a database
B.    All datafiles, archive logs, and control files
C.    All datafiles and control files
D.    All the used blocks in a datafile

Answer: D

QUESTION 190
Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

A.    Differential incremental backup
B.    Different incremental backup
C.    Cumulative backup
D.    Cumulative incremental backup

Answer: A
Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/glossary.htm#BRADV90151
differential incremental backup
A type of incremental backup that backs up all blocks that have changed since the most recent backup at level 1 or level 0. For example, in a differential level 1 backup RMAN determines which level 1 or level 0 incremental backup is most recent and then backs up all blocks changed since that backup. Differential backups are the default type of incremental backup. When recovering using differential incremental backups, RMAN must apply all differential incremental level 1 backups since the restored data file backup.
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmcncpt.htm#BRADV89500
Differential Incremental Backups
In a differential level 1 backup, RMAN backs up all blocks that have changed since the most recent incremental backup at level 1 (cumulative or differential) or level 0. For example, in a differential level 1 backup, RMAN determines which level 1 backup occurred most recently and backs up all blocks modified after that backup. If no level 1 is available, then RMAN copies all blocks changed since the base level 0 backup.
If no level 0 backup is available in either the current or parent incarnation, then the behavior varies with the compatibility mode setting. If compatibility is >=10.0.0, RMAN copies all blocks that have been changed since the file was created. Otherwise, RMAN generates a level 0 backup.

If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-053.html