WGU - D192 exam questions with complete detailed correct
answer already graded A+ and passed
1.Which parameter can an administrator enable without restarting a data-
base.
SGA_TARGET
COMPATIBLE
DB_DOMAIN
UNDO_MANAGEMENT: SGA_TARGET
2.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
3.Which command performs a clean shutdown without waiting for clients
to disconnect?
SHUTDOWN ABORT
SHUTDOWN NORMAL
SHUTDOWN
TRANSACTIONAL
SHUTDOWN IMMEDIATE: SHUTDOWN IMMEDIATE
4.Which area is a member of the System Global Area (SGA)?
Java pool
Log writer
Database writer
Process monitor: Java pool
5.Which types of events are recorded in an alert log?
Package creation
User creation
Role creation
Tablespace creation: Tablespace creation
6.Where is the listener.ora file located by default?
Package creation
User creation
, WGU - D192 exam questions with complete detailed correct
answer already graded A+ and passed
Role creation
Tablespace creation: Tablespace creation
, WGU - D192 exam questions with complete detailed correct
answer already graded A+ and passed
7.Which initialization parameter sets the location of the alert log?
AUDIT_FILE_DEST
LOG_ARCHIVE_DEST
DIAGNOSTIC_DEST
CORE_DUMP_DEST: DIAGNOSTIC_DEST
8.Where is the listener.ora file located by default?
$ORACLE_HOME/RDBMS $ORACLE_HOME/NETWORK/ADMIN $OR-
ACLE_HOME/DATABASE/ADMIN $ORACLE_HOME/DBS/ADMIN:
$ORA- CLE_HOME/NETWORK/ADMIN
9.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
10.What does the SERVER=DEDICATED element in a tnsnames.ora file
asso- ciate with each client connection?
A committed server process
A shared server process
A pooled server process
A dispatched server process: A committed server process
11.Which net service naming method requires the client to use a fixed
port number?
Local
External
Host
Directory: Host
12. A database link named wgu2021 has been created to link to a remote
object in the test database. The object is named employee and is owned by
Scott. Which reference resolves to the remote object?
scott.employee@wgu2021
scott.employee
employee
scott.employee@test: scott.employee@wgu2021
answer already graded A+ and passed
1.Which parameter can an administrator enable without restarting a data-
base.
SGA_TARGET
COMPATIBLE
DB_DOMAIN
UNDO_MANAGEMENT: SGA_TARGET
2.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
3.Which command performs a clean shutdown without waiting for clients
to disconnect?
SHUTDOWN ABORT
SHUTDOWN NORMAL
SHUTDOWN
TRANSACTIONAL
SHUTDOWN IMMEDIATE: SHUTDOWN IMMEDIATE
4.Which area is a member of the System Global Area (SGA)?
Java pool
Log writer
Database writer
Process monitor: Java pool
5.Which types of events are recorded in an alert log?
Package creation
User creation
Role creation
Tablespace creation: Tablespace creation
6.Where is the listener.ora file located by default?
Package creation
User creation
, WGU - D192 exam questions with complete detailed correct
answer already graded A+ and passed
Role creation
Tablespace creation: Tablespace creation
, WGU - D192 exam questions with complete detailed correct
answer already graded A+ and passed
7.Which initialization parameter sets the location of the alert log?
AUDIT_FILE_DEST
LOG_ARCHIVE_DEST
DIAGNOSTIC_DEST
CORE_DUMP_DEST: DIAGNOSTIC_DEST
8.Where is the listener.ora file located by default?
$ORACLE_HOME/RDBMS $ORACLE_HOME/NETWORK/ADMIN $OR-
ACLE_HOME/DATABASE/ADMIN $ORACLE_HOME/DBS/ADMIN:
$ORA- CLE_HOME/NETWORK/ADMIN
9.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
10.What does the SERVER=DEDICATED element in a tnsnames.ora file
asso- ciate with each client connection?
A committed server process
A shared server process
A pooled server process
A dispatched server process: A committed server process
11.Which net service naming method requires the client to use a fixed
port number?
Local
External
Host
Directory: Host
12. A database link named wgu2021 has been created to link to a remote
object in the test database. The object is named employee and is owned by
Scott. Which reference resolves to the remote object?
scott.employee@wgu2021
scott.employee
employee
scott.employee@test: scott.employee@wgu2021
