WGU D192 DATA SYSTEMS ADMINISTRATION
EXAM 2026-2027 FALL-SPRING PRACTICE
QUESTIONS AND CORRECT ANSWERS GRADED
A+
Which area is a member of the System Global Area (SGA)?
Java pool
Log writer
Database writer
Process monitor
Java pool
Which types of events are recorded in an alert log?
Package creation
User creation
Role creation
Tablespace creation
Tablespace creation
,Where is the listener.ora file located by default?
Package creation
User creation
Role creation
Tablespace creation
Tablespace creation
Which initialization parameter sets the location of the alert log?
AUDIT_FILE_DEST
LOG_ARCHIVE_DEST
DIAGNOSTIC_DEST
CORE_DUMP_DEST
DIAGNOSTIC_DEST
Where is the listener.ora file located by default?
$ORACLE_HOME/RDBMS $ORACLE_HOME/NETWORK/ADMIN
$ORACLE_HOME/DATABASE/ADMIN $ORACLE_HOME/DBS/ADMIN
$ORACLE_HOME/NETWORK/ADMIN
Which type of connection uses the Oracle Listener to communicate?
,Client with database server
Browser with application server
Two application servers
Client with backup tool
Client with database server
What does the SERVER=DEDICATED element in a tnsnames.ora file associate
with each client connection?
A committed server process
A shared server process
A pooled server process
A dispatched server process
A committed server process
Which parameter can an administrator enable without restarting a database.
SGA_TARGET
COMPATIBLE
DB_DOMAIN
UNDO_MANAGEMENT
SGA_TARGET
, Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
V$SPARAMETER
V$PARAMETER
V$HS_PARAMETER
V$NLS_PARAMETER
V$SPARAMETER
Which command performs a clean shutdown without waiting for clients to
disconnect?
SHUTDOWN ABORT
SHUTDOWN NORMAL
SHUTDOWN TRANSACTIONAL
SHUTDOWN IMMEDIATE
SHUTDOWN IMMEDIATE
Which net service naming method requires the client to use a fixed port number?
Local
External
Host
Directory
EXAM 2026-2027 FALL-SPRING PRACTICE
QUESTIONS AND CORRECT ANSWERS GRADED
A+
Which area is a member of the System Global Area (SGA)?
Java pool
Log writer
Database writer
Process monitor
Java pool
Which types of events are recorded in an alert log?
Package creation
User creation
Role creation
Tablespace creation
Tablespace creation
,Where is the listener.ora file located by default?
Package creation
User creation
Role creation
Tablespace creation
Tablespace creation
Which initialization parameter sets the location of the alert log?
AUDIT_FILE_DEST
LOG_ARCHIVE_DEST
DIAGNOSTIC_DEST
CORE_DUMP_DEST
DIAGNOSTIC_DEST
Where is the listener.ora file located by default?
$ORACLE_HOME/RDBMS $ORACLE_HOME/NETWORK/ADMIN
$ORACLE_HOME/DATABASE/ADMIN $ORACLE_HOME/DBS/ADMIN
$ORACLE_HOME/NETWORK/ADMIN
Which type of connection uses the Oracle Listener to communicate?
,Client with database server
Browser with application server
Two application servers
Client with backup tool
Client with database server
What does the SERVER=DEDICATED element in a tnsnames.ora file associate
with each client connection?
A committed server process
A shared server process
A pooled server process
A dispatched server process
A committed server process
Which parameter can an administrator enable without restarting a database.
SGA_TARGET
COMPATIBLE
DB_DOMAIN
UNDO_MANAGEMENT
SGA_TARGET
, Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
V$SPARAMETER
V$PARAMETER
V$HS_PARAMETER
V$NLS_PARAMETER
V$SPARAMETER
Which command performs a clean shutdown without waiting for clients to
disconnect?
SHUTDOWN ABORT
SHUTDOWN NORMAL
SHUTDOWN TRANSACTIONAL
SHUTDOWN IMMEDIATE
SHUTDOWN IMMEDIATE
Which net service naming method requires the client to use a fixed port number?
Local
External
Host
Directory
