1|Page
WGU D330 OBJECTIVE ASSESSMENT 2 LATEST 2026
ACTUAL EXAM| D330 DATA SYSTEMS
ADMINISTRATION OA EXAM WITH 250 REAL EXAM
QUESTIONS AND CORRECT VERIFIED ANSWERS/
GRADED A+ (MOST RECENT!!)
Which of the following is the proper order of Oracle's storage hierarchy,
from smallest to largest?
A) Operating-system block, database block, segment, extent
B) Operating-system block, database block, extent, segment
C) Segment, extent, database block, operating-system block
D) Segment, database block, extent, operating-system block -Correct
Answer- B. Multiple operating-system blocks make up database blocks,
which make up extents, which make up segments.
When an incremental checkpoint happens in a database, which file(s) are
updated with the checkpoint position? Choose all options that are
correct.
A) Data files
B) Control files
C) Initialization Parameter Files
D) Redo log files
E) Archive log files -Correct Answer- B. During an incremental
checkpoint, the control file is updated with the checkpoint position.
pg. 1
,2|Page
Which data dictionary view is used to view the current values of
parameters?
A) V$DATABASE
B) V$SPPARAMETER
C) V$PARAMETER
D) V$SYSPARAMETER -Correct Answer- C. V$PARAMETER shows
information about the parameters and their current values in the
database. V$SPPARAMETER shows the information as read from the
spfile.
Which startup options must be used to start the instance when you create
a new database?
A) STARTUP FORCE
B) STARTUP MOUNT
C) STARTUP RESTRICT
D) STARTUP NOMOUNT -Correct Answer- D. When creating a new
database or creating a control file, the database should be in the
NOMOUNT state.
All of the following are database-management options within the
Database Configuration Assistant except which one?
A) Change Database Initialization Parameters
B) Create a Database
C) Manage Templates
pg. 2
,3|Page
D) Delete a Database -Correct Answer- A. The Database Configuration
Assistant lets you create databases, manage templates, add database
options, and delete databases. Although you can change initialization
parameters when you are defining a database, this is not one of the
management options available.
The Oracle Universal Installer is started by executing which program?
A) emctl
B) runInstaller
C) ouistart
D) isqlplusctl -Correct Answer- B. The runInstaller executable performs
a preinstall check of the operating system and hardware resources before
starting the OUI graphical tool.
Your database name is OCA12C. The options show the files that are
available in the $ORACLE_HOME/dbs directory. Which file is used to
start up the database instance when you issue the STARTUP command?
A) initOCA12C.ora
B) OCA12Cspfile.ora
C) spfile.ora
D) init.ora -Correct Answer- C. When starting the instance, Oracle looks
for spfileOCA12C.ora file. If it cannot find that file, it looks for
spfile.ora. If that file is not found, Oracle looks for the initOCA12C.ora
file.
pg. 3
, 4|Page
Which initialization parameter cannot be changed after the database is
created?
A) DB_BLOCK_SIZE
B) DB_NAME
C) CONTROL_FILES
D) None. All parameters can be changed as and when required. -Correct
Answer- A. The block size of the database cannot be changed after
database creation. The database name can be changed after the control
file is re-created with a new name, and the CONTROL_FILES
parameter can be changed after the control files are copied to the new
location.
Which script creates the database dictionary?
A) dictionary.sql
B) catdict.sql
C) catproc.sql
D) catalog.sql -Correct Answer- D. The catalog.sql script creates the
data dictionary views, dynamic performance views, and synonyms.
If your database name is PROD and your instance name is PROD1, what
would be the name of the text-alert log file?
A) alertPROD.log
B) alert_PROD1.log
C) PROD1alert.log
pg. 4
WGU D330 OBJECTIVE ASSESSMENT 2 LATEST 2026
ACTUAL EXAM| D330 DATA SYSTEMS
ADMINISTRATION OA EXAM WITH 250 REAL EXAM
QUESTIONS AND CORRECT VERIFIED ANSWERS/
GRADED A+ (MOST RECENT!!)
Which of the following is the proper order of Oracle's storage hierarchy,
from smallest to largest?
A) Operating-system block, database block, segment, extent
B) Operating-system block, database block, extent, segment
C) Segment, extent, database block, operating-system block
D) Segment, database block, extent, operating-system block -Correct
Answer- B. Multiple operating-system blocks make up database blocks,
which make up extents, which make up segments.
When an incremental checkpoint happens in a database, which file(s) are
updated with the checkpoint position? Choose all options that are
correct.
A) Data files
B) Control files
C) Initialization Parameter Files
D) Redo log files
E) Archive log files -Correct Answer- B. During an incremental
checkpoint, the control file is updated with the checkpoint position.
pg. 1
,2|Page
Which data dictionary view is used to view the current values of
parameters?
A) V$DATABASE
B) V$SPPARAMETER
C) V$PARAMETER
D) V$SYSPARAMETER -Correct Answer- C. V$PARAMETER shows
information about the parameters and their current values in the
database. V$SPPARAMETER shows the information as read from the
spfile.
Which startup options must be used to start the instance when you create
a new database?
A) STARTUP FORCE
B) STARTUP MOUNT
C) STARTUP RESTRICT
D) STARTUP NOMOUNT -Correct Answer- D. When creating a new
database or creating a control file, the database should be in the
NOMOUNT state.
All of the following are database-management options within the
Database Configuration Assistant except which one?
A) Change Database Initialization Parameters
B) Create a Database
C) Manage Templates
pg. 2
,3|Page
D) Delete a Database -Correct Answer- A. The Database Configuration
Assistant lets you create databases, manage templates, add database
options, and delete databases. Although you can change initialization
parameters when you are defining a database, this is not one of the
management options available.
The Oracle Universal Installer is started by executing which program?
A) emctl
B) runInstaller
C) ouistart
D) isqlplusctl -Correct Answer- B. The runInstaller executable performs
a preinstall check of the operating system and hardware resources before
starting the OUI graphical tool.
Your database name is OCA12C. The options show the files that are
available in the $ORACLE_HOME/dbs directory. Which file is used to
start up the database instance when you issue the STARTUP command?
A) initOCA12C.ora
B) OCA12Cspfile.ora
C) spfile.ora
D) init.ora -Correct Answer- C. When starting the instance, Oracle looks
for spfileOCA12C.ora file. If it cannot find that file, it looks for
spfile.ora. If that file is not found, Oracle looks for the initOCA12C.ora
file.
pg. 3
, 4|Page
Which initialization parameter cannot be changed after the database is
created?
A) DB_BLOCK_SIZE
B) DB_NAME
C) CONTROL_FILES
D) None. All parameters can be changed as and when required. -Correct
Answer- A. The block size of the database cannot be changed after
database creation. The database name can be changed after the control
file is re-created with a new name, and the CONTROL_FILES
parameter can be changed after the control files are copied to the new
location.
Which script creates the database dictionary?
A) dictionary.sql
B) catdict.sql
C) catproc.sql
D) catalog.sql -Correct Answer- D. The catalog.sql script creates the
data dictionary views, dynamic performance views, and synonyms.
If your database name is PROD and your instance name is PROD1, what
would be the name of the text-alert log file?
A) alertPROD.log
B) alert_PROD1.log
C) PROD1alert.log
pg. 4
