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