Exam (elaborations)
WGU D192 - DATA SYSTEMS ADMINISTRATION QUESTIONS AND ANSWERS 2024
- Course
- Institution
WGU D192 - DATA SYSTEMS ADMINISTRATION QUESTIONS AND ANSWERS 2024
[Show more]
Content preview
WGU D192 - DATA SYSTEMS ADMINISTRATIONIf 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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Teacher101. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $17.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
75632 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now