1Z0-053章節(jié)練習(xí)(2019.11.04)

A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor, with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D. All of the above

A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP

A. The database must be in ARCHIVELOG mode
B. The database must be in MOUNT EXCLUSIVE mode
C. The database must be opened in RESTRICTED mode
D. The database instance must be started in the NOMOUNT state
E. The database instance must have the keep buffer pool defined

A. The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1
B. The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
C. The SBT channel must be configured， with the parallelism setting for the SBT device set to 3
D. The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB

A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D. PENDING
E. NULL

A. 13：00 on Tuesday.
B. 15：00 on Tuesday.
C. Up until the last available archived redo log on Sunday.
D. To any point； all the redo should still be available in the online redo logs.
E. The database is not recoverable.

A. Set metric threshold
B. Implement Database Resource Manager
C. Enable resumable timeout for user sessions
D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

A. Database datafiles
B. Online redo logs
C. Archived redo logs
D. Backup control file
E. Control file from a backup

A. AU_SIZE
B. COMPATIBLE·RDBMS
C. COMPATIBLE·ASM
D. DISK_REPAIR_TIME
E. DG_DROP_TIME

A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME