多项选择题
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available.
Which three files would be used in the user-managed recovery process performed by the database administrator （）(DBA)? (Choose Three)
A. Redo logs
B. Control file
C. The latest backup of only the damaged data file
D. The latest backup of all the data file in the USERS tablespace
E. Temporary files of temporary tablespace
F. Archive Logs since the latest backup to point of failure
相关考题
-
单项选择题
Evaluate the following command： SQL>ALTER SYSTEM SET db_securefile = ’IGNORE’； What is the impact of this setting on the usage of SecureFiles？（）
A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile -
单项选择题
You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）
A. Run Segment Advisor
B. Run the SQL Tuning Advisor (STA)
C. Run the Automatic Workload Repository (AWR) report
D. Run the SQL Access Advisor with a hypothetical workload -
单项选择题
You issued the following commands to configure setting in RMAN; RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1; RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2; RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2; Then you issued the following command to take the backup: RMAN> BACKUP DATABASE PLUS ARCHIVELOG; Which statement is true about the execution of the above command?（）
A. The backup will terminate because the FORMAT clause was not configured for the channel
B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape
C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file
D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file
