IT-6203A - Advanced Database Management Systems oed answer key

Showing 81 to 100 of 139 total answers.

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

The types of user-managed backup you can perform are dependent on whether your database is running in ARCHIVELOG mode.

Answer

True

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Other datafiles required to recover the tablespace(s), such as the datafiles for the SYSTEM, UNDO, and TEMP tablespaces

Answer

auxiliary set

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Is in charge of redo log buffer management. It is one of the most active processes in an instance with heavy DML activity.

Answer

LGWR

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

To use guaranteed restore points, you must also enable these prerequisites: You must have a flash recovery area configured.

Answer

True

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

To use guaranteed restore points, you must also enable these prerequisites:The database must be running in ARCHIVELOG mode.

Answer

True

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

DUPLICATE command: OPEN RESTRICTED When the destination database is ready, open it immediately with the RESTRICTED SESSION option.

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Question text The SGA is a group of memory structures for an Oracle instance that are shared by the users of the database instance

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Which of the following background processes exist in both an ASM instance and an RDBMS instance, and also support ASM disk groups?

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

What happens to the rows in FLASHBACK_TRANSACTION_QUERY when part of the transaction is no longer available in the undo tablespace?

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

backup is the default type of incremental backup that backs up all changed blocks since the last level 0 or level 1 incremental backup

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

SQL Profiling Collect auxiliary statistics on a SQL statement along with partial execution statistics and store them in a SQL Profile.

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

key tuning parameters for the BACKUP command: _________ The maximum number of input files that a channel can have open at a given time.

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

If you do not use a recovery catalog, what data dictionary or dynamic performance views must you query to retrieve RMAN backup information?

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

To use guaranteed restore points, you must also enable these prerequisites: The COMPATIBLE initialization parameter must be 10.2 or higher.

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Before running the first replay, you must perform some prerequisite checks: Ensure that the target system has access to the replay directory

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

When using the VERSIONS BETWEEN clause for Flashback Version Query, what can’t you use to restrict the number of rows returned by the query?

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Using Database Replay consists of four main steps: 1. Workload capture 2. Workload preprocessing 3. Workload replay 4. Analysis and reporting

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

Backing up the control file for a database running in ARCHIVELOG mode produces the same end result as the method you use in NOARCHIVELOG mode.

#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems

When you want to create a duplexed backupset, what is the maximum number of copies of each backup piece you can create with one BACKUP command?

Page 5 of 7