WGU D330 DATA SYSTEMS
ADMINISTRATION TWO CERTIFICATION
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ How does ADDM use AWR statistics?A) It uses them to calculate storage
requirements.B) It analyzes AWR statistics to identify performance issues
and recommend optimizations.C) It uses them to create user profiles.D) It
compresses the statistics for storage efficiency..
Answer: B) It analyzes AWR statistics to identify performance issues and
recommend optimizations.
◍ Autoextend.
Answer: Enables datafiles to grow automatically as needed.
◍ Shutdown TRANSACTIONAL.
Answer: Waits for active transactions to complete before shutting down.
◍ What is Automatic Shared Memory Management (ASMM) in Oracle
Database?A) A feature that compresses shared memory for better
performance.B) A method that automatically manages the allocation of
shared memory areas like the SGA components.C) A backup tool that uses
shared memory to store temporary files.D) A system for managing user
sessions..
Answer: B) A method that automatically manages the allocation of shared
memory areas like the SGA 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..
Answer: B. Host naming is typically used in small installations that have
few Oracle databases. This is an attractive option when you want to
minimize client-side configuration. TCP/IP is a requirement when you use
host naming.
◍ What are the three types of privileges in Oracle Database?A) Object
privileges, System privileges, and Role privileges.B) User privileges, Admin
privileges, and Superuser privileges.C) Schema privileges, Database
privileges, and Server privileges.D) Read privileges, Write privileges, and
Execute privileges..
Answer: A) Object privileges, System privileges, and Role privileges.
◍ How do you clear an online redo log-file group if a log file member
becomes corrupted?A) By using the RECOVER DATABASE command.B)
By using the ALTER DATABASE CLEAR LOGFILE GROUP
statement.C) By restarting the database in NOARCHIVELOG mode.D) By
deleting the corrupted file manually..
Answer: B) By using the ALTER DATABASE CLEAR LOGFILE GROUP
statement.
◍ When does ADDM run? (Choose two.)A) When an AWR snapshot is taken
automatically by the MMON processB) When an AWR snapshot is taken
automatically by the MMNL processC) When an AWR snapshot is taken
manually by DBAD) When the AutoTask process runs hourly to take
workload snapshots.
Answer: A, C. Whenever an AWR snapshot is taken, either automatically or
manually, the ADDM is run. The MMNL process is responsible for ASH
and not AWR. The MMON process is responsible for AWR. AutoTask
manages only three components: optimizer statistics, Segment Advisor, and
SQL tuning.
◍ Alert Log.
Answer: A file that provides a chronological log of critical database
messages and errors. Location set by DIAGNOSTIC_DEST
,◍ Service Name.
Answer: Logical DB identifier (replaces SID in multitenant).
◍ What is the difference between operating a database in ARCHIVELOG
mode and NOARCHIVELOG mode?A) In ARCHIVELOG mode, redo logs
are archived for recovery purposes, while in NOARCHIVELOG mode, redo
logs are overwritten, allowing only current transactions to be recovered.B)
ARCHIVELOG mode disables the use of redo logs.C) NOARCHIVELOG
mode compresses all redo logs automatically.D) ARCHIVELOG mode
requires the database to be restarted every hour..
Answer: A) In ARCHIVELOG mode, redo logs are archived for recovery
purposes, while in NOARCHIVELOG mode, redo logs are overwritten,
allowing only current transactions to be recovered.
◍ What are the benefits of the Fast Recovery Area (FRA)?A) It stores all
archived data in an external location.B) It provides a centralized location for
backup and recovery files, optimizing recovery time and storage
management.C) It eliminates the need for redo logs.D) It improves database
query performance..
Answer: B) It provides a centralized location for backup and recovery files,
optimizing recovery time and storage management.
◍ When a user session is terminated, which processes are responsible for
cleaning up and releasing locks? (Choose all that apply.)A) DBWnB)
LGWRC) MMOND) PMONE) SMON.
Answer: D. PMON is responsible for cleaning up failed user processes and
releasing locks.
◍ Complete the sentence. To run the Pre-Upgrade Information tool, the
database must be started _____.A) From Oracle Database 12c homeB) From
the original database homeC) With the STARTUP UPGRADE optionD)
With the STARTUP PREUPGRADE option.
Answer: B. The database must be running from the original Oracle database
home. The Pre-Upgrade Information tool does not make any changes to the
database or impact the application using the database. The Pre-Upgrade
, Information scripts (preupgrd.sql and utluppkg.sql) may be copied to
another directory, and you can run preupgrd.sql to invoke the tool.
◍ You want to create a database using the DBCA with DB_BLOCK_SIZE as
32K
B. Which statement is true?A) A block size of 32KB is not allowed in
Oracle Database 12c.B) You must choose the Data Warehouse template in
the DBC
A. C) You must choose the Custom template in the DBC
A. D) You must set the environment variable DB_BLOCK_SIZE to 32,768..
Answer: C. The Custom template lets you choose the database block size in
the DBCA. If the template includes data files, the block size of the template
cannot be changed. The predefined templates that come with data files have
the block size at 8KB.
◍ 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)
%dB) %sC) %rD) %t.
Answer: B, C, D. The substitution variable %d, which represents the
database ID, is required only if multiple databases share the same archive
log destination.
◍ From the following list, choose two processes that are optional in an Oracle
Database 12c database.A) MMONB) MMNLC) ARCnD) MMAN.
Answer: C, D. The ARCn (Archiver) process is optional and is enabled only
when the database is running in ARCHIVELOG mode. MMAN (Memory
Manager) is active only when Automatic Memory operations are
configured.
◍ Shutdown IMMEDIATE.
Answer: Rolls back transactions and shuts down without waiting.
◍ What are the initialization parameters used to tune instance recovery in
Oracle Database?A) DB_RECOVERY_TIME and DB_RECOVERY_SPEE
D. B) FAST_START_MTTR_TARGET, FAST_START_IO_TARGET,
and LOG_CHECKPOINT_TIMEOU
ADMINISTRATION TWO CERTIFICATION
SCRIPT 2026 QUESTIONS WITH SOLUTIONS
GRADED A+
◍ How does ADDM use AWR statistics?A) It uses them to calculate storage
requirements.B) It analyzes AWR statistics to identify performance issues
and recommend optimizations.C) It uses them to create user profiles.D) It
compresses the statistics for storage efficiency..
Answer: B) It analyzes AWR statistics to identify performance issues and
recommend optimizations.
◍ Autoextend.
Answer: Enables datafiles to grow automatically as needed.
◍ Shutdown TRANSACTIONAL.
Answer: Waits for active transactions to complete before shutting down.
◍ What is Automatic Shared Memory Management (ASMM) in Oracle
Database?A) A feature that compresses shared memory for better
performance.B) A method that automatically manages the allocation of
shared memory areas like the SGA components.C) A backup tool that uses
shared memory to store temporary files.D) A system for managing user
sessions..
Answer: B) A method that automatically manages the allocation of shared
memory areas like the SGA 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..
Answer: B. Host naming is typically used in small installations that have
few Oracle databases. This is an attractive option when you want to
minimize client-side configuration. TCP/IP is a requirement when you use
host naming.
◍ What are the three types of privileges in Oracle Database?A) Object
privileges, System privileges, and Role privileges.B) User privileges, Admin
privileges, and Superuser privileges.C) Schema privileges, Database
privileges, and Server privileges.D) Read privileges, Write privileges, and
Execute privileges..
Answer: A) Object privileges, System privileges, and Role privileges.
◍ How do you clear an online redo log-file group if a log file member
becomes corrupted?A) By using the RECOVER DATABASE command.B)
By using the ALTER DATABASE CLEAR LOGFILE GROUP
statement.C) By restarting the database in NOARCHIVELOG mode.D) By
deleting the corrupted file manually..
Answer: B) By using the ALTER DATABASE CLEAR LOGFILE GROUP
statement.
◍ When does ADDM run? (Choose two.)A) When an AWR snapshot is taken
automatically by the MMON processB) When an AWR snapshot is taken
automatically by the MMNL processC) When an AWR snapshot is taken
manually by DBAD) When the AutoTask process runs hourly to take
workload snapshots.
Answer: A, C. Whenever an AWR snapshot is taken, either automatically or
manually, the ADDM is run. The MMNL process is responsible for ASH
and not AWR. The MMON process is responsible for AWR. AutoTask
manages only three components: optimizer statistics, Segment Advisor, and
SQL tuning.
◍ Alert Log.
Answer: A file that provides a chronological log of critical database
messages and errors. Location set by DIAGNOSTIC_DEST
,◍ Service Name.
Answer: Logical DB identifier (replaces SID in multitenant).
◍ What is the difference between operating a database in ARCHIVELOG
mode and NOARCHIVELOG mode?A) In ARCHIVELOG mode, redo logs
are archived for recovery purposes, while in NOARCHIVELOG mode, redo
logs are overwritten, allowing only current transactions to be recovered.B)
ARCHIVELOG mode disables the use of redo logs.C) NOARCHIVELOG
mode compresses all redo logs automatically.D) ARCHIVELOG mode
requires the database to be restarted every hour..
Answer: A) In ARCHIVELOG mode, redo logs are archived for recovery
purposes, while in NOARCHIVELOG mode, redo logs are overwritten,
allowing only current transactions to be recovered.
◍ What are the benefits of the Fast Recovery Area (FRA)?A) It stores all
archived data in an external location.B) It provides a centralized location for
backup and recovery files, optimizing recovery time and storage
management.C) It eliminates the need for redo logs.D) It improves database
query performance..
Answer: B) It provides a centralized location for backup and recovery files,
optimizing recovery time and storage management.
◍ When a user session is terminated, which processes are responsible for
cleaning up and releasing locks? (Choose all that apply.)A) DBWnB)
LGWRC) MMOND) PMONE) SMON.
Answer: D. PMON is responsible for cleaning up failed user processes and
releasing locks.
◍ Complete the sentence. To run the Pre-Upgrade Information tool, the
database must be started _____.A) From Oracle Database 12c homeB) From
the original database homeC) With the STARTUP UPGRADE optionD)
With the STARTUP PREUPGRADE option.
Answer: B. The database must be running from the original Oracle database
home. The Pre-Upgrade Information tool does not make any changes to the
database or impact the application using the database. The Pre-Upgrade
, Information scripts (preupgrd.sql and utluppkg.sql) may be copied to
another directory, and you can run preupgrd.sql to invoke the tool.
◍ You want to create a database using the DBCA with DB_BLOCK_SIZE as
32K
B. Which statement is true?A) A block size of 32KB is not allowed in
Oracle Database 12c.B) You must choose the Data Warehouse template in
the DBC
A. C) You must choose the Custom template in the DBC
A. D) You must set the environment variable DB_BLOCK_SIZE to 32,768..
Answer: C. The Custom template lets you choose the database block size in
the DBCA. If the template includes data files, the block size of the template
cannot be changed. The predefined templates that come with data files have
the block size at 8KB.
◍ 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)
%dB) %sC) %rD) %t.
Answer: B, C, D. The substitution variable %d, which represents the
database ID, is required only if multiple databases share the same archive
log destination.
◍ From the following list, choose two processes that are optional in an Oracle
Database 12c database.A) MMONB) MMNLC) ARCnD) MMAN.
Answer: C, D. The ARCn (Archiver) process is optional and is enabled only
when the database is running in ARCHIVELOG mode. MMAN (Memory
Manager) is active only when Automatic Memory operations are
configured.
◍ Shutdown IMMEDIATE.
Answer: Rolls back transactions and shuts down without waiting.
◍ What are the initialization parameters used to tune instance recovery in
Oracle Database?A) DB_RECOVERY_TIME and DB_RECOVERY_SPEE
D. B) FAST_START_MTTR_TARGET, FAST_START_IO_TARGET,
and LOG_CHECKPOINT_TIMEOU
