IT-6203A - Advanced Database Management Systems oed answer key
Showing 101 to 120 of 139 total answers.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following two dynamic performance views can you use to identify the relationship between Oracle server sessions and RMAN channels?
Answer
V$PROCESS and V$SESSION
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Which of the following does not occur when you register a target database with the recovery catalog database using the REGISTER DATABASE command?
Answer
Information about manual tablespace backups is registered in the recovery catalog.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
You can use two different methods to authenticate a database administrator: operating system (OS) authentication or password file authentication.
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
Before running the first replay, you must perform some prerequisite checks:Remap connection strings to the replay system from the production system.
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
A distinct advantage to using ARCHIVELOG mode is that you can perform online backups (also known as hot backups), while the database is available to users.
Answer
True
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
The phrase “closed databaserecovery” is somewhat of a misnomer if you consider that the database instance may still be available when one or more datafiles become unavailable.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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?
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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 _______
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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.
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems
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
#IT-6203A
Awesome StudentQuestion • Advanced Database Management Systems