Free Download Oracle 1Z0-053 VCE Test Engine Full Version Now (161-170)

QUESTION 161
If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?

A.    The alter database archivelog command will fail.
B.    The alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG
mode.
C.    The alter database archivelog command will succeed.
D.    The alter database archivelog command will ask if you want to make the database consistent first.
E.    There is no alter database archivelog command. The correct command is alter database alterlogging.

Answer: A

QUESTION 162
Your archive-log destination directory runs out of space. What is the impact of this on the database?

A.    None. The database will switch over to the stand-by archive-log destination directory.
B.    A warning message will be written to the alert log of the database, but no adverse impacts to the
database will be experienced.
C.    The database will shut down, and will not restart until you correct the out-of-space situation.
D.    The database will continue to try to write to the archive-log destination directory for one hour.
After one hour, the database will shut down normally.
E.    Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until
the out-of-space condition is corrected.

Answer: E

QUESTION 163
How many individual archive-log destination directories are supported by Oracle Database11g?

A.    7
B.    1
C.    10
D.    11
E.    21

Answer: C

QUESTION 164
Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespace called USERS.
The database is still running. Which answer properly describes the rder of the steps that you would use to recover from this error?
a. Shut down the database.
b. Take the users_01.dbf datafile offline with the alter database command.
c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all users tablespace-related datafiles from backup media.
e. Issue the recover tablespace users command.
f. Issue the recover datafile users_01.dbf command.
g. Start up the database.
h. Bring the users_01.dbf datafile online with the alter database command.

A.    a, c, f, g
B.    b, c, f, h
C.    a, b, c, f, g
D.    a, b, c, f, g, h
E.    b, c, f, e, g

Answer: B

QUESTION 165
As soon as you discover that you have lost an online redo log, if the database is still functioning, what should be your first action?

A.    Shut down the database
B.    Clear the online redo log
C.    Back up the database
D.    Checkpoint the database
E.    Call Oracle support

Answer: D

QUESTION 166
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?
a. Mount the database with the startup mount command.
b. Take the SYSTEM datafile offline with the alter database command.
c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all SYSTEM tablespace-related datafiles from backup media.
e. Issue the recover tablespace SYSTEM command.
f. Issue the recover datafile SYSTEM_01.dbf command.
g. Open the database with the alter database open command.
h. Open the database with the alter database open resetlogs command.

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

Answer: D

QUESTION 167
You have discovered that one of three control files has been lost. What steps would you follow to recover that control file?
a. Shut down the database.
b. Restore a control-file copy from backup media.
c. Use the create control file command to create a new control file.
d. Copy the backup control file into place.
e. Create a new copy of the control file from one of the surviving control files.
f. Recover the database using the recover database using backup control file command.
g. Start up the database.

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

Answer: E

QUESTION 168
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

A.    Database datafiles
B.    Control files
C.    Archived redo logs
D.    Online redo logs
E.    Flashback logs

Answer: ABD

QUESTION 169
Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
a. Issue a checkpoint.
b. Shut down the database.
c. Issue an alter database open command to open the database.
d. Startup mount the database.
e. Issue an alter database clear logfile command.
f. Recover all database datafiles.

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

Answer: C
Explanation:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV90049
Recovering After Losing All Members of an Online Redo Log Group
If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure and the archiving mode of the database.
If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not. Table 30-4 outlines the various recovery scenarios.
Table 30-4 Recovering After the Loss of an Online Redo Log Group

image

QUESTION 170
What methods of point-in-time recovery are available? (Choose all that apply.)

A.    Change-based
B.    Cancel-based
C.    Time-based
D.    Sequence number-based
E.    Transaction number-based

Answer: ABCD

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

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

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back