Oracle Database 11g: Administration II
Question No: 91 – (Topic 2)
Archived redo logs can be copied to more than one destination by Oracle.
Question No: 92 – (Topic 2)
If a backup is expired, which of the following is true?
It can never be used for a restore/recover operation.
Oracle will remove the backup set pieces from the flash recovery area.
The backup has been used at least once to restore and recover the database.
The backup is no longer valid because of a resetlogs operation.
The physical backup set pieces are missing from the media.
Question No: 93 – (Topic 2)
Which command do you use to generate a report of database incarnations?
list incarnation of database
report incarnation of database
list database incarnation
database incarnation list
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?
Set the DB_SECUREFILE parameter to PERMITTED.
Set the DB_ULTRA_SAFE parameter to DATA_ONLY.
Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.
Answer: B Explanation:
When any of DB_BLOCK_CHECKING, DB_BLOCK_CHECKSUM, or
DB_LOST_WRITE_PROTECT are explicitly set, no changes are made.
->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.
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.
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.
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).
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?
SQL queries that access the potentially corrupt block
All of the above
Question No: 96 – (Topic 2)
How many individual archive-log destination directories are supported by Oracle Database11g?
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?
Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th, and open the database.
Tell them that their request cannot be met with the current backup strategy.
Restore the 19ths backup, apply the online redo logs, and open the database.
Switch the database into ARCHIVELOG mode, restore the 19th#39;s backup, restore all archived redo logs, and recover the database to the 20th.
Use the recover database command to roll back the database from today to the 19th of the month.
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;
An error will occur during database startup because the second parameter is not valid.
An error will occur during database startup since you are trying to create archived redo logs in two different locations.
Archived redo logs will be created in two different locations by the ARCH process.
Archived redo logs will be created in two different locations by the LGWR process.
Neither parameter setting is valid, so the database will not start up.
Question No: 99 – (Topic 2)
The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter should be set to what value? (Choose all that apply.)
The initialization parameter should be set to 0 when the RMAN repository is being used.
The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the recovery catalog only.
The initialization parameter should be set to greater than 0 with the RMAN repository utilizing the control file or the recovery catalog.
The initialization parameter should be set to 0 with the RMAN repository utilizing the control file or the recovery catalog.
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?
alter database archivelog
alter system enable archivelog mode
alter database enable archive
alter database archivelog enable
None of the above
100% Free Download!
–Download Free Demo:1z0-053 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-053 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|