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

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: 91 – (Topic 2)

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

  1. True

  2. False

Answer: A

Question No: 92 – (Topic 2)

If a backup is expired, which of the following is true?

  1. It can never be used for a restore/recover operation.

  2. Oracle will remove the backup set pieces from the flash recovery area.

  3. The backup has been used at least once to restore and recover the database.

  4. The backup is no longer valid because of a resetlogs operation.

  5. The physical backup set pieces are missing from the media.

Answer: E

Question No: 93 – (Topic 2)

Which command do you use to generate a report of database incarnations?

  1. list incarnation of database

  2. report incarnation of database

  3. list database incarnation

  4. database incarnation list

  5. report database incarnation

Answer: A Explanation:

LIST INCARNATION OF DATABASE prod3;

Question No: 94 – (Topic 2)

You have the following requirements in relation to the detection of block corruption for your database instance:

->Check for logical self-consistency of data blocks when modified in memory.

->Checksums are calculated before and after the block change.

->Checks are performed for the lost writes to the physical standby database.

Which method would help you perform the above checks automatically?

  1. Set the DB_SECUREFILE parameter to PERMITTED.

  2. Set the DB_ULTRA_SAFE parameter to DATA_ONLY.

  3. Set the DB_LOCK_CHECKSUM parameter to TYPICAL.

  4. Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

Answer: B Explanation:

Latesttests 2018 PDF and VCE

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

OFF

When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or

DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.

DATA_ONLY

->DB_BLOCK_CHECKING will be set to MEDIUM.

->DB_LOST_WRITE_PROTECT will be set to TYPICAL.

->DB_BLOCK_CHECKSUM will be set to FULL.

DATA_AND_INDEX

DB_BLOCK_CHECKING will be set to FULL. DB_LOST_WRITE_PROTECT will be set to TYPICAL. DB_BLOCK_CHECKSUM will be set to FULL.

Latesttests 2018 PDF and VCE

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

OFF or FALSE

No block checking is performed for blocks in user tablespaces. However, semantic block checking for SYSTEM tablespace blocks is always turned on.

LOW

Basic block header checks are performed after block contents change in memory (for example, after UPDATE or INSERT statements, on-disk reads, or inter-instance block transfers in Oracle RAC).

MEDIUM

All LOW checks and full semantic checks are performed for all objects except indexes (whose contents can be reconstructed by a drop rebuild on encountering a corruption).

FULL or TRUE

All LOW and MEDIUM checks and full semantic checks are performed for all objects.

Question No: 95 – (Topic 2)

Which of the following methods can be used to detect block corruption?

  1. ANALYZE operations

  2. dbv

  3. SQL queries that access the potentially corrupt block

  4. RMAN

  5. All of the above

Answer: E

Question No: 96 – (Topic 2)

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

  1. 7

  2. 1

  3. 10

  4. 11

  5. 21

Answer: C

Question No: 97 – (Topic 2)

Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th.

What do you do?

  1. Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.

  2. Tell them that their request cannot be met with the current backup strategy.

  3. Restore the 19ths backup, apply the online redo logs, and open the database.

  4. Switch the database into ARCHIVELOG mode, restore the 19th#39;s backup, restore all archived redo logs, and recover the database to the 20th.

  5. Use the recover database command to roll back the database from today to the 19th of the month.

Answer: B

Question No: 98 – (Topic 2)

What will be the result of the following configuration?

Log_archive_dest_1 = #39;location=c:\oracle\arch\mydb#39; Log_archive_dest_2 = #39;location=z:\oracle\arch\mydb#39;

  1. An error will occur during database startup because the second parameter is not valid.

  2. An error will occur during database startup since you are trying to create archived redo logs in two different locations.

  3. Archived redo logs will be created in two different locations by the ARCH process.

  4. Archived redo logs will be created in two different locations by the LGWR process.

  5. Neither parameter setting is valid, so the database will not start up.

Answer: C

Question No: 99 – (Topic 2)

The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)

  1. The initialization parameter should be set to 0 when the RMAN repository is being used.

  2. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.

  3. The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.

  4. The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.

  5. The initialization parameter should never be set to 0 if you are using RMAN.

Answer: C,E Explanation:

CONTROL_FILE_RECORD_KEEP_TIME specifies the minimum number of days before a reusable record in the control file can be reused. In the event a new record needs to be added to a reusable section and the oldest record has not aged enough, the record section expands. If this parameter is set to 0, then reusable sections never expand, and records are reused as needed.

If the number of reusable records in the control file exceeds the circular reuse record limit UB4MAXVAL, then reusable records will be overwritten even if CONTROL_FILE_RECORD_KEEP_TIME has not elapsed.

UB4MAXVAL is defined in the oratypes.h header file, which is found in the public directory. Its value may vary according to the operating system you are using.

Question No: 100 – (Topic 2)

Which is the correct command to put the database in ARCHIVELOG mode?

  1. alter database archivelog

  2. alter system enable archivelog mode

  3. alter database enable archive

  4. alter database archivelog enable

  5. None of the above

Answer: A

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