[Free] 2018(Jan) Latesttests Testking Oracle 1z0-053 Dumps with VCE and PDF Download 101-110

Latesttests 2018 Jan Oracle Official New Released 1z0-053
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-053.html

Oracle Database 11g: Administration II

Question No: 101 – (Topic 2)

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.)

  1. V$LOGFILE

  2. V$RECOVER_LOG

  3. V$RECOVER_DATABASE

  4. V$LOG_RECOVER

  5. V$LOG

Answer: A,E

Question No: 102 – (Topic 2)

You are using the flash recovery area (fast recovery area in 11g Release 2) to store backup related files in your database. After regular monitoring of space usage in the Mash recovery area. You realize that the flash recovery area is (jetting filled up very fast and it is running out of space. Your database flash recovery area is low on specie and you have no more room on disk.

Proactively, which two options could you use to make more space available in the flash recovery [Choose two]

  1. Change the RMAN archived log deletion policy.

  2. Use the RMAN CROSSCHECK command to reclaim the archived log space.

  3. Change the RMAN retention policy to retain backups for a shorter period of time.

  4. Use OS command to move files from the flash recovery area to some other location

Answer: B,D

Question No: 103 – (Topic 2)

Which statement is true regarding the VALIDATE DATABASE command?

  1. It checks the database for intrablock corruptions only.

  2. It checks for block corruption in the valid backups of the database.

  3. It checks the database for both intrablock and interblock corruptions.

  4. It checks for only those corrupted blocks that are associated with data files.

Answer: A Explanation: interblock corruption

A type of block corruption in which the corruption occurs between blocks rather than within the block itself. This type of corruption can only be logical corruption.

intrablock corruption A type of block corruption in which the corruption occurs within the block itself. this type of corruption can be either a physical corruption or logical corruption.

Latesttests 2018 PDF and VCE

C:\Users\albo\Desktop\1-1.jpg

Question No: 104 – (Topic 2)

What command is used to reset a database to a previous incarnation?

  1. reset incarnation

  2. incarnation reset

  3. reset database to incarnation

  4. reset database incarnation

  5. reset databse incarnation number

Answer: C

Question No: 105 – (Topic 2)

You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DATABASE;

The next day, you issue the following command:

BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which statement about the use of the change tracking file is true?

  1. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.

  2. RMAN reads the block change tracking file when it performs both incremental backups.

  3. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.

  4. RMAN does not read the block change tracking file when it performs either incremental backup.

Answer: C

Question No: 106 – (Topic 2)

Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)

  1. Alert log file

  2. Archived redo log files

  3. Control file autobackups

  4. Server Parameter file (SPFILE)

  5. Recovery Manager (RMAN) backup piece

Answer: B,C,E

Question No: 107 – (Topic 2)

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.

What steps should you take to recover from this tempfile loss in an efficient manner?

  1. Allow the database to continue running, drop the TEMP tablespace, and then re-create it with new tempfiles

  2. Shut down the database, restore and recover the tempfile from backup, and then open the database with RESETLOGS

  3. Allow the database to continue running, take the TEMP tablespace offline, drop the missing tempfile, and then create a new tempfile

  4. Allow the database to continue running, add a new tempfile to TEMP tablespace with a new name, and drop the tempfile that has been corrupted.

Answer: D

Question No: 108 – (Topic 2)

How long will this backup be allowed to run?

Backup as compressed backupset duration 2:00 minimize load database;

  1. 2 minutes

  2. 2 hours

  3. 2 days

  4. The command will generate an error.

  5. This backup is not constrained by any time limitation.

Answer: B

Question No: 109 – (Topic 2)

What does the SCN represent?

  1. The system change number, which is a point in time relative to transactions within a given database.

  2. A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.

  3. The security change number, which represents the security code that is needed to access any database structure.

  4. A conversion factor that converts internal database time to external clock time.

  5. UTC time in the database, providing a standardized way of tracking time in Oracle.

Answer: A

Explanation:

SCN

System Change Number. A database ordering primitive.

The value of an SCN is the logical point in time at which changes are made to a database. Refer to v11.2 document

Question No: 110 – (Topic 2)

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:

LOG_ARCHIVE_DEST 1 = #39;LOCATION=/disk1/arch MANDATORY#39; LOG _ARCHIEVE_DEST 2 = #39;LOCATION=/disk2/arch#39; LOG_ARCHIVK_DEST_3 = #39;LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = #39;LOCATION=/disk4/arch#39; 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?

  1. The online redo log file is not allowed to be overwritten.

  2. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.

  3. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.

  4. 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.

Answer: D

100% Free Download!
Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-053 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE