Free 1z0-083 Exam Dumps

Which two are true about the Oracle dataabsemethodology? (Choose two.)

A. The Oracle Database time model should be used to find the database and instance areas most in need of tuning.
B. Tuning activities should stop once the user is satisfied with performance.
C. Tuning activities should stop onceagreed service levels for performance have been met.
D. The database instance memory should always be tuned before tuning any file systems.
E. SQL statements should always be tuned before tuning any file systems.
F. The alert log should be used to find the database and instance areas most in need of tuning.

Correct Answer:CF

Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)

Correct Answer:BC

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

Which three are true about Database Point-in-Time Recovery? (Choose three.)

A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
B. Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.
C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
D. The Database must be in ARCHIVELOG mode.
E. The target point for the recovery must bespecified as a stime or System Change Number (SCN).
F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

Correct Answer:BDF
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database point-in%

Which four are true about RMAN backup sets? (Choose four.)

A. A backup piece can belong to only one backup set.
B. A data file can be split into multiple sections stored in different backup sets.
C. A data file canbe split into multiple sections stored in different backup pieces in the same backup set.
D. Blocks from multiple data files can be contained in one backup piece,
E. A backup set can contain only one backup piece.
F. A backup set must be written to media.
G. A backup set must be written to disk.
H. Blocks from multiple data files can be contained in one backup set,

Correct Answer:BEFH