WGU D330 DATA SYSTEMS
ADMINISTRATION ACTUAL EXAM PAPER
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ An organization is planning its yearly budgeting cycle. Management has
requested the information systems team to validate current hardware and
software performance. Which type of evaluation can the team use to
perform this validation?.
Answer: Function-oriented
◍ During an upgrade using DBUA, which task cannot be performed by
DBUA?
A. Configure listener.ora in the 12c Oracle home, if no listener.ora file
exists.
B. Register the database with an existing listener in the 12c Oracle home.
C. Copy the tnsnames.ora file from an old Oracle home to the 12c Oracle
home.
D. Migrate the listener running in the old Oracle home to the 12c Oracle
home..
Answer: C. Copy the tnsnames.ora file from an old Oracle home to the 12c
Oracle home.
◍ What is the lowest version you can downgrade to after upgrading an 11g R1
or 10g R2 database?A) Any version of Oracle 11gB) 11.1.0.7C) The version
from which you upgradedD) 10.2.0.5.
Answer: B) 11.1.0.7
◍ You have a database in Oracle 8.1.7 .4 version. The database size is less
than 5GB, including all tablespaces (user data, system, temp, and rollback).
, Which method would you choose to upgrade to Oracle Database 12c?
(Choose the best answer.)
A. A two-phased upgrade. Upgrade to 10.2.0.5 first, and then upgrade to
12.1.0.
B. Use traditional export/import using exp/imp tools.
C. Use the transportable tablespace feature to copy the user_data tablespace
to an Oracle Database 12c database.
D. Use DBUA to upgrade the 8.1.7.4 database directly to 12.1.0..
Answer: B. Use traditional export/import using exp/imp tools.
◍ Where are data blocks changed in an Oracle database?
A. In the memory
B. On disk
C. In the redo log buffer
D. In the server parameter file.
Answer: A. In the memory
◍ Which of the following SQL statements limits attempts to guess passwords
by locking an account after three failed logon attempts?
A. alter profile default limit failed_login_attempts 3;
B. alter system set max_logon_failures = 3 scope=both;
C. alter user set failed_login_attempts = 3;
D. alter system set failed_login_attempts = 3 scope=both;.
Answer: A. alter profile default limit failed_login_attempts 3;
◍ What is the first step in the manual database upgrade process?A) Run the
Pre-Upgrade Information utility preupgrd.sqlB) Start the database using
STARTUP UPGRADEC) Run the catctl.pl scriptD) Start up the database
and perform utlu121s.sql.
Answer: A) Run the Pre-Upgrade Information utility preupgrd.sql
◍ In the connection string, which part specifies the database service to connect
to?
A. HOST
B. PORT
, C. CONNECT_DATA
D. SERVICE_NAME.
Answer: D. SERVICE_NAME
◍ What does the MEMORY_TARGET parameter represent in Oracle
Database?A) The total size allocated for the SGA onlyB) The total size
allocated for the PGA onlyC) The total size allocated for both SGA and
PGA componentsD) The maximum size allocated for SGA and PGA
components.
Answer: C) The total size allocated for both SGA and PGA components
◍ Which is a requirement for using host naming?
A. You must use tnsnames.ora on the client.
B. You must be using TCP/I
P. C. You must have an OID present.
D. You must have a sqlnet.ora file present on the client.
E. None of the above..
Answer: B. You must be using TCP/IP.
◍ A police department ordered office supplies from Company
A. Company A ships the office supplies to the police department each
month. What is the e-commerce model of Company A?.
Answer: Business to Government (B2G)
◍ Which is the best option for upgrading an Oracle 10g R2 database that is in
its terminal release to Oracle Database 12c?
A. Use Data Pump utilities to export and import.
B. Perform a direct upgrade using DBU
A. C. Upgrade to 11g 11.1.0.7 or 11.2.0.2 using DBUA, and then upgrade
the database to 12.1.0 using Oracle Database 12c DBU
A. D. Run catctl.pl script on the Oracle 10g instance, and then start the
instance in Oracle Database 12c..
Answer: B. Perform a direct upgrade using DBUA.
◍ Which of the following substitution-variable formats are always required for
specifying the names of the archived redo log files? Choose all that apply.
, A. %d
B. %s
C. %r
D. %t
E. B, C, D.
Answer: E. B, C, D
◍ Which of the following conditions prevents the instance from progressing
through the NOMOUNT, MOUNT, and OPEN states?
A. One of the redo log-file groups is missing a member.
B. The instance was previously shut down uncleanly with SHUTDOWN
ABOR
T. C. Either the spfile or init.ora file is missing.
D. One of the five multiplexed control files is damaged.
E. The USERS tablespace is offline, with one of its data files deleted..
Answer: D. One of the five multiplexed control files is damaged.
◍ What is the minimum COMPATIBLE value for Oracle Database 12c?A)
10.0.0B) 11.0.0C) 11.1.0.7D) 11.2.0.2.
Answer: B) 11.0.0
◍ When a user session is terminated, which processes are responsible for
cleaning up and releasing locks?
A. DBWn
B. LGWR
C. MMON
D. PMON
E. SMON.
Answer: D. PMON
◍ What option does the DBUA offer during the upgrade process?A) Disable
archivingB) Back up the database after the upgradeC) Back up the database
prior to the upgradeD) Create a new database.
Answer: C) Back up the database prior to the upgrade
◍ When do threaded checkpoint or full database checkpoint occur in an Oracle
ADMINISTRATION ACTUAL EXAM PAPER
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ An organization is planning its yearly budgeting cycle. Management has
requested the information systems team to validate current hardware and
software performance. Which type of evaluation can the team use to
perform this validation?.
Answer: Function-oriented
◍ During an upgrade using DBUA, which task cannot be performed by
DBUA?
A. Configure listener.ora in the 12c Oracle home, if no listener.ora file
exists.
B. Register the database with an existing listener in the 12c Oracle home.
C. Copy the tnsnames.ora file from an old Oracle home to the 12c Oracle
home.
D. Migrate the listener running in the old Oracle home to the 12c Oracle
home..
Answer: C. Copy the tnsnames.ora file from an old Oracle home to the 12c
Oracle home.
◍ What is the lowest version you can downgrade to after upgrading an 11g R1
or 10g R2 database?A) Any version of Oracle 11gB) 11.1.0.7C) The version
from which you upgradedD) 10.2.0.5.
Answer: B) 11.1.0.7
◍ You have a database in Oracle 8.1.7 .4 version. The database size is less
than 5GB, including all tablespaces (user data, system, temp, and rollback).
, Which method would you choose to upgrade to Oracle Database 12c?
(Choose the best answer.)
A. A two-phased upgrade. Upgrade to 10.2.0.5 first, and then upgrade to
12.1.0.
B. Use traditional export/import using exp/imp tools.
C. Use the transportable tablespace feature to copy the user_data tablespace
to an Oracle Database 12c database.
D. Use DBUA to upgrade the 8.1.7.4 database directly to 12.1.0..
Answer: B. Use traditional export/import using exp/imp tools.
◍ Where are data blocks changed in an Oracle database?
A. In the memory
B. On disk
C. In the redo log buffer
D. In the server parameter file.
Answer: A. In the memory
◍ Which of the following SQL statements limits attempts to guess passwords
by locking an account after three failed logon attempts?
A. alter profile default limit failed_login_attempts 3;
B. alter system set max_logon_failures = 3 scope=both;
C. alter user set failed_login_attempts = 3;
D. alter system set failed_login_attempts = 3 scope=both;.
Answer: A. alter profile default limit failed_login_attempts 3;
◍ What is the first step in the manual database upgrade process?A) Run the
Pre-Upgrade Information utility preupgrd.sqlB) Start the database using
STARTUP UPGRADEC) Run the catctl.pl scriptD) Start up the database
and perform utlu121s.sql.
Answer: A) Run the Pre-Upgrade Information utility preupgrd.sql
◍ In the connection string, which part specifies the database service to connect
to?
A. HOST
B. PORT
, C. CONNECT_DATA
D. SERVICE_NAME.
Answer: D. SERVICE_NAME
◍ What does the MEMORY_TARGET parameter represent in Oracle
Database?A) The total size allocated for the SGA onlyB) The total size
allocated for the PGA onlyC) The total size allocated for both SGA and
PGA componentsD) The maximum size allocated for SGA and PGA
components.
Answer: C) The total size allocated for both SGA and PGA components
◍ Which is a requirement for using host naming?
A. You must use tnsnames.ora on the client.
B. You must be using TCP/I
P. C. You must have an OID present.
D. You must have a sqlnet.ora file present on the client.
E. None of the above..
Answer: B. You must be using TCP/IP.
◍ A police department ordered office supplies from Company
A. Company A ships the office supplies to the police department each
month. What is the e-commerce model of Company A?.
Answer: Business to Government (B2G)
◍ Which is the best option for upgrading an Oracle 10g R2 database that is in
its terminal release to Oracle Database 12c?
A. Use Data Pump utilities to export and import.
B. Perform a direct upgrade using DBU
A. C. Upgrade to 11g 11.1.0.7 or 11.2.0.2 using DBUA, and then upgrade
the database to 12.1.0 using Oracle Database 12c DBU
A. D. Run catctl.pl script on the Oracle 10g instance, and then start the
instance in Oracle Database 12c..
Answer: B. Perform a direct upgrade using DBUA.
◍ Which of the following substitution-variable formats are always required for
specifying the names of the archived redo log files? Choose all that apply.
, A. %d
B. %s
C. %r
D. %t
E. B, C, D.
Answer: E. B, C, D
◍ Which of the following conditions prevents the instance from progressing
through the NOMOUNT, MOUNT, and OPEN states?
A. One of the redo log-file groups is missing a member.
B. The instance was previously shut down uncleanly with SHUTDOWN
ABOR
T. C. Either the spfile or init.ora file is missing.
D. One of the five multiplexed control files is damaged.
E. The USERS tablespace is offline, with one of its data files deleted..
Answer: D. One of the five multiplexed control files is damaged.
◍ What is the minimum COMPATIBLE value for Oracle Database 12c?A)
10.0.0B) 11.0.0C) 11.1.0.7D) 11.2.0.2.
Answer: B) 11.0.0
◍ When a user session is terminated, which processes are responsible for
cleaning up and releasing locks?
A. DBWn
B. LGWR
C. MMON
D. PMON
E. SMON.
Answer: D. PMON
◍ What option does the DBUA offer during the upgrade process?A) Disable
archivingB) Back up the database after the upgradeC) Back up the database
prior to the upgradeD) Create a new database.
Answer: C) Back up the database prior to the upgrade
◍ When do threaded checkpoint or full database checkpoint occur in an Oracle
