IT-6203A - Advanced Database Management Systems oed answer key
Showing 21 to 40 of 139 total answers.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
The SQL Tuning Advisor performs all but which of the following analyses?
Answer
Changes to materialized views
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Under what circumstances would you use the RMAN command UPGRADE CATALOG?
Answer
When you are using a version of the recovery catalog that is older than that required by the RMAN target database client.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following statement is not true regarding database backups?
Answer
As of Oracle Database 11g, RMAN supports only online backups.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Recorded client request contains the information: Transaction information
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the difference between a full backup and a whole database backup?
Answer
A full backup consists of a backup of one or more datafiles or tablespaces, whereas a whole database backup contains all datafiles, for all tablespaces plus the control file.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following commands does not back up the current control file?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following is not a valid status for an online redo log group?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
You can use DELETE_REPLAY_INFO to delete a report in the replay directory.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Identify the true statement regarding incremental and differential backups.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Recovery falls into one of two general categories: complete and incomplete.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
To enable password encryption for a specific backup, use the ______ command
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following clauses is not valid for the RMAN DUPLICATE command?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
backups back up all changed blocks since the last level 0 incremental backup
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What are the default characteristics of an ASM file created with no options?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following roles should you grant to the recovery catalog owner?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
contains two major subcaches: the library cache and the data dictionary cache.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
What is the difference between an RMAN local script and an RMAN global script?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Identify the correct statement regarding duplicate databases created with RMAN.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems