Which of the following tools or options does not ensure that either no committed transactions are lost or the MTBF is minimized?
Streams
Real Application Clusters
LogMiner
Archived redo logs
Standby databases
When the database is in ARCHIVELOG mode, database recovery is possible up to which event or time?
The last redo log file switch
The last checkpoint position
The last commit
The last incremental backup using RMAN
From the following, select the true statement regarding image copies and backup sets.
An image copy stores one datafile per image copy, and a backup set can store all datafiles in a single file.
An image copy stores one datafile per image copy, and a backup set consists of one file per datafile backed up.
Both image copies and backup sets use a single file to store all objects to be backed up.
A backup set stores each datafile in its own backup file, but an image copy places all datafiles into a single output file.
The option on the EM Database Control backup scheduling options screen that allows you to refresh an image copy on disk with an incremental backup is known as which new RMAN feature?
Incrementally updated backups
Incremental level 0 backups
Compressed image copy refresh
Compressed incremental backups
When should the DBA make a trace copy of the control file using ALTER DATABASE BACKUP CONTROLFILE TO TRACE?
After every backup
After multiplexing the control files
Whenever restarting the instance
Whenever the physical structure of the database changes
Which of the following is not a step in configuring your database to archive redo log files?
Place the database in ARCHIVELOG mode.
Multiplex the online redo log files.
Specify a destination for archived redo log files.
Specify a naming convention for your archived redo log files.
Why are online backups known as inconsistent backups?
Because not all control files are synchronized to the same SCN until the database is shut down
Because both committed and uncommitted transactions are included in a backup when the database is online
Because a database failure while an online backup is in progress can leave the database in an inconsistent state
Because online backups make copies of datafiles while they are not consistent with the control files
In the Disk Settings section of the EM Database Control Configure Backup Settings page, which of the following backup settings is not configurable?
Disk Backup Type
Control File Autobackup Format
Disk Backup Location
Parallelism
Which of the following initialization parameters specifies the location where the control file trace backup is sent?
USER_DUMP_DEST
BACKGROUND_DUMP_DEST
LOG_ARCHIVE_DEST
CORE_DUMP_DEST
Which of the following pieces of information is not available in the control file?
Instance name
Database name
Tablespace names
Log sequence number
Which data dictionary view shows that the database is in ARCHIVELOG mode?
V$INSTANCE
V$LOG
V$DATABASE
V$THREAD
Which file records all changes made to the database and is used only when recovering an instance?
Archive log file
Redo log file
Control file
Alert log file
Which initialization parameter contains the value used as the default for archived log file destination 10?
LOG_ARCHIVE_DEST
STANDBY_ARCHIVE_DEST
LOG_ARCHIVE_DUPLEX_DEST
DB_RECOVERY_FILE_DEST
USE_DB_RECOVERY_FILE_DEST
Which of the following commands is a key step in multiplexing control files using an SPFILE?
ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/ oradata/PRD/cntrl02.ctl' SCOPE=SPFILE;
ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/ oradata/PRD/cntrl02.ctl' SCOPE=MEMORY;
ALTER SYSTEM SET CONTROL_FILES= '/u01/oradata/PRD/cntrl01.ctl', '/u01/ oradata/PRD/cntrl02.ctl' SCOPE=BOTH;
The number of control files is fixed when the database is created.
Which statement adds a member /logs/redo22.log to redo log file group 2?
ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;
ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;
ALTER DATABASE ADD LOGFILE '/logs/redo22.log';
What is the biggest advantage of having the control files on different disks?
Database performance.
Guards against failure.
Faster archiving.
Writes are concurrent, so having control files on different disks speeds up control file writes.
To place the database into ARCHIVELOG mode, in which state must you start the database?
MOUNT
NOMOUNT
OPEN
SHUTDOWN
Any of the above
Which of the following substitution variables formats are always required for specifying the names of the archived redo log files? (Choose all that apply.)
%d
%s
%r
%t