1Z0-053章节练习(2019.11.04)

单项选择题
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?（）
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
单项选择题
Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation？（）
A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP
多项选择题
What two are the prerequisites for enabling Flashback Database？（）
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
单项选择题
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup， you issued the following RMAN command： RMAN>BACKUP SECTION SIZE 300M TABLESPACE users； What configuration should be effected to accomplish faster and optimized backups by using the above command？（）
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
单项选择题
What is the default value for the ENABLED attribute of a job or program when it is created？（）
A. TRUE
B. FALSE
C. There is no default. It must be defined at creation time.
D. PENDING
E. NULL
单项选择题
Your database has a backup that was taken yesterday （Tuesday） between 13：00 and 15：00 hours. This is the only backup you have. You have lost all the archived redo logs generatedsince the previous Monday， but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database？（）
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.
单项选择题
You plan to control idle sessions that are blocking other sessions from performing transactions.Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?（）
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)
多项选择题
Which files are required for a full recovery of the database in ARCHIVELOG mode？（）
A. Database datafiles
B. Online redo logs
C. Archived redo logs
D. Backup control file
E. Control file from a backup
单项选择题
Which of the following is not a configurable attribute for an individual disk group？（）
A. AU_SIZE
B. COMPATIBLE·RDBMS
C. COMPATIBLE·ASM
D. DISK_REPAIR_TIME
E. DG_DROP_TIME
多项选择题
To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）
A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME