WGU D192 - Data Systems Administration |200
Questions with verified answers
-silent Ans✓✓✓-A command-line option used to invoke DBUA in silent mode. In
silent mode, no user input is obtained.
A circular buffer in the SGA that holds information about the changes made to the
database data. Ans✓✓✓-Redo log buffer
After gathering pending statistics, which initialization parameter can you set to
TRUE to force the optimizer to use pending statistics instead of current statistics?
Ans✓✓✓-The OPTIMIZER_USE_PENDING_STATS initialization parameter
After you issue the SHUTDOWN ABORT command, which background process is
activated on the next startup? Ans✓✓✓-SMON - System Monitor
An area in SGA that caches the database data, holding blocks from the data files
that have been accessed recently. Ans✓✓✓-Database buffer cache
An element mapping structure is the abstract mapping structure that describes a
storage component within the I/O stack. Ans✓✓✓-Element mapping structure
Archived redo log file Ans✓✓✓-A copy of a redo log file before it is overwritten
by new redo information.
Are the activities of a user connected AS SYSDBA are always audited? Ans✓✓✓-
Yes
,ASH (Active Session History) Ans✓✓✓-Refers to the data that is sampled at
specified intervals from the current state of all active sessions.
At installation, what should you do if one of the prerequisite checks fails, such as
the prerequisite check for adequate swap space? Ans✓✓✓-Correct the issue and
continue with the installation.
At which stage during the startup of an Oracle database are the datafiles of the
database accessed? Ans✓✓✓-When the database changes from the MOUNT
state to the OPEN state
Before gathering statistics for a table using GATHER_TABLE_STATS, which action
should you take to ensure the statistics are stored in a pending state and not
published? Ans✓✓✓-Call the SET_TABLE_PREFS procedure of the DBMS_STATS
package, passing it a PUBLISH option of FALSE.
By default, to which location is standard audit trail information written?
Ans✓✓✓-The AUD$ table in the database
By default, when does the optimizer recognize pending statistics? Ans✓✓✓-After
they are published using the DBMS_STAT.PUBLISH_PENDING_STATS procedure
By default, where is audit trail information stored? Ans✓✓✓-In the database
Can a datafile span across more than one tablespace? Ans✓✓✓-No
Can a segment span more than one tablespace? Ans✓✓✓-No
, Can a segment span multiple data files? Ans✓✓✓-Yes
catctl.pl Ans✓✓✓-A script that performs the upgrade in parallel, making use of
the CPU resources available.
Consists of Oracle's main memory structure called the system global area (SGA,
also known as the shared global area) and several Oracle background processes.
Ans✓✓✓-Oracle instance
Data dictionary views Ans✓✓✓-Provide information about the database and its
objects.
DBA Ans✓✓✓-The most powerful role in the database. This role has all the
system privileges and several administrative privileges.
DBCA (Database Configuration Assistant) Ans✓✓✓-A Java-based tool that is used
to create Oracle databases.
DBUA (Database Upgrade Assistant) Ans✓✓✓-A GUI tool that performs the pre-
upgrade checks, the upgrade, and the post-upgrade tasks after obtaining a few
inputs.
Designed to relieve the burden of disk and storage management and relies on
Oracle to maintain the database storage. Ans✓✓✓-ASM (Automatic Storage
Management) storage
Questions with verified answers
-silent Ans✓✓✓-A command-line option used to invoke DBUA in silent mode. In
silent mode, no user input is obtained.
A circular buffer in the SGA that holds information about the changes made to the
database data. Ans✓✓✓-Redo log buffer
After gathering pending statistics, which initialization parameter can you set to
TRUE to force the optimizer to use pending statistics instead of current statistics?
Ans✓✓✓-The OPTIMIZER_USE_PENDING_STATS initialization parameter
After you issue the SHUTDOWN ABORT command, which background process is
activated on the next startup? Ans✓✓✓-SMON - System Monitor
An area in SGA that caches the database data, holding blocks from the data files
that have been accessed recently. Ans✓✓✓-Database buffer cache
An element mapping structure is the abstract mapping structure that describes a
storage component within the I/O stack. Ans✓✓✓-Element mapping structure
Archived redo log file Ans✓✓✓-A copy of a redo log file before it is overwritten
by new redo information.
Are the activities of a user connected AS SYSDBA are always audited? Ans✓✓✓-
Yes
,ASH (Active Session History) Ans✓✓✓-Refers to the data that is sampled at
specified intervals from the current state of all active sessions.
At installation, what should you do if one of the prerequisite checks fails, such as
the prerequisite check for adequate swap space? Ans✓✓✓-Correct the issue and
continue with the installation.
At which stage during the startup of an Oracle database are the datafiles of the
database accessed? Ans✓✓✓-When the database changes from the MOUNT
state to the OPEN state
Before gathering statistics for a table using GATHER_TABLE_STATS, which action
should you take to ensure the statistics are stored in a pending state and not
published? Ans✓✓✓-Call the SET_TABLE_PREFS procedure of the DBMS_STATS
package, passing it a PUBLISH option of FALSE.
By default, to which location is standard audit trail information written?
Ans✓✓✓-The AUD$ table in the database
By default, when does the optimizer recognize pending statistics? Ans✓✓✓-After
they are published using the DBMS_STAT.PUBLISH_PENDING_STATS procedure
By default, where is audit trail information stored? Ans✓✓✓-In the database
Can a datafile span across more than one tablespace? Ans✓✓✓-No
Can a segment span more than one tablespace? Ans✓✓✓-No
, Can a segment span multiple data files? Ans✓✓✓-Yes
catctl.pl Ans✓✓✓-A script that performs the upgrade in parallel, making use of
the CPU resources available.
Consists of Oracle's main memory structure called the system global area (SGA,
also known as the shared global area) and several Oracle background processes.
Ans✓✓✓-Oracle instance
Data dictionary views Ans✓✓✓-Provide information about the database and its
objects.
DBA Ans✓✓✓-The most powerful role in the database. This role has all the
system privileges and several administrative privileges.
DBCA (Database Configuration Assistant) Ans✓✓✓-A Java-based tool that is used
to create Oracle databases.
DBUA (Database Upgrade Assistant) Ans✓✓✓-A GUI tool that performs the pre-
upgrade checks, the upgrade, and the post-upgrade tasks after obtaining a few
inputs.
Designed to relieve the burden of disk and storage management and relies on
Oracle to maintain the database storage. Ans✓✓✓-ASM (Automatic Storage
Management) storage
