WGU D192 - DATA SYSTEMS ADMINISTRATION
If you are running your database in ARCHIVELOG mode, what is the use of the
LOG_ARCHIVE_FORMAT initialization parameter? - ANSWERS-It specifies the
format of archive redo log files in an Oracle database.
How does setting the FAST_START_MTTR_TARGET initialization parameter to a
nonzero value affect checkpointing? - ANSWERS-Checkpointing is automatically
tuned to perform instance recovery within the specified time.
To which value should you set the FAST_START_MTTR_TARGET initialization
parameter to disable automatic checkpoint tuning and MTTR Advisor? -
ANSWERS-A value of 0
When a checkpoint occurs, to which two locations does the CKPT background
process write information? - ANSWERS-To the control files and the headers of
datafiles
Which initialization parameter should you set to a nonzero value to specifically set
the frequency of checkpoints? - ANSWERS-The LOG_CHECKPOINT_INTERVAL
parameter
During instance recovery, which transactions must be applied to datafiles? -
ANSWERS-All transactions between the checkpoint position and the end of the
redo log
,What is the result of setting LOG_CHECKPOINT_INTERVAL to 0? - ANSWERS-The
parameter is ignored.
What is the primary purpose of a checkpoint? - ANSWERS-To identify the
checkpoint position, which is the position in the online redo log file at which
instance recovery should begin
If both FAST_START_MTTR_TARGET and LOG_CHECKPOINT_INTERVAL are
specified, which takes precedence? - ANSWERS-The LOG_CHECKPOINT_INTERVAL
initialization parameter
When you specify the LOG_ARCHIVE_DEST_n parameter with the LOCATION
equal to a disk path, in which location are the archive redo log files stored? -
ANSWERS-In the specified directory on the same host as the database
When you specify the LOG_ARCHIVE_DEST_n parameter with the
LOCATION=USE_DB_RECOVERY_FILE_DEST, in which location are the archive redo
log files stored? - ANSWERS-In the directory identified by the
DB_RECOVERY_FILE_DEST initialization parameter
If a tablespace or schema is accidentally dropped, is DBA intervention required for
recovery? - ANSWERS-Yes
,Which initialization parameter do you modify to specify a new destination for
storing the flash recovery files in the flash recovery area? - ANSWERS-The
DB_RECOVERY_FILE_DEST initialization parameter
Which type of files does Oracle database automatically delete from the flash
recovery area based on the retention period? - ANSWERS-Transient files
Which two files are considered permanent and are not automatically deleted by
Oracle database from the flash recovery area after the retention period or after
they have been backed up to tape? - ANSWERS-Multiplexed copies of the current
control file and online redo log files
For a database running in ARCHIVELOG mode with a flash recovery area
configured, to which location will archived redo log files be written if no
LOG_ARCHIVE_DEST_n parameters are specified? - ANSWERS-To the location of
the flash recovery area
Why is it important to perform a full database backup after switching from
NOARCHIVELOG mode to ARCHIVELOG mode? - ANSWERS-Because the previous
backups taken in NOARCHIVELOG mode become invalid
In which archive logging mode must a database be in to configure the database to
use the flash backup and recovery feature? - ANSWERS-The ARCHIVELOG mode
Which seven types of files are backed up using the flash backup and recovery
strategy? - ANSWERS-Current control files, datafile and control file copies,
, flashback logs, online redo logs, archived redo log files, control file autobackups,
and Recovery Manager (RMAN) files
Which statement enables the Flashback Database feature? - ANSWERS-ALTER
DATABASE FLASHBACK ON;
To what does a data block correspond physically? - ANSWERS-A specific number
of bytes on disk
Can a datafile span across more than one tablespace? - ANSWERS-No
How many data segments are contained in a partitioned table? - ANSWERS-One
for each partition
Which type of tables contains only one data segment? - ANSWERS-Nonclustered,
non-index-organized tables
What is the minimum number of extents required for a segment? - ANSWERS-One
Which four components comprise the logical structure of the database? -
ANSWERS-Tablespaces, segments, extents, and data blocks
Can a segment span multiple data files? - ANSWERS-Yes
If you are running your database in ARCHIVELOG mode, what is the use of the
LOG_ARCHIVE_FORMAT initialization parameter? - ANSWERS-It specifies the
format of archive redo log files in an Oracle database.
How does setting the FAST_START_MTTR_TARGET initialization parameter to a
nonzero value affect checkpointing? - ANSWERS-Checkpointing is automatically
tuned to perform instance recovery within the specified time.
To which value should you set the FAST_START_MTTR_TARGET initialization
parameter to disable automatic checkpoint tuning and MTTR Advisor? -
ANSWERS-A value of 0
When a checkpoint occurs, to which two locations does the CKPT background
process write information? - ANSWERS-To the control files and the headers of
datafiles
Which initialization parameter should you set to a nonzero value to specifically set
the frequency of checkpoints? - ANSWERS-The LOG_CHECKPOINT_INTERVAL
parameter
During instance recovery, which transactions must be applied to datafiles? -
ANSWERS-All transactions between the checkpoint position and the end of the
redo log
,What is the result of setting LOG_CHECKPOINT_INTERVAL to 0? - ANSWERS-The
parameter is ignored.
What is the primary purpose of a checkpoint? - ANSWERS-To identify the
checkpoint position, which is the position in the online redo log file at which
instance recovery should begin
If both FAST_START_MTTR_TARGET and LOG_CHECKPOINT_INTERVAL are
specified, which takes precedence? - ANSWERS-The LOG_CHECKPOINT_INTERVAL
initialization parameter
When you specify the LOG_ARCHIVE_DEST_n parameter with the LOCATION
equal to a disk path, in which location are the archive redo log files stored? -
ANSWERS-In the specified directory on the same host as the database
When you specify the LOG_ARCHIVE_DEST_n parameter with the
LOCATION=USE_DB_RECOVERY_FILE_DEST, in which location are the archive redo
log files stored? - ANSWERS-In the directory identified by the
DB_RECOVERY_FILE_DEST initialization parameter
If a tablespace or schema is accidentally dropped, is DBA intervention required for
recovery? - ANSWERS-Yes
,Which initialization parameter do you modify to specify a new destination for
storing the flash recovery files in the flash recovery area? - ANSWERS-The
DB_RECOVERY_FILE_DEST initialization parameter
Which type of files does Oracle database automatically delete from the flash
recovery area based on the retention period? - ANSWERS-Transient files
Which two files are considered permanent and are not automatically deleted by
Oracle database from the flash recovery area after the retention period or after
they have been backed up to tape? - ANSWERS-Multiplexed copies of the current
control file and online redo log files
For a database running in ARCHIVELOG mode with a flash recovery area
configured, to which location will archived redo log files be written if no
LOG_ARCHIVE_DEST_n parameters are specified? - ANSWERS-To the location of
the flash recovery area
Why is it important to perform a full database backup after switching from
NOARCHIVELOG mode to ARCHIVELOG mode? - ANSWERS-Because the previous
backups taken in NOARCHIVELOG mode become invalid
In which archive logging mode must a database be in to configure the database to
use the flash backup and recovery feature? - ANSWERS-The ARCHIVELOG mode
Which seven types of files are backed up using the flash backup and recovery
strategy? - ANSWERS-Current control files, datafile and control file copies,
, flashback logs, online redo logs, archived redo log files, control file autobackups,
and Recovery Manager (RMAN) files
Which statement enables the Flashback Database feature? - ANSWERS-ALTER
DATABASE FLASHBACK ON;
To what does a data block correspond physically? - ANSWERS-A specific number
of bytes on disk
Can a datafile span across more than one tablespace? - ANSWERS-No
How many data segments are contained in a partitioned table? - ANSWERS-One
for each partition
Which type of tables contains only one data segment? - ANSWERS-Nonclustered,
non-index-organized tables
What is the minimum number of extents required for a segment? - ANSWERS-One
Which four components comprise the logical structure of the database? -
ANSWERS-Tablespaces, segments, extents, and data blocks
Can a segment span multiple data files? - ANSWERS-Yes
