WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
What is the process that notifies the listener after a database
connection is established?
A. SMON
B. PMON
C. LREG
D. LGWR
C. LREG
The LREG process notifies the listener after a client connection is
established. This is so that the listener can keep track of the number of
connections being serviced by each dispatcher. In versions prior to
Oracle Database 12c, the functions of LREG were performed by PMON
Which network architecture connection uses session memory from
the SGA?
A. Dedicated Server
B. Shared Server
END OF
PAGE
1
, WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
C. Database Resident Connection Pooling
D. All of the above
B. Shared Server
Dedicated server uses session memory from PGA. A pooled server
connection is similar to dedicated server once connected; therefore, the
memory is coming from PGA as well. For a shared server, the server
process is shared; therefore, the request and response information must
be kept in the SGA.
Communication between two Oracle databases is configured using:
A. Database Resident Connection Pooling
B. Database link
C. Connection Manager
D. Oracle Net Manager
B. Database link
END OF
PAGE
2
, WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
Database links facilitate communication between databases. Using a
database link access syntax (@dblink_name), data from a remote
database is available locally.
DBA user MIKE ran the SQL statement
CREATE DATABASE LINK SCOTT.SALES_LINK .BJS.COM
CONNECT TO SALES_INT IDENTIFIED BY SALESPWD1 USING
'ocasvr:1522/ ocadb'.
Choose the option that is true.
A. Use of 'ocasvr:1522/ocadb' is invalid in database link definition.
B. A private database link is created under user MIKE.
C. A private database link is created under user SCOTT.
D. If the SALES_INT user does not exist or its password is not
SALESPWD1, the database link will not be created.
B. A private database link is created under user MIKE.
END OF
PAGE
3
, WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
Private database links are created under the user who executes the
CREATE DATABASE LINK statement. You cannot create a database
link under another schema. A link by the name
SCOTT.SALES_LINK.BJS.COM is created under schema MIKE. You
can use the Easy Connect syntax or the Oracle Net connect syntax, or
you can resolve the alias name by using tnsnames.ora in the USING
clause. During database link creation, a connection is not made to the
target database to validate the connection or credentials.
Which of the following statements create an Oracle account but let
the operating system authenticate logons? (Choose two.)
A. create user ops$admin identified by os;
B. create user ops$admin identified externally;
C. create user ops$admin nopassword;
D. create user ops$admin authenticated by os;
END OF
PAGE
4
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
What is the process that notifies the listener after a database
connection is established?
A. SMON
B. PMON
C. LREG
D. LGWR
C. LREG
The LREG process notifies the listener after a client connection is
established. This is so that the listener can keep track of the number of
connections being serviced by each dispatcher. In versions prior to
Oracle Database 12c, the functions of LREG were performed by PMON
Which network architecture connection uses session memory from
the SGA?
A. Dedicated Server
B. Shared Server
END OF
PAGE
1
, WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
C. Database Resident Connection Pooling
D. All of the above
B. Shared Server
Dedicated server uses session memory from PGA. A pooled server
connection is similar to dedicated server once connected; therefore, the
memory is coming from PGA as well. For a shared server, the server
process is shared; therefore, the request and response information must
be kept in the SGA.
Communication between two Oracle databases is configured using:
A. Database Resident Connection Pooling
B. Database link
C. Connection Manager
D. Oracle Net Manager
B. Database link
END OF
PAGE
2
, WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
Database links facilitate communication between databases. Using a
database link access syntax (@dblink_name), data from a remote
database is available locally.
DBA user MIKE ran the SQL statement
CREATE DATABASE LINK SCOTT.SALES_LINK .BJS.COM
CONNECT TO SALES_INT IDENTIFIED BY SALESPWD1 USING
'ocasvr:1522/ ocadb'.
Choose the option that is true.
A. Use of 'ocasvr:1522/ocadb' is invalid in database link definition.
B. A private database link is created under user MIKE.
C. A private database link is created under user SCOTT.
D. If the SALES_INT user does not exist or its password is not
SALESPWD1, the database link will not be created.
B. A private database link is created under user MIKE.
END OF
PAGE
3
, WGU D330 DATA LATEST
SYSTEMS
ADMINISTRATION (ALL
QUESTIONS FROM
CHAPTER 8-10, 12-15,
AND 17)QUESTIONS AND
ANSWERS 2026 - 2027
Private database links are created under the user who executes the
CREATE DATABASE LINK statement. You cannot create a database
link under another schema. A link by the name
SCOTT.SALES_LINK.BJS.COM is created under schema MIKE. You
can use the Easy Connect syntax or the Oracle Net connect syntax, or
you can resolve the alias name by using tnsnames.ora in the USING
clause. During database link creation, a connection is not made to the
target database to validate the connection or credentials.
Which of the following statements create an Oracle account but let
the operating system authenticate logons? (Choose two.)
A. create user ops$admin identified by os;
B. create user ops$admin identified externally;
C. create user ops$admin nopassword;
D. create user ops$admin authenticated by os;
END OF
PAGE
4
