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

Showing 61 to 80 of 139 total answers.

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

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

Answer

TS_PITR_CHECK

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

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

Answer

SGA_TARGET

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

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

Answer

DBMS_ADVISOR.QUICK_TUNE

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

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

Answer

True

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

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

Answer

filesperset

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Page 4 of 7