Free 1z0-083 Exam Dumps

Question 31

Which two are true about instance recovery? (Choose two.)

A. It is not possible if an archived log is missing.
B. It is performed automatically after the database is opened; however, blocks requiring recovery are not available until they are recovered.
C. Setting FAST_START_MTTR_TARGET to a lower value reduces instance recovery time by causing dirty buffers to be written to disk more frequently, thereby reducing the number of I/Os needed during instance recovery.
D. It is performed by the Recovery Writer (RVWR) background process.
E. Setting FAST_START_MTTR_TARGET to a higher value reduces instance recovery time bycausing the log writer to write more frquently, thereby reducing the number of I/Os needed during instance recovery.
F. It is performed automatically while the database remains in MOUNT stat
G. Then the database is opened.

Correct Answer:EF

Question 32

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

A. A PDB snapshot is always a full copy of the source PDB.
B. A PDB snapshot is always a sparse copy of the source PDB.
C. A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
D. A PDB snapshot depends on a storage snapshot which can be stored on any file system.
E. A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
F. A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
G. A snapshot copy PDB can be created from a stand-alone clone PDB.

Correct Answer:AE

Question 33

While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck.
FORCE LOGGING is enabled for the database.
Which two could improve read performance? (Choose two.)

A. Increase the size of tape I/O buffers.
B. Disable FORCE LOGGING for the database.
C. Increase the size of the database buffer cache.
D. Enable asynchronous disk I/O.
E. Increase the level of RMAN multiplexing.

Correct Answer:DE

Question 34

Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

A. Using the Data Recovery Advisor LIST FAILURE command always requires that the databasefor which failures are to be listed is in MOUNT state.
B. A failure can be closed only when it has been repaired.
C. Data Recovery Advisor can be used if a database is closed.
D. The Data Recovery Advisor CHANGE FAILURE command can be used only to changefailure priorities.
E. Data Recovery Advisor can proactively check for failures.

Correct Answer:DE

Question 35

Which two are true about Oracle instance recovery? (Choose three.)

A. Recovery begins from the beginning of the CURRENT redo log group.
B. Recovery begins from the last checkpoint position that wascalculated by the Database Writer before instance failure.
C. Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE.
D. Recovery reads redo until the end of the redo threa
E. SMON rollsback any dead transactions, and then the datanase is opened.
F. Recovery begins from the last checkpoint position that was recorded in the control file by the checkpoint process (CKPT).
G. Recovery reads redo until the end of the redo thread, and then opens the databas
H. SMON then rolls back any dead transactions.

Correct Answer:BDF