WGU D192 NEWEST UPDATE 2024 COMPREHENSIVE
QUESTIONS AND VERIFIED ANSWERS COMPLETE
SUMMARY|GET IT RIGHT|
Data Block - (correct answer) corresponds to a number of bytes on the disk. Oracle
stores data in these. These are also referred to as logical blocks, Oracle blocks or
pages.
Data dictionary views - (correct answer) Provide information about the database and
its objects.
Data files - (correct answer) Physical files that actually store the data that has been
inserted into each table in the database.
Archived redo log file - (correct answer) A copy of a redo log file before it is
overwritten by new redo information.
ARCn - (correct answer) is the archiver process that copies the content of redo logs
to archive redo log files. The archiver process can have multiple processes, which allow
the archiver to write to various destinations such as D: drive, E drive or other storage.
ASH (Active Session History) - (correct answer) Refers to the data that is sampled
at specified intervals from the current state of all active sessions.
ASM (Automatic Storage Management) storage - (correct answer) Designed to
relieve the burden of disk and storage management and relies on Oracle to maintain the
database storage.
catctl.pl - (correct answer) A script that performs the upgrade in parallel, making use
of the CPU resources available.
CKPT - (correct answer) is the checkpoint process. In Oracle, data that is on disk is
called block and the data which in memory is called buffer. When a block is written to
the buffer and changed, the buffer becomes dirty, and it needs to be written down to the
disk. This process updates the control and data file headers with checkpoint information
and signals writing of dirty buffers to disk. Note that Oracle 12c allows both full and
incremental checkpoints.
Consumer groups - (correct answer) Used to group user sessions together so that
the different groups can be assigned different processing requirements.
Control files - (correct answer) Contain locations of other physical files, database
name, database block size, database character set, and recovery information. These
files are required to open the database.
, Data Pump - (correct answer) A high-speed mechanism for transferring data or
metadata from one database to another or from operating-system files.
Database buffer cache - (correct answer) An area in SGA that caches the database
data, holding blocks from the data files that have been accessed recently.
DBA - (correct answer) The most powerful role in the database. This role has all the
system privileges and several administrative privileges.
DBCA (Database Configuration Assistant) - (correct answer) A Java-based tool that
is used to create Oracle databases.
DBMS_SCHEDULER.CREATE_JOB - (correct answer) Used to create a job, which
can be executed directly or executed automatically on a scheduled basis inside the
Oracle Scheduler.
DBUA (Database Upgrade Assistant) - (correct answer) A GUI tool that performs the
pre-upgrade checks, the upgrade, and the post-upgrade tasks after obtaining a few
inputs.
DBWn - (correct answer) is the database writer. Oracle performs every operation in
memory instead of the disk because processing in memory is faster and more efficient
than on disk. This process reads data from disk and writes it back to the disk. An Oracle
instance has many database writers DBW0, DBW1, DBW2, and so on.
DRCP (Database Resident Connection Pooling) - (correct answer) An optional
configuration of the Oracle server, enhancing middle-tier connection pools that share
connections between threads in a middle-tier process.
Dump files - (correct answer) Contain data and metadata information.
EXCLUSIVE lock mode - (correct answer) Permits queries on the locked table but
prohibits DML by any other users.
expdp - (correct answer) A Data Pump Export utility that unloads data and metadata
to a set of OS files called dump files.
Extents - (correct answer) is a specific number of logically contiguous data blocks
used to store the particular type of information.
External tables - (correct answer) Tables with data that does not reside in the
database.
Fast recovery area - (correct answer) An area of the disk dedicated to the storage
and management of files needed for recovering an Oracle database.
QUESTIONS AND VERIFIED ANSWERS COMPLETE
SUMMARY|GET IT RIGHT|
Data Block - (correct answer) corresponds to a number of bytes on the disk. Oracle
stores data in these. These are also referred to as logical blocks, Oracle blocks or
pages.
Data dictionary views - (correct answer) Provide information about the database and
its objects.
Data files - (correct answer) Physical files that actually store the data that has been
inserted into each table in the database.
Archived redo log file - (correct answer) A copy of a redo log file before it is
overwritten by new redo information.
ARCn - (correct answer) is the archiver process that copies the content of redo logs
to archive redo log files. The archiver process can have multiple processes, which allow
the archiver to write to various destinations such as D: drive, E drive or other storage.
ASH (Active Session History) - (correct answer) Refers to the data that is sampled
at specified intervals from the current state of all active sessions.
ASM (Automatic Storage Management) storage - (correct answer) Designed to
relieve the burden of disk and storage management and relies on Oracle to maintain the
database storage.
catctl.pl - (correct answer) A script that performs the upgrade in parallel, making use
of the CPU resources available.
CKPT - (correct answer) is the checkpoint process. In Oracle, data that is on disk is
called block and the data which in memory is called buffer. When a block is written to
the buffer and changed, the buffer becomes dirty, and it needs to be written down to the
disk. This process updates the control and data file headers with checkpoint information
and signals writing of dirty buffers to disk. Note that Oracle 12c allows both full and
incremental checkpoints.
Consumer groups - (correct answer) Used to group user sessions together so that
the different groups can be assigned different processing requirements.
Control files - (correct answer) Contain locations of other physical files, database
name, database block size, database character set, and recovery information. These
files are required to open the database.
, Data Pump - (correct answer) A high-speed mechanism for transferring data or
metadata from one database to another or from operating-system files.
Database buffer cache - (correct answer) An area in SGA that caches the database
data, holding blocks from the data files that have been accessed recently.
DBA - (correct answer) The most powerful role in the database. This role has all the
system privileges and several administrative privileges.
DBCA (Database Configuration Assistant) - (correct answer) A Java-based tool that
is used to create Oracle databases.
DBMS_SCHEDULER.CREATE_JOB - (correct answer) Used to create a job, which
can be executed directly or executed automatically on a scheduled basis inside the
Oracle Scheduler.
DBUA (Database Upgrade Assistant) - (correct answer) A GUI tool that performs the
pre-upgrade checks, the upgrade, and the post-upgrade tasks after obtaining a few
inputs.
DBWn - (correct answer) is the database writer. Oracle performs every operation in
memory instead of the disk because processing in memory is faster and more efficient
than on disk. This process reads data from disk and writes it back to the disk. An Oracle
instance has many database writers DBW0, DBW1, DBW2, and so on.
DRCP (Database Resident Connection Pooling) - (correct answer) An optional
configuration of the Oracle server, enhancing middle-tier connection pools that share
connections between threads in a middle-tier process.
Dump files - (correct answer) Contain data and metadata information.
EXCLUSIVE lock mode - (correct answer) Permits queries on the locked table but
prohibits DML by any other users.
expdp - (correct answer) A Data Pump Export utility that unloads data and metadata
to a set of OS files called dump files.
Extents - (correct answer) is a specific number of logically contiguous data blocks
used to store the particular type of information.
External tables - (correct answer) Tables with data that does not reside in the
database.
Fast recovery area - (correct answer) An area of the disk dedicated to the storage
and management of files needed for recovering an Oracle database.
