WGU D192 - Jan 2025 exam practice questions with answers 100%
accurate
1.Which parameter can an administrator enable without restarting a data-
base?: 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?:
DIAGNOS- TIC_DEST
7.Where is the listener.ora file located by default?:
$ORACLE_HOME/NET- WORK/ADMIN
8.Which type of connection uses the Oracle Listener to communicate?:
Client with database server
9.What does the SERVER=DEDICATED element in a tnsnames.ora file
asso- ciate with each client connection?: A committed server process
10.Which net service naming method requires the client to use a fixed
port number?: Host
11. 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 table-
space 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?-
: Segment Advisor
19.Which parameter determines how long information should be kept
1/
7
, WGU D192 - Jan 2025 exam practice questions with answers 100%
accurate
before it is overwritten in an undo tablespace?: UNDO_RETENTION
20.How is undo tablespace storage allocated?: Segments are assigned
dynam- ically each time a change is made.
2/
7
accurate
1.Which parameter can an administrator enable without restarting a data-
base?: 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?:
DIAGNOS- TIC_DEST
7.Where is the listener.ora file located by default?:
$ORACLE_HOME/NET- WORK/ADMIN
8.Which type of connection uses the Oracle Listener to communicate?:
Client with database server
9.What does the SERVER=DEDICATED element in a tnsnames.ora file
asso- ciate with each client connection?: A committed server process
10.Which net service naming method requires the client to use a fixed
port number?: Host
11. 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 table-
space 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?-
: Segment Advisor
19.Which parameter determines how long information should be kept
1/
7
, WGU D192 - Jan 2025 exam practice questions with answers 100%
accurate
before it is overwritten in an undo tablespace?: UNDO_RETENTION
20.How is undo tablespace storage allocated?: Segments are assigned
dynam- ically each time a change is made.
2/
7
