WGU DI 92 EXAM QUESTIONS AND
ANSWERS GRADED A+ 1 00%
GUARANTEED SUCCESS LATEST
UPDATE 2026
1 . Which parameter can an administrator enable without restarting a
database?: SGA TARGET
2. Which view displays database parameters and values modified
using the SCOPE=SPFILE clause?: V$SPPARAMETER
3. Which command performs a clean shutdown without waiting for clients
to disconnect?: SHUTDOWN IMMEDIATE
4. Which area is a member of the System Global Area (SGA)?: Java pool
5. Which types of events are recorded in an alert log? : Tablespace creation
6. Which initialization parameter sets the location of the alert log?:
DIAGNOSTIC DEST
7. Where is the listener.ora file located by default?: $ORACLE
HOME/NETWORK/ADMIN
8. Which type of connection uses the Oracle Listener to communicate?:
Client
1/
, with database server
9. What does the SERVER-DEDICATED element in a tnsnames.ora file
associate with each client connection?: A committed server process
10. Which net service naming method requires the client to use a fixed port
number?: Host
1 1 . 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
12. Which information from a remote database is included in the
configuration of a database link?: User name
13. Which object can be added to an existing bigfile tablespace?: table data
14. What is the purpose of the undo tablespace?: To facilitate the rollback
of transactions
15. Which dictionary view is available in the database to view segment
advisor results?•. DBA ADVISOR OBJECTS
16. A database administrator needs to recover unused space from a tablespace
while preventing data loss. What should the administrator use?: The
SHRINK option
17. Which package should an administrator use to configure local extent
management for tablespaces?: DBMS SPACE ADMIN
18. What should an administrator use to identify tables that are fragmented?-
ANSWERS GRADED A+ 1 00%
GUARANTEED SUCCESS LATEST
UPDATE 2026
1 . Which parameter can an administrator enable without restarting a
database?: SGA TARGET
2. Which view displays database parameters and values modified
using the SCOPE=SPFILE clause?: V$SPPARAMETER
3. Which command performs a clean shutdown without waiting for clients
to disconnect?: SHUTDOWN IMMEDIATE
4. Which area is a member of the System Global Area (SGA)?: Java pool
5. Which types of events are recorded in an alert log? : Tablespace creation
6. Which initialization parameter sets the location of the alert log?:
DIAGNOSTIC DEST
7. Where is the listener.ora file located by default?: $ORACLE
HOME/NETWORK/ADMIN
8. Which type of connection uses the Oracle Listener to communicate?:
Client
1/
, with database server
9. What does the SERVER-DEDICATED element in a tnsnames.ora file
associate with each client connection?: A committed server process
10. Which net service naming method requires the client to use a fixed port
number?: Host
1 1 . 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
12. Which information from a remote database is included in the
configuration of a database link?: User name
13. Which object can be added to an existing bigfile tablespace?: table data
14. What is the purpose of the undo tablespace?: To facilitate the rollback
of transactions
15. Which dictionary view is available in the database to view segment
advisor results?•. DBA ADVISOR OBJECTS
16. A database administrator needs to recover unused space from a tablespace
while preventing data loss. What should the administrator use?: The
SHRINK option
17. Which package should an administrator use to configure local extent
management for tablespaces?: DBMS SPACE ADMIN
18. What should an administrator use to identify tables that are fragmented?-
