Advanced Database Management Systems

Advanced Database Management Systems
(PreQ1, Q2)
(PreLab 1, 2)
(PreXam)
(MidQ1, Q2)
(MidLQ1, Q2)
(MidXam, MLab)
(FinQ1, Q2)
(FinLQ1, Q2)

Question text

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.

Select one:

a.

4, 5, 8, 1, 7, 9, 3, 2, 6

b.

4, 5, 8, 1, 7, 9, 2, 3, 6

c.

5, 4, 1, 8, 7, 9, 2, 3, 6

d.

5, 4, 8, 1, 7, 9, 3, 2, 6

Question text

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.

Select one:

a.

5, 4, 1, 8, 7, 9, 2, 3, 6

b.

4, 5, 8, 1, 7, 9, 2, 3, 6

c.

5, 4, 8, 1, 7, 9, 3, 2, 6

d.

4, 5, 8, 1, 7, 9, 3, 2, 6

Question text

Which of the following clauses is not valid for the RMAN DUPLICATE command?

Select one:

a.

SKIP OFFLINE

b.

NOFILENAMECHECK

c.

SKIP READONLY

d.

SKIP TABLESPACE

e.

OPEN RESTRICTED

Question text

Identify the correct statement regarding TSPITR terminology.

Select one:

a.

The auxiliary set contains all datafiles for recovery except the SYSTEM and UNDO tablespaces.

b.

The auxiliary destination is the permanent location for the auxiliary instance’s datafiles.

c.

The recovery set is the group of datafiles containing the tablespace(s) to be recovered.

d.

The target time is any time after the corrupted tables were modified or tables were accidentally dropped.

Question text

Identify the data dictionary view you can use to check for object dependencies between tablespaces.

Select one:

a.

TS_PITR_CHECK

b.

TS_PITR_DEPENDENCY_CHECK

c.

TS_PITR_OBJECTS_TO_BE_DROPPED

d.

TS_PITR_CHECK_DEPENDENCY

Question text

Which of the following two dynamic performance views can you use to identify the relationship between Oracle server sessions and RMAN channels?

Select one:

a.

V$BACKUP_ASYNC_IO and V$SESSION

b.

V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO

c.

V$PROCESS and V$BACKUP_SESSION

d.

V$PROCESS and V$BACKUP_ASYNC_IO

e.

V$PROCESS and V$SESSION

Question text

You can use V$BACKUP_ASYNC_IO to monitor asynchronous RMAN I/O. What column or columns do you use to determine which file is the bottleneck during a backup?

Select one:

a.

A large value for IO_COUNT / LONG_WAITS

b.

A large value for LONG_WAITS / IO_COUNT

c.

A large value for IO_COUNT

d.

A large value for LONG_WAITS

Question text

You set the initialization parameter BACKUP_TAPE_IO_SLAVES to TRUE. What effect does this have on the type of I/O that the server processes perform for RMAN if you are using tape? 

Select one:

a.

If LARGE_POOL_SIZE is set to a nonzero value, tape I/O is automatically asynchronous.

b.

Tape I/O is automatically synchronous.

c.

If LARGE_POOL_SIZE is set to a nonzero value, tape I/O is automatically synchronous.

d.

Tape I/O is automatically asynchronous.

Question text

What is the maximum number of database writer processes (DBWn) in an Oracle database instance?

Select one:

a.

20

b.

10

c.

1

Question text

Which of the following statement is not true regarding database backups?

Select one:

a.

As of Oracle Database 11g, RMAN supports only online backups.

b.

A logical database backup reads a set of database rows and writes them to a file.

c.

Online backups can occur only when your database is in ARCHIVELOG mode.

d.

A logical database backup reads a set of database rows and writes them to an ASM disk group.

e.

A consistent offline backup occurs after a SHUTDOWN NORMAL, IMMEDIATE, or TRANSACTIONAL.

f.

A physical database backup copies one or more files that constitute the database.

Question text

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?

Select one:

a.

An SCN

b.

A guaranteed restore point

c.

A WHERE clause on any column in the table

d.

A timestamp

Question text

backout options: NONCONFLICT_ONLY Back out changes to nonconflicting rows of the specified transaction only.

Select one:

True 

False

Question text

backout options: NOCASCADE_FORCE Back out the specified transactions, ignoring dependent transactions.

Select one:

True 

False

Question text

Which of the following columns is not in the data dictionary view FLASHBACK_TRANSACTION_QUERY?

Select one:

a.

OPERATION

b.

UNDO_SQL

c.

XID

d.

ORA_ROWSCN

Question text

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

Select one:

a.

The OPERATION column contains the value UNKNOWN.

b.

The OPERATION column contains the value UNAVAILABLE.

c.

The object number replaces the table name in the TABLE_NAME column.

d.

The user ID number replaces the user name in the LOGON_USER column.

e.

All rows for the transaction are no longer available in FLASHBACK_TRANSACTION_QUERY.

Question text

Identify the true statement about Flashback Data Archives.

Select one:

a.

You can specify more than one default Flashback Data Archive.

b.

If you do not specify a RETENTION clause for a Flashback Data Archive, you must specify it when assigning a table to the Flashback Data Archive.

c.

The QUOTA parameter is required when creating a Flashback Data Archive to limit the amount of space used in the tablespace.

d.

A Flashback Data Archive can exist in multiple tablespaces including undo tablespaces and temporary tablespaces.

Question text

Which of the following data dictionary views contains a list of the tables using a Flashback Data Archive?

Select one:

a.

DBA_FLASHBACK_DATA_ARCHIVE_TABLES

b.

DBA_FLASHBACK_ARCHIVE_TABLES

c.

DBA_FLASHBACK_ARCHIVE_TS

d.

DBA_FLASHBACK_ARCHIVE

Question text

Which of the following initialization parameters is not required to configure Flashback Database operations?

Select one:

a.

DB_FLASHBACK_RETENTION_TARGET

b.

DB_RECOVERY_FILE_DEST

c.

UNDO_RETENTION

d.

DB_RECOVERY_FILE_DEST_SIZE

Question text

Identify the true statement about Automatic Memory Management (AMM).

Select one:

a.

MEMORY_MAX_TARGET enables AMM, and it is a dynamic parameter.

b.

MEMORY_MAX_TARGET enables AMM, and it is a static parameter.

c.

MEMORY_TARGET enables AMM, and it is a static parameter.

d.

MEMORY_TARGET must be less than MEMORY_MAX_TARGET, and MEMORY_TARGET is a dynamic parameter.

Question text

Which of the following initialization parameters control Automatic Shared Memory Management (ASSM)?

Select one:

a.

SGA_MAX_SIZE

b.

MEMORY_TARGET

c.

MEMORY_MAX_TARGET

d.

SGA_TARGET

e.

SGA_MAX_TARGET

Question text

You want to switch from AMM to ASMM. What is the correct statement you need to run? 

Select one:

a.

alter system set memory_max_target = 0;

b.

alter system set sga_max_size = 750m;

c.

alter system set sga_target = 500m;

d.

alter system set memory_target = 0;

Question text

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?

Select one:

a.

4.48GB

b.

1.6GB

c.

6.4GB

d.

3.2GB

Question text

backout options:   CASCADE Back out all transactions and their dependent transactions.

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

To use guaranteed restore points, you must also enable these prerequisites: You must have archived redo log files available starting from the time of the first guaranteed restore point.

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

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.

Select one:

True 

False

Question text

Identify the correct statement regarding duplicate databases created with RMAN.

Select one:

a.

RMAN copies the database from the target to the duplicate database and both can have the same name.

b.

RMAN copies the source database to the target database and both can have the same name.

c.

RMAN creates an auxiliary instance for the duration of the copy operation and drops it after the copy operation is complete.

d.

The auxiliary database is the same as the target database.

Question text

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.

Select one:

a.

4, 5, 8, 1, 7, 9, 3, 2, 6

b.

5, 4, 1, 8, 7, 9, 2, 3, 6

c.

4, 5, 8, 1, 7, 9, 2, 3, 6

d.

5, 4, 8, 1, 7, 9, 3, 2, 6

Question text

Which of the following clauses is not valid for the RMAN DUPLICATE command?

Select one:

a.

SKIP TABLESPACE

b.

SKIP READONLY

c.

SKIP OFFLINE

d.

OPEN RESTRICTED

e.

NOFILENAMECHEC

Question text

Identify the correct statement regarding TSPITR terminology.

Select one:

a.

The recovery set is the group of datafiles containing the tablespace(s) to be recovered.

b.

The auxiliary destination is the permanent location for the auxiliary instance’s datafiles.

c.

The target time is any time after the corrupted tables were modified or tables were accidentally dropped.

d.

The auxiliary set contains all datafiles for recovery except the SYSTEM and UNDO tablespaces.

Question text

Identify the data dictionary view you can use to check for object dependencies between tablespaces.

Select one:

a.

TS_PITR_DEPENDENCY_CHECK

b.

TS_PITR_CHECK

c.

TS_PITR_OBJECTS_TO_BE_DROPPED

d.

TS_PITR_CHECK_DEPENDENCY

Question text

Which of the following two dynamic performance views can you use to identify the relationship between Oracle server sessions and RMAN channels?

Select one:

a.

V$BACKUP_SYNC_IO and V$BACKUP_ASYNC_IO

b.

V$PROCESS and V$SESSION

c.

V$PROCESS and V$BACKUP_ASYNC_IO

d.

V$BACKUP_ASYNC_IO and V$SESSION

e.

V$PROCESS and V$BACKUP_SESSION

Question text

You can use V$BACKUP_ASYNC_IO to monitor asynchronous RMAN I/O. What column or columns do you use to determine which file is the bottleneck during a backup?

Select one:

a.

A large value for LONG_WAITS / IO_COUNT

b.

A large value for IO_COUNT

c.

A large value for IO_COUNT / LONG_WAITS

d.

A large value for LONG_WAITS

Question text

You set the initialization parameter BACKUP_TAPE_IO_SLAVES to TRUE. What effect does this have on the type of I/O that the server processes perform for RMAN if you are using tape? 

Select one:

a.

If LARGE_POOL_SIZE is set to a nonzero value, tape I/O is automatically synchronous.

b.

If LARGE_POOL_SIZE is set to a nonzero value, tape I/O is automatically asynchronous.

c.

Tape I/O is automatically asynchronous.

d.

Tape I/O is automatically synchronous.

Question text

RMAN makes it easy to make a full copy or a subset of a target database.

Select one:

True 

False

Question text

DUPLICATE command:  SKIP READONLY Exclude read-only tablespaces from the copy operation. 

Select one:

True 

False

Question text

DUPLICATE command: SKIP TABLESPACE Exclude specific tablespaces, except for SYSTEM and UNDO. 

Select one:

True 

False

Question text

DUPLICATE command:  NOFILENAMECHECK Don’t check for duplicate filenames between the source and destination databases. 

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

Answer The point in time or SCN to which the tablespace will be recovered.

Question text

Answer The group of datafiles containing the tablespace(s) to be recovered.

Question text

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

Answer: 

Question text

key tuning parameters for the BACKUP command: Answer  The maximum size of a backup piece per channel. 

Question text

key tuning parameters for the BACKUP command:  Answer The maximum number of files per backupset. 

Question text

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

Question text

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

Select one:

a.

3, 5, 4, 2, 1

b.

5, 3, 4, 1, 2

c.

3, 5, 4, 1, 2

d.

5, 1, 3, 4, 2

Question text

Which of the following methods can you use to retrieve the current System Change Number (SCN)?

Select one:

a.

Query the CURRENT_SCN column of the V$INSTANCE view.

b.

Query the CURRENT_SCN column of the V$DATABASE view.

c.

Start RMAN and connect to the target database; the current SCN and the DBID are displayed.

d.

Query the LAST_SCN column of the V$DATABASE view.

e.

Query the CURRENT_SCN column from V$DATAFILE_HEADER.

Question text

Answer It refers to one of the log file status in V$LOG described  as the log group has not been used yet.

Question text

Which of the following is not a valid status for an online redo log group?

Select one:

a.

CLEARING

b.

INVALID

c.

ACTIVE

d.

 CURRENT

Question text

When you run the RMAN RESTORE CONTROLFILE command, where does RMAN put the previous version of the control file? 

Select one:

a.

To the first location defined by the CONTROL_FILES initialization parameter

b.

To all available locations defined by the CONTROL_FILES initialization parameter

c.

To all locations defined by the CONTROL_FILES initialization parameter unless overridden with the TO ‘>filename<’ clause

Question text

What is the difference between the V$LOG and V$LOGFILE views?

Select one:

a.

V$LOG contains the status of the online redo log group members and V$LOGFILE contains the status of individual online redo log groups.

b.

V$LOG contains the status of the online redo log groups and V$LOGFILE contains the status of individual redo log group members.

c.

 V$LOG contains the status of all online redo log files and V$LOGFILE contains the status of all archived redo log files.

d.

V$LOG contains the status of all archived redo log files and V$LOGFILE contains the status of all online redo log files.

Question text

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.
  

Select one:

a.

5, 1, 3, 4, 2

b.

1, 5, 3, 4, 2

c.

1, 5, 3, 2, 4

d.

5, 1, 3, 2, 4

Question text

When restoring a database to a new host, what is the first command you should run as part of the restoration process?

Select one:

a.

SET DBID

b.

STARTUP NOMOUNT

c.

RESTORE CONTROLFILE FROM AUTOBACKUP

d.

RESTORE SPFILE FROM AUTOBACKUP

Question text

Which is the best method for recovering a tempfile? 

Select one:

a.

Drop the TEMP tablespace and re-create it with a datafile in a new location.

b.

Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile while the database is running.

c.

Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile after the database has been shut down and restarted in MOUNT mode.

d.

Shut down the database, restore the tempfile from a backup, and recover it using archived and online redo log files.

Question text

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?

Select one:

a.

You can recover the USERS tablespace up to the point in time of the last incremental level 0 backup.

b.

You can recover the entire database up to the point in time of the last incremental level 0 backup.

c.

You can recover the entire database up to the point in time of the last incremental level 1 backup.

d.

You can recover the USERS tablespace up to the point in time of the last incremental level 1 backup.

Question text

Answer It refers to one of the log file status in V$LOG described  as The log is being cleared by ALTER DATABASE CLEAR LOGFILE. After being cleared, the status changes to UNUSED.

Question text

Which of the following commands does not back up the current control file?

Select one:

a.

SQL< ALTER DATABASE BACKUP CONTROLFILE TO '/U08/BACKUP/CTL.BAK';

b.

SQL< ALTER SYSTEM BACKUP CURRENT CONTROLFILE;

c.

RMAN< BACKUP CURRENT CONTROLFILE;

d.

SQL< ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Question text

The RMAN SWITCH command is equivalent to what SQL command?

Select one:

a.

ALTER DATABASE OPEN RESETLOGS

b.

ALTER SYSTEM RENAME FILE

c.

ALTER DATABASE ARCHIVELOG

d.

ALTER SYSTEM SWITCH LOGFILE

Question text

Which of the following CREATE RESTORE POINT commands will preserve the restore point past the time specified by the initialization parameter CONTROL_FILE_RECORD_KEEP_TIME?

Select one:

a.

CREATE RESTORE POINT SAVE_IT_NOW UNTIL FOREVER

b.

CREATE RESTORE POINT SAVE_IT_PAST AS OF SCN 3988943

c.

CREATE RESTORE POINT SAVE_IT_PAST KEEP

d.

CREATE RESTORE POINT SAVE_IT_NOW PRESERVE

Question text

Which two dynamic performance views can you use to identify files that need to be backed up, regardless of whether you are in ARCHIVELOG mode or NOARCHIVELOG mode?

Select one:

a.

V$DATAFILE and V$CONTROLFILE

b.

V$LOGFILE and V$LOG

c.

V$DATAFILE and V$TEMPFILE

d.

V$DATAFILE and V$LOGFILE

Question text

Answer It refers to one of the log file status in V$LOG described  as the log group is not needed for instance recovery, may be in use for media recovery, and may or may not be archived.

Question text

Which tablespaces contain critical datafiles that must be recovered when the database is offline?

Select one:

a.

SYSTEM and UNDO

b.

SYSTEM, SYSAUX, and UNDO

c.

SYSTEM and USERS

d.

SYSTEM and SYSAUX

Question text

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.

Select one:

a.

2, 7, 3, 4, 5, 1, 6

b.

1, 2, 7, 3, 4, 5, 6

c.

2, 7, 4, 3, 5, 1, 6

d.

1, 2, 7, 3, 5, 6, 1

Question text

If you lose all of the tempfiles from your temporary tablespace, what is the most likely result noticed by your users?

Select one:

a.

The users can’t use ORDER BY or GROUP BY in their queries.

b.

The users can’t perform SELECT statements.

c.

The users cannot add or delete rows in any table.

d.

The database becomes unavailable and users cannot connect.

Question text

What is the difference between a critical and a noncritical datafile in a recovery scenario?

Select one:

a.

To recover a critical datafile, only the tablespace containing the critical datafile must be offline.

b.

To recover a noncritical datafile, both the SYSTEM tablespace and the tablespace containing the critical datafile must be offline.

c.

To recover a critical datafile, the database must be in NOMOUNT mode. To recover a noncritical datafile, the database must be in MOUNT mode.

d.

To recover a critical datafile, the database must be in MOUNT mode. To recover a noncritical datafile, the database can be open.

Question text

You want to switch from AMM to ASMM. What is the correct statement you need to run? 

Select one:

a.

alter system set memory_max_target = 0;

b.

alter system set sga_max_size = 750m;

c.

alter system set memory_target = 0;

d.

alter system set sga_target = 500m;

Question text

The SQL Tuning Advisor performs all but which of the following analyses?

Select one:

a.

Statistics analysis

b.

Changes to materialized views

c.

Structure analysis

d.

Access paths

e.

SQL Profile analysis

Question text

Which of the following procedures will run a SQL Tuning Advisor job against a SQL Tuning Set? 

Select one:

a.

DBMS_QUICKTUNE.EXECUTE_TUNING_TASK

b.

DBMS_ADVISOR.EXECUTE_TUNING_TASK

c.

DBMS_SQLTUNE.EXECUTE_TUNING_TASK

d.

DBMS_SQLTUNE.RUN_TUNING_TASK

Question text

Which of the following procedures will run a SQL Access Advisor job against a single SQL statement? 

Select one:

a.

DBMS_SQLTUNE.RUN_TUNING_TASK

b.

DBMS_ADVISOR.EXECUTE_TUNING_TASK

c.

DBMS_ADVISOR.QUICK_TUNE

d.

DBMS_QUICKTUNE.EXECUTE_TUNING_TASK

Question text

You want to remap your database links so that they do not reference production database objects. Within which Database Replay step do you perform the remapping? 

Select one:

a.

During the workload capture step

b.

During the workload preprocessing step

c.

During the workload replay step

d.

You do not need to remap, since it happens automatically

e.

Before the workload capture starts

Question text

What is the difference between a critical and a noncritical datafile in a recovery scenario?

Select one:

a.

To recover a noncritical datafile, both the SYSTEM tablespace and the tablespace containing the critical datafile must be offline.

b.

To recover a critical datafile, the database must be in MOUNT mode. To recover a noncritical datafile, the database can be open.

c.

To recover a critical datafile, the database must be in NOMOUNT mode. To recover a noncritical datafile, the database must be in MOUNT mode.

d.

To recover a critical datafile, only the tablespace containing the critical datafile must be offline.

Question text

If you lose all of the tempfiles from your temporary tablespace, what is the most likely result noticed by your users?

Select one:

a.

The users can’t use ORDER BY or GROUP BY in their queries.

b.

The database becomes unavailable and users cannot connect.

c.

The users cannot add or delete rows in any table.

d.

The users can’t perform SELECT statements.

Which is the best method for recovering a tempfile? 

Select one:

a.

Shut down the database, restore the tempfile from a backup, and recover it using archived and online redo log files.

b.

Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile after the database has been shut down and restarted in MOUNT mode.

c.

Drop the TEMP tablespace and re-create it with a datafile in a new location.

d.

Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile while the database is running.

Question text

Which is the best method for recovering a tempfile? 

Select one:

a.

Drop the TEMP tablespace and re-create it with a datafile in a new location.

b.

Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile while the database is running.

c.

Shut down the database, restore the tempfile from a backup, and recover it using archived and online redo log files.

d.

Add another tempfile to the TEMP tablespace and drop the corrupted or missing tempfile after the database has been shut down and restarted in MOUNT mode.

Question text

Which of the following is not a valid status for an online redo log group?

Select one:

a.

CLEARING

b.

ACTIVE

c.

INVALID

d.

 CURRENT

Question text

What is the difference between an RMAN local script and an RMAN global script?

Select one:

a.

A local script is available only for a single target database.

b.

A local script references a list of commands in an external file.

c.

A global script can execute commands against many target databases simultaneously.

d.

A local script is available only to the user that created it. A global script is available to all users.

e.

A global script references a list of commands in an external file.

Question text

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

Question 48

Correct

Mark 1.00 out of 1.00

Flag question

Question text

A Answer backup of a database involves reading a set of database rows and writing them to a file. 

Question text

What are the default characteristics of an ASM file created with no options?

Select one:

a.

The ASM object is striped but not mirrored.

b.

The ASM object is striped and mirrored by default.

c.

The ASM object is neither striped nor mirrored.

d.

The ASM object is mirrored but not striped.

Question text

What is the difference between a full backup and a whole database backup?

Select one:

a.

A whole database backup can only be an image copy. A full backup can be an image copy or a backupset.

b.

A whole database backup can be used as the basis for an incremental backup strategy but a full database backup cannot.

c.

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.

d.

A full database backup can be used as the basis for an incremental backup strategy but a whole database backup cannot.

Question text

Under what circumstances would you use the RMAN command UPGRADE CATALOG?

Select one:

a.

When you have made structural changes to the target database.

b.

When you are using a version of the recovery catalog that is older than that required by the RMAN target database client.

c.

When you have made structural changes to the recovery catalog database.

d.

When you are using a version of the RMAN target database client that is older than required by the recovery catalog.

Question text

Identify the true statement regarding incremental and differential backups.

Select one:

a.

A differential backup is the default type of incremental backup and backs up all changed blocks since the last level 0 incremental backup.

b.

A differential backup is the default type of incremental backup and backs up all changed blocks since the last level 0 or level 1 incremental backup.

c.

A cumulative backup is the default type of incremental backup and backs up all changed blocks since the last level 0 or level 1 incremental backup.

d.

A cumulative backup is the default type of incremental backup and backs up all changed blocks since the last level 1 incremental backup.

Question text

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?

Select one:

a.

VPC_OWNER

b.

SELECT_CATALOG_ROLE

c.

REGISTER_CATALOG_OWNER

d.

RECOVERY_CATALOG_OWNER

Question text

 If a user connection is dropped or a user process otherwise fails, Answer does the cleanup work. 

Question text

Which of the following is the default substitution variable for the FORMAT clause of the BACKUP command?

Select one:

a.

%U

b.

%I

c.

%u

d.

%t

e.

%d

Question text

Which of the following does not occur when you register a target database with the recovery catalog database using the REGISTER DATABASE command?

Select one:

a.

The recovery catalog is synchronized with the structure of the database from the control file.

b.

Information about manual tablespace backups is registered in the recovery catalog.

c.

Data about recent backups is copied from the control file to the recovery catalog tables.

d.

Metadata rows are created for the target database in the recovery catalog.

Question text

What method does RMAN use to enable fast incremental backup?

Select one:

a.

It uses duplexed backupsets.

b.

It uses whole database backups as the basis for an incremental backup.

c.

It uses a block change tracking file.

d.

It uses differential incremental level 1 backups.

Question text

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?

Select one:

a.

RECOVERY_CATALOG_OWNER

b.

REGISTER_CATALOG_OWNER

c.

SELECT_CATALOG_ROLE

d.

VPC_OWNER

Question text

What is the difference between an RMAN local script and an RMAN global script?

Select one:

a.

A local script references a list of commands in an external file.

b.

A global script can execute commands against many target databases simultaneously.

c.

A local script is available only for a single target database.

d.

A local script is available only to the user that created it. A global script is available to all users.

e.

A global script references a list of commands in an external file.

Question text

To enable password encryption for a specific backup, use the Answer command. 

Question text

Which of the following roles should you grant to the recovery catalog owner? 

Select one:

a.

CATALOG_OWNER

b.

RECOVERY_CATALOG_OWNER

c.

DBA

d.

RECOVERY_CATALOG

Question text

You run the following command to create a whole database backup:

   RMAN< backup as copy database spfile plus archivelog delete input;

What does the DELETE INPUT clause do?

Select one:

a.

After the backup completes, RMAN deletes the archived log files from the flash recovery area only.

b.

After the backup completes, RMAN deletes the archived log files from all archived log file destinations except for the flash recovery area.

c.

RMAN deletes all obsolete copies of database backups after the backup completes.

d.

After the backup completes, RMAN deletes the archived log files from the flash recovery area and any other archived log file destinations.

Question text

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?

Select one:

a.

Two for tape locations and four for disk locations.

b.

Two for disk locations and four for tape destinations.

c.

A maximum of four.

d.

The maximum is limited only by the number of destination disks or tape drives.

Question text

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

Question text

When you want to restore backup, either to the same database  or to a different database, you must specify the decryption password with Answer.

Question text

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?

Select one:

a.

BACKUP ARCHIVELOG ALL;

b.

BACKUP TABLESPACE USERS;

c.

BACKUP BACKUPSET ALL;

d.

BACKUP DATABASE;

Question text

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?

Select one:

a.

Use the REGISTER DATABASE command to reregister the target database control file records.

b.

Use the CREATE CATALOG command to re-create the recovery catalog database.

c.

Use the RESYNC CATALOG command to update the recovery catalog with the latest records from the target database’s control file and the CATALOG START WITH command to record any additional backups that are no longer in the target database’s control file.

d.

Use both the CREATE CATALOG and the REGISTER DATABASE commands to resynchronize the target database with the recovery catalog.

Question text

Answer backups back up all changed blocks since the last level 0 incremental backup.

Question text

What is the difference between a full backup and a whole database backup?

Select one:

a.

A whole database backup can only be an image copy. A full backup can be an image copy or a backupset.

b.

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.

c.

A whole database backup can be used as the basis for an incremental backup strategy but a full database backup cannot.

d.

A full database backup can be used as the basis for an incremental backup strategy but a whole database backup cannot.

Question text

Identify the true statement regarding incremental and differential backups.

Select one:

a.

A cumulative backup is the default type of incremental backup and backs up all changed blocks since the last level 1 incremental backup.

b.

A differential backup is the default type of incremental backup and backs up all changed blocks since the last level 0 incremental backup.

c.

A differential backup is the default type of incremental backup and backs up all changed blocks since the last level 0 or level 1 incremental backup.

d.

A cumulative backup is the default type of incremental backup and backs up all changed blocks since the last level 0 or level 1 incremental backup.

Question text

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

Select one:

a.

The DBA_ views on each target

b.

V$CONTROLFILE

c.

The RC_ views on each target

d.

The V$ views on each target such as V$BACKUP_SET and V$DATAFILE_COPY

Question text

If you are recovering one or more tablespaces or the entire database from backups that have different passwords, you can conveniently specify all the passwords at once with Answer.

Question text

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?

Select one:

a.

create catalog rman/rmanpass@rcat;

b.

connect catalog rman/rmanpass@rcat

create catalog@rcat;

c.

connect catalog rman/rmanpass@dw

create catalog;

d.

connect catalog rman/rmanpass 

create catalog;

Question text

Under what circumstances would you use the RMAN command UPGRADE CATALOG?

Select one:

a.

When you are using a version of the recovery catalog that is older than that required by the RMAN target database client.

b.

When you have made structural changes to the target database.

c.

When you have made structural changes to the recovery catalog database.

d.

When you are using a version of the RMAN target database client that is older than required by the recovery catalog.

Question text

If you specify the initialization parameter DB_RECOVERY_FILE_DEST, what other initialization parameter must be set?

Select one:

a.

DB_CREATE_ONLINE_LOG_DEST_n

b.

No other parameter needs to be set

c.

DB_RECOVERY_FILE_DEST_SIZE

d.

DB_CREATE_FILE_DEST

Question text

Which of the following parameters are required for an ASM instance?

Select one:

a.

ASM_PREFERRED_READ_FAILURE_GROUPS

b.

ASM_POWER_LIMIT

c.

ASM_DISKGROUPS

d.

INSTANCE_TYPE

e.

INSTANCE_NAME

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

Select one:

a.

2, 1, 3, 8

b.

 9, 1, 3, 8 

c.

4, 5, 7, 6

d.

9, 3, 1, 8

e.

7, 1, 3, 8

Question text

A Answer is a group of extents that form a database object that Oracle treats as a unit, such as a table or index.

Question text

The Answer  is the next level of logical grouping in the database

Question text

A Answer backup of a database involves reading a set of database rows and writing them to a file.

Question text

Answer backups involve copying the files that constitute the database. These backups are also referred to as file system backups because they involve using operating system file backup commands. 

Question text

Which of the following are not RMAN standalone commands?

Select one:

a.

BACKUP DATABASE

b.

CONNECT

c.

CREATE SCRIPT

d.

CREATE CATALOG

e.

ALLOCATE CHANNEL

Question text

What happens to the state of an ASM instance when a connected RDBMS instance fails?

Select one:

a.

There is no effect on the ASM instance.

b.

The ASM instance fails.

c.

The ASM instance shuts down automatically.

d.

The ASM instance performs instance recovery on the failed RDBMS instance while continuing to service other RDBMS clients.

e.

All other connected RDBMS instances are paused until the failed RDBMS instance restarts.

Question text

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?

Select one:

a.

DBA_OUTSTANDING_ALERT, SUGGESTED_ACTIONS

b.

V$FLASH_RECOVERY_AREA_USAGE, PERCENT_SPACE_RECLAIMABLE

c.

DBA_OUTSTANDING_ALERTS, SUGGESTED_ACTION

d.

DBA_OUTSTANDING_ALERTS, SUGGESTED_ACTIONS

Question text

If you want to use two-way mirroring (normal redundancy) for a new disk group, how many failure groups do you need?

Select one:

a.

Two failure groups.

b.

Two-way mirroring is supported only at the operating system level using a RAID hardware or software mirroring solution.

c.

Three or more failure groups.

d.

One failure group with two disks on the same controller.

Question text

What is the maximum number of database writer processes (DBWn) in an Oracle database instance?

Select one:

a.

20

b.

10

c.

1

Question text

Which of the following statement is not true regarding database backups?

Select one:

a.

A logical database backup reads a set of database rows and writes them to a file.

b.

As of Oracle Database 11g, RMAN supports only online backups.

c.

Online backups can occur only when your database is in ARCHIVELOG mode.

d.

A logical database backup reads a set of database rows and writes them to an ASM disk group.

e.

A consistent offline backup occurs after a SHUTDOWN NORMAL, IMMEDIATE, or TRANSACTIONAL.

f.

A physical database backup copies one or more files that constitute the database.

Question text

Which of the following initialization parameters is not valid?

Select one:

a.

LOG_ARCHIVE_DEST_10 = ‘/rmtdisk/u01/app/oracle/flash’

b.

LOG_ARCHIVE_DEST = ‘/rmtdisk/u01/app/oracle/flash’

c.

LOG_ARCHIVE_DEST = ‘SERVICE=RMTDB99’

d.

LOG_ARCHIVE_DEST_3 = ‘/rmtdisk/u01/app/oracle/flash’

e.

LOG_ARCHIVE_DEST_10 = ‘SERVICE=RMTDB99’

f.

LOG_ARCHIVE_DUPLEX_DEST = ‘+DATA’

Question text

a database Answer  is the smallest unit of storage in Oracle. 

Question text

What is the value for INSTANCE_TYPE in the init.ora file or SPFILE for an ASM instance?

Select one:

a.

There is no such initialization parameter INSTANCE_TYPE

b.

ASM

c.

NOMOUNT

d.

+ASM

e.

RDBMS

Question text

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

Select one:

a.

ARBn

b.

RBAL

c.

ASMB

d.

ARCn

e.

LGWR

Question text

What are the default characteristics of an ASM file created with no options?

Select one:

a.

The ASM object is striped but not mirrored.

b.

The ASM object is striped and mirrored by default.

c.

The ASM object is neither striped nor mirrored.

d.

The ASM object is mirrored but not striped.

At which level does ASM perform mirroring?

Select one:

a.

At the disk volume level

b.

At the database object level 

c.

At the tablespace level

d.

ASM does not perform mirroring, it only supports disk hardware that is already RAID-enabled

Question text

What is the difference between coarse striping and fine striping for files in a disk group?

Select one:

a.

Coarse striping spreads files in units of 1MB each across all disks, and fine striping spreads files in units of 128KB.

b.

Coarse striping spreads files in units of 4MB each across all disks, and fine striping spreads files in units of 128KB.

c.

Coarse striping spreads files in units of 64MB each across all disks, and fine striping spreads files in units of 1MB.

d.

Coarse striping spreads files in units of 1MB each across all disks, and fine striping spreads files in units of 64KB.

Question text

Which of the following does not occur when you register a target database with the recovery catalog database using the REGISTER DATABASE command?

Select one:

a.

Metadata rows are created for the target database in the recovery catalog.

b.

The recovery catalog is synchronized with the structure of the database from the control file.

c.

Data about recent backups is copied from the control file to the recovery catalog tables.

d.

Information about manual tablespace backups is registered in the recovery catalog.

Question text

The Answer is used by the Oracle JVM (Java Virtual Machine) for all Java code and data within a user session. 

Question text

The Answer  is the next level of logical grouping in the database

Question text

To enable password encryption for a specific backup, use the Answer command. 

Question text

What is the maximum number of database writer processes (DBWn) in an Oracle database instance?

Select one:

a.

10

b.

1

c.

20

Question text

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

Select one:

a.

ASMB

b.

ARBn

c.

RBAL

d.

ARCn

e.

LGWR

Question text

What is the difference between coarse striping and fine striping for files in a disk group?

Select one:

a.

Coarse striping spreads files in units of 1MB each across all disks, and fine striping spreads files in units of 64KB.

b.

Coarse striping spreads files in units of 4MB each across all disks, and fine striping spreads files in units of 128KB.

c.

Coarse striping spreads files in units of 1MB each across all disks, and fine striping spreads files in units of 128KB.

d.

Coarse striping spreads files in units of 64MB each across all disks, and fine striping spreads files in units of 1MB.

Question text

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

Select one:

a.

V$CONTROLFILE

b.

The DBA_ views on each target

c.

The V$ views on each target such as V$BACKUP_SET and V$DATAFILE_COPY

d.

The RC_ views on each target

Question text

The Answer is an area of memory allocating dynamic sections of itself, privately for one set of connection processes. 

Question text

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?

Select one:

a.

create catalog rman/rmanpass@rcat;

b.

connect catalog rman/rmanpass 

create catalog;

c.

connect catalog rman/rmanpass@rcat

create catalog@rcat;

d.

connect catalog rman/rmanpass@dw

create catalog;

Question text

If you are recovering one or more tablespaces or the entire database from backups that have different passwords, you can conveniently specify all the passwords at once with Answer

Question text

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

Question text

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

Select one:

a.

9, 3, 1, 8

b.

 9, 1, 3, 8 

c.

2, 1, 3, 8

d.

7, 1, 3, 8

e.

4, 5, 7, 6

Question text

Answer backups back up all changed blocks since the last level 0 incremental backup.

Question text

What method does RMAN use to enable fast incremental backup?

Select one:

a.

It uses whole database backups as the basis for an incremental backup.

b.

It uses duplexed backupsets.

c.

It uses differential incremental level 1 backups.

d.

It uses a block change tracking file.

Question text

Answer is a block of executable code designed to perform a specific task.

Question text

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?

Select one:

a.

Use the REGISTER DATABASE command to reregister the target database control file records.

b.

Use both the CREATE CATALOG and the REGISTER DATABASE commands to resynchronize the target database with the recovery catalog.

c.

Use the RESYNC CATALOG command to update the recovery catalog with the latest records from the target database’s control file and the CATALOG START WITH command to record any additional backups that are no longer in the target database’s control file.

d.

Use the CREATE CATALOG command to re-create the recovery catalog database.

Question text

Which of the following statement is not true regarding database backups?

Select one:

a.

As of Oracle Database 11g, RMAN supports only online backups.

b.

A consistent offline backup occurs after a SHUTDOWN NORMAL, IMMEDIATE, or TRANSACTIONAL.

c.

A logical database backup reads a set of database rows and writes them to an ASM disk group.

d.

A physical database backup copies one or more files that constitute the database.

e.

A logical database backup reads a set of database rows and writes them to a file.

f.

Online backups can occur only when your database is in ARCHIVELOG mode.

Question text

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

Question text

The Answer contains two major subcaches: the library cache and the data dictionary cache. 

Question text

The Answer 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.

Question text

Which of the following is the default substitution variable for the FORMAT clause of the BACKUP command?

Select one:

a.

%U

b.

%I

c.

%t

d.

%d

e.

%u

Question text

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?

Select one:

a.

BACKUP TABLESPACE USERS;

b.

BACKUP ARCHIVELOG ALL;

c.

BACKUP DATABASE;

d.

BACKUP BACKUPSET ALL;

Question text

Answer backups involve copying the files that constitute the database. These backups are also referred to as file system backups because they involve using operating system file backup commands. 

Question text

A Answer is a group of extents that form a database object that Oracle treats as a unit, such as a table or index.

Question text

What is the value for INSTANCE_TYPE in the init.ora file or SPFILE for an ASM instance?

Select one:

a.

ASM

b.

There is no such initialization parameter INSTANCE_TYPE

c.

+ASM

d.

RDBMS

e.

NOMOUNT

Question text

Which of the following parameters are required for an ASM instance?

Select one:

a.

INSTANCE_TYPE

b.

ASM_PREFERRED_READ_FAILURE_GROUPS

c.

ASM_POWER_LIMIT

d.

INSTANCE_NAME

e.

ASM_DISKGROUPS

Question text

a database Answer  is the smallest unit of storage in Oracle. 

Question text

You run the following command to create a whole database backup:

   RMAN< backup as copy database spfile plus archivelog delete input;

What does the DELETE INPUT clause do?

Select one:

a.

After the backup completes, RMAN deletes the archived log files from the flash recovery area only.

b.

After the backup completes, RMAN deletes the archived log files from the flash recovery area and any other archived log file destinations.

c.

After the backup completes, RMAN deletes the archived log files from all archived log file destinations except for the flash recovery area.

d.

RMAN deletes all obsolete copies of database backups after the backup completes.

Question text

If you want to use two-way mirroring (normal redundancy) for a new disk group, how many failure groups do you need?

Select one:

a.

Three or more failure groups.

b.

Two failure groups.

c.

One failure group with two disks on the same controller.

d.

Two-way mirroring is supported only at the operating system level using a RAID hardware or software mirroring solution.

Question text

What happens to the state of an ASM instance when a connected RDBMS instance fails?

Select one:

a.

The ASM instance fails.

b.

All other connected RDBMS instances are paused until the failed RDBMS instance restarts.

c.

There is no effect on the ASM instance.

d.

The ASM instance shuts down automatically.

e.

The ASM instance performs instance recovery on the failed RDBMS instance while continuing to service other RDBMS clients.

Question text

If you specify the initialization parameter DB_RECOVERY_FILE_DEST, what other initialization parameter must be set?

Select one:

a.

DB_CREATE_ONLINE_LOG_DEST_n

b.

No other parameter needs to be set

c.

DB_RECOVERY_FILE_DEST_SIZE

d.

DB_CREATE_FILE_DEST

Question text

The Answer holds the most recent changes to the data blocks in the datafiles. 

Question text

Which of the following roles should you grant to the recovery catalog owner? 

Select one:

a.

CATALOG_OWNER

b.

RECOVERY_CATALOG_OWNER

c.

RECOVERY_CATALOG

d.

DBA

Question text

Answer writes new or changed data blocks (known as dirty blocks) in the buffer cache to the datafiles.

Question text

Which of the following are not RMAN standalone commands?

Select one:

a.

BACKUP DATABASE

b.

CONNECT

c.

CREATE SCRIPT

d.

CREATE CATALOG

e.

ALLOCATE CHANNEL

Question text

Which of the following initialization parameters is not valid?

Select one:

a.

LOG_ARCHIVE_DUPLEX_DEST = ‘+DATA’

b.

LOG_ARCHIVE_DEST = ‘SERVICE=RMTDB99’

c.

LOG_ARCHIVE_DEST_3 = ‘/rmtdisk/u01/app/oracle/flash’

d.

LOG_ARCHIVE_DEST_10 = ‘SERVICE=RMTDB99’

e.

LOG_ARCHIVE_DEST_10 = ‘/rmtdisk/u01/app/oracle/flash’

f.

LOG_ARCHIVE_DEST = ‘/rmtdisk/u01/app/oracle/flash’

Question text

The SQL Tuning Advisor performs all but which of the following analyses?

Select one:

a.

SQL Profile analysis

b.

Statistics analysis

c.

Changes to materialized views

d.

Structure analysis

e.

Access paths

Question text

 Statistics Analysis Check for stale or missing statistics, and recommend refreshing or creating them.

Select one:

True 

False

Question text

You can use DELETE_REPLAY_INFO to delete a report in the replay directory.

Select one:

True 

False

Question text

Which of the following procedures will run a SQL Tuning Advisor job against a SQL Tuning Set? 

Select one:

a.

DBMS_ADVISOR.EXECUTE_TUNING_TASK

b.

DBMS_SQLTUNE.EXECUTE_TUNING_TASK

c.

DBMS_SQLTUNE.RUN_TUNING_TASK

d.

DBMS_QUICKTUNE.EXECUTE_TUNING_TASK

Question text

Which of the following procedures will run a SQL Access Advisor job against a single SQL statement? 

Select one:

a.

DBMS_ADVISOR.EXECUTE_TUNING_TASK

b.

DBMS_ADVISOR.QUICK_TUNE

c.

DBMS_QUICKTUNE.EXECUTE_TUNING_TASK

d.

DBMS_SQLTUNE.RUN_TUNING_TASK

Question text

You want to remap your database links so that they do not reference production database objects. Within which Database Replay step do you perform the remapping? 

Select one:

a.

During the workload preprocessing step

b.

Before the workload capture starts

c.

During the workload replay step

d.

During the workload capture step

e.

You do not need to remap, since it happens automatically

Question text

Performance tuning is the final step in a four-step process: planning, implementing, and monitoring must precede it.

Select one:

True 

False

Question text

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.

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

Access Paths Analyze the impact of creating new indexes, materialized views, and partitioning.

Select one:

True 

False

Question text

Structure Analysis Restructure the SQL statements to see if better execution plans are generated.

Select one:

True 

False

Question text

The four steps to create a set of recommendations are as follows:

1. Create a task
2. Define the workload
3. Generate the recommendations
4. Review and implement the recommendations

Select one:

True 

False

Question text

Using Database Replay consists of four main steps:

1. Workload capture
2. Workload preprocessing
3. Workload replay
4. Analysis and reporting

Select one:

True 

False

Question text

Recorded client request contains  the information:  SQL text

Select one:

True 

False

Question text

Recorded client request contains  the information:  Bind values

Select one:

True 

False

Question text

Recorded client request contains  the information:  Transaction information

Select one:

True 

False

Question text

After the capture operation is complete, the captured information must be preprocessed by transforming the captured data into replay files that can be easily replayed on the target system.

Select one:

True 

False

Question text

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

Select one:

True 

False

Question text

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.

Select one:

True 

False

Question text

Before running the first replay, you must perform some prerequisite checks:Remap connection strings to the replay system from the production system.

Select one:

True 

False