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

Showing 121 to 139 of 139 total answers.

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

SCN-based incomplete recovery works well if your applications save the SCN at critical points in a process flow, or the alert or trace logs indicate a serious error as of a particular SCN.

Answer

True

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

A default installation of the Oracle database using the Oracle Universal Installer with a seed database, or using the Database Creation Assistant, will automatically create a password file.

Answer

True

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

You have configured backup optimization for your database using CONFIGURE BACKUP OPTIMIZATION ON. For which of the following commands will RMAN not skip a backup if the files are identical?

Answer

BACKUP TABLESPACE USERS;

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

In the case of a system crash or instance failure, due to a power outage or CPU failure, the ______, performs crash recovery by applying the entries in the online redo log files to the datafiles.

Answer

system monitor

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

You have just received a pager alert indicating that the flash recovery area is below 3 percent free space. Which view and column can you query for a possible corrective action for this space condition?

Answer

DBA_OUTSTANDING_ALERTS, SUGGESTED_ACTION

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

The SQL Tuning Advisor analyzes one or more SQL statements sequentially, examining statistics, and potentially recommends creating a SQL profile, new indexes, materialized views, or a revised SQL statement.

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

Before running the first replay, you must perform some prerequisite checks:Remap references to other production systems via database links, external .tables, directory objects, URLs, and E-mail notifications.

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

is an optional area of the SGA. It is used for transactions that interact with more than one database, message buffers for processes performing parallel queries, and RMAN parallel backup and restore operations.

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

Your database is running in NOARCHIVELOG mode, and you perform occasional incremental level 1 backups in MOUNT mode. To what point in time can you recover the database if you lose a datafile for the USERS tablespace?

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

The database buffer cache holds blocks of data from disk that have been recently read to satisfy a SELECT statement or that contain modified blocks that have been changed or added from a Data Manipulation Language (DML) statement.

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

Your server’s physical memory is 8GB and no other applications or Oracle instances are running on the server. For a new Oracle instance running a decision support system, what is a good starting point for setting PGA_AGGREGATE_TARGET?

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

Place the following commands in the correct order for restoring a control file from an RMAN autobackup: 1. RECOVER DATABASE 2. ALTER DATABASE OPEN RESETLOGS 3. STARTUP NOMOUNT 4. ALTER DATABASE MOUNT 5. RESTORE CONTROLFILE FROM AUTOBACKUP

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

You have created a virtual private catalog to separate your RMAN administration duties among several DBAs for 20 different databases. Which role must you grant to each virtual catalog owner to allow the person to access existing registered databases?

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

The net service name of your target database is DW and the net service name of your recovery catalog database is RCAT. The environment variable ORACLE_SID has a value of RCAT. Which of the following sets of commands will successfully create a recovery catalog?

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

You have lost all online control files. Specify the correct order for the following tasks: · Restore the control file from backup or run CREATE CONTROLFILE. · Start database recovery and specify the keywords BACKUP CONTROLFILE. · Start up the database in MOUNT mode. · Open the database with RESETLOGS. · Shut down the database.

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

Choose the four best commands from the following list that you would use to enable ARCHIVELOG mode, and put them in the correct order: 1. STARUP MOUNT 2. SHUTDOWN ABORT 3. ALTER DATABASE ARCHIVELOG; 4. STARTUP FORCE 5. ALTER DATABASE ENABLE ARCHIVELOG; 6. ALTER SYSTEM SWITCH LOGFILE; 7. SHUTDOWN NORMAL 8. ALTER DATABASE OPEN; 9. SHUTDOWN IMMEDIATE

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

You have lost the most recent archived redo log files from the recovery catalog database as well as the tablespace containing the RMAN catalog. You can do an incomplete restore of the recovery catalog database to a point in time after the target databases were registered with the recovery catalog. What commands can you use to resynchronize the target database’s metadata and backup information with the recovery catalog database?

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

You will perform complete closed database recovery. Put the following steps in the correct order. 1. Open the database to users. 2. Identify files needed for recovery. 3. Start up the database in MOUNT mode. 4. Bring the datafiles online. 5. Apply archived and online redo log files to roll forward. 6. Oracle applies undo to roll back uncommitted changes. 7. Restore recovery-related files containing committed and uncommitted transactions

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

To create a duplicate database, put the following steps in the correct order: 1. Start the auxiliary instance as NOMOUNT. 2. Allocate auxiliary channels if necessary. 3. Run the RMAN DUPLICATE command. 4. Create a password file for the auxiliary instance. 5. Ensure network connectivity to the auxiliary instance. 6. Open the auxiliary instance. 7. Start the source database in MOUNT or OPEN mode. 8. Create an initialization parameter file for the auxiliary instance. 9. Create backups or copy existing backups and archived log files to a common location accessible by the auxiliary instance.

Page 7 of 7