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

backout options: NOCASCADE Back out only the specified transaction, if possible.

Page 2 of 7