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