Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (151-160)

QUESTION 151
Which command will result in a trace file being created with the create controlfile command contained in it?

A.    alter database backup controlfile;
B.    alter database backup controlfile to trace;
C.    alter database controlfile backup;
D.    alter database controlfile backup to ‘/ora01/oracle/ctrl_backup.ctl’;
E.    alter database begin controlfile backup;

Answer: B
Explanation:
Backing Up Control Files
Use the ALTER DATABASE BACKUP CONTROLFILE statement to back up your control files. You have two options:
Back up the control file to a binary file (duplicate of existing control file) using the following statement:
ALTER DATABASE BACKUP CONTROLFILE TO ‘/oracle/backup/control.bkp’;
Produce SQL statements that can later be used to re-create your control file:
ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
This command writes a SQL script to a trace file where it can be captured and edited to reproduce the control file. View the alert log to determine the name and location of the trace file.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/control.htm#i1006485

QUESTION 152
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode?

A.    alter tablespace DAVE_TBS backup mode;
B.    alter tablespace DAVE_TBS start backup;
C.    alter tablespace DAVE_TBS begin backup;
D.    alter tablespace DAVE_TBS backup begin;
E.    alter tablespace DAVE_TBS backup;

Answer: C
Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osbackup.htm#BRADV488
Making User-Managed Backups of Online Read/Write Tablespaces
You must put a read/write tablespace in backup mode to make user-managed data file backups when the tablespace is online and the database is open.
The ALTER TABLESPACE … BEGIN BACKUP statement places a tablespace in backup mode.
In backup mode, the database copies whole changed data blocks into the redo stream. After you take the tablespace out of backup mode with the ALTER TABLESPACE … END BACKUP or ALTER DATABASE END BACKUP statement, the database advances the data file checkpoint SCN to the current database checkpoint SCN.
When restoring a data file backed up in this way, the database asks for the appropriate set of redo log files to apply if recovery is needed. The redo logs contain all changes required to recover the data files and make them consistent.

QUESTION 153
Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?

A.    Yes, if the database is in ARCHIVELOG mode.
B.    Yes, if the database is in NOARCHIVELOG mode.
C.    No, the backup is not usable in any way.
D.    Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.

Answer: C

QUESTION 154
Which is not a valid way of backing up a control file?

A.    Backing up the control file to trace
B.    Copying the existing control file of the database to the backup location during a hot backup
C.    Copying the existing control file of the database to the backup location during a cold backup
D.    Creating a backup control file
E.    Using the create controlfile command

Answer: B

QUESTION 155
Which of the following parameters defines the location where Oracle should create archived redo logs?

A.    LOG_ARCHIVE_1
B.    LOG_DESTINATION_1
C.    LOG_ARCHIVED_DESTINATION_1
D.    LOG_ARCHIVE_DEST_1
E.    LOG_ARCHIVE_SOURCE_1

Answer: D
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e41134/log_arch_dest_param.htm#SBYDB01107
The LOG_ARCHIVE_DEST_n initialization parameter defines up to 31 (where n = 1, 2, 3, … 31) destinations, each of which must specify either the LOCATION or theSERVICE attribute to specify where to archive the redo data. All other attributes are optional. Note that whether you are specifying the LOCATION attribute or theSERVICE attribute, it must be the first attribute supplied in the list of attributes.
LOG_ARCHIVE_DEST_1 through LOG_ARCHIVE_DEST_10 destinations can contain either a LOCATION attribute or a SERVICE attribute.
LOG_ARCHIVE_DEST_11 through LOG_ARCHIVE_DEST_31 destinations can only contain a SERVICE attribute.

QUESTION 156
Archived redo logs can be copied to more than one destination by Oracle.

A.    True
B.    False

Answer: A

QUESTION 157
What will be the result of the following configuration?
Log_archive_dest_1=location=c:\oracle\arch\mydb
Log_archive_dest_2=location=z:\oracle\arch\mydb

A.    An error will occur during database startup because the second parameter is not valid.
B.    An error will occur during database startup since you are trying to create archived redo logs in two
different locations.
C.    Archived redo logs will be created in two different locations by the ARCH process.
D.    Archived redo logs will be created in two different locations by the LGWR process.
E.    Neither parameter setting is valid, so the database will not start up.

Answer: C

QUESTION 158
Which view provides information on the backup status of the datafiles in the database?

A.    V$BACKUP
B.    V$BACKUP_STATUS
C.    V$BACKUP_DATAFILE
D.    V$DATAFILE_BACKUP
E.    V$TABLESPCE_BACKUP

Answer: A
Explanation:
http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1044.htm#REFRN30017

QUESTION 159
Another DBA issues a shutdown abort command on a database on which you were running an online backup. What will happen when you try to restart the database?

A.    Oracle will automatically take the datafile out of hot backup mode, generate a warning message,
and then open the database.
B.    Oracle will automatically take the datafile out of hot backup mode and then open the database.
C.    Oracle will generate an error when trying to open the database, indicating that a datafile is in hot
backup mode.
You will need to correct this error before you can open the database.
D.    The database will open with the file in hot backup mode. You can restart the backup at any time.
E.    The datafile in hot backup mode will be corrupted and you will have to recover it.

Answer: C

QUESTION 160
What is the proper command to shut down the database in a consistent manner?

A.    Shutdown abort
B.    Shutdown kill
C.    Shutdown nowait
D.    shutdown immediate
E.    shutdown halt

Answer: D

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

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