WGU D330 DATA SYSTEMS
ADMINISTRATION TWO FINAL TEST 2026
QUESTIONS WITH CORRECT ANSWERS
GRADED A+
◍ Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAMETER.
Answer: A. V$SPPARAMETER
◍ Data management.
Answer: A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletion,
modification, and listing.
◍ 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.
Answer: B. %s C. %r D. %tThe substitution variable %d, which represents
the database ID, is required only if multiple databases share the same
archive log destination.
◍ Which object can be added to an existing bigfile tablespace?
A. datafiletemp table
, B. table data
C. tablespacedictionary table
D. undo data.
Answer: B. table data
◍ Which method is used to perform an in-place upgrade?
A. Database Upgrade Assistant
B. Export/import
C. Transportable tablespace
D. Oracle GoldenGate.
Answer: A. Database Upgrade Assistant
◍ When dynamic service registration is used, you will not see the service
listed in which of the following files where it would normally be located?
A. sqlnet.ora
B. tnsnames.ora
C. listener.ora
D. None of the above.
Answer: C. listener.ora When services are dynamically registered with the
listener, their information is not present in the listener.ora file
◍ Which of the following statements enables the role user_admin in the
current session?
A. alter session enable role user_admin;
B. alter session set role user_admin;
C. alter role user_admin enable;
D. set role user_admin;.
Answer: D. set role user_admin;The SET ROLE statement enables or
disables roles in the current session.
◍ You performed the following statement in the database. What actions can
you perform on the CUST_INFO table in the CUST_DATA tablespace.
(Choose Two.) ALTER TABLESPACE CUST_DATA READ ONLY;
A. ALTER TABLE CUST_INFO DROP COLUMN xx;
B. TRUNCATE TABLE CUST_INFO;
, C. INSERT INTO CUST_INFO VALUES (...);
D. DROP TABLE CUST_INFO;
E. RENAME CUST_INFO TO CUSTOMER_INFO;.
Answer: D. DROP TABLE CUST_INFO; E. RENAME CUST_INFO TO
CUSTOMER_INFO;When a tablespace is read-only, DML operations and
operations that affect data in the table are not allowed. TRUNCATE is not
allowed, but the DROP operation is allowed. You can also rename the table
using the RENAME statement or the ALTER TABLE statement.
◍ WHERE.
Answer: A SQL clause that adds conditional restrictions to a SELECT
statement that limit the rows returned by the query.
◍ superclass.
Answer: In a class hierarchy, the superclass is the more general
classification from which the subclasses inherit data structures and
behaviors.
◍ Which of the following pieces of information is not available in the control
file?
A. Instance name
B. Database name
C. Tablespace names
D. Log sequence number.
Answer: A. Instance nameThe instance name is not in the control file. The
control file has information about the physical database structure.
◍ atomic attribute.
Answer: An attribute that cannot be further subdivided to produce
meaningful components. For example, a person's last name attribute cannot
be meaningfully subdivided.
◍ Object.
Answer: An abstract representation of a real world entity that has a unique
identity, embedded properties, and the ability to interact with other objects
and itself.
, ◍ AVG.
Answer: A SQL aggregate function that outputs the mean average for a
specified column or expression.
◍ atomicity.
Answer: The transaction property that requires all parts of a transaction to be
treated as a single, indivisible, logical unit of work. All parts of a transaction
must be completed or the entire transaction is aborted.
◍ Which parameter determines how long information should be kept before it
is overwritten in an undo tablespace?
A. UNDO_RETENTION
B. DBA_FLASHBACK_RETENTION_TARGET
C. SORT_AREA_RETAINED_SIZE
D. UNDO_MANAGEMENT.
Answer: A. UNDO_RETENTION
◍ schema.
Answer: A logical grouping of database objects, such as tables, indexes,
views, and queries, that are related to each other. Usually, a schema belongs
to a single user or application.
◍ Your users have called to complain that system performance has suddenly
decreased markedly. Which is the most likely place to look for the cause of
the problem in EM Database Control?
A. The Main screen
B. The Performance tab
C. The Administration tab
D. The Maintenance tab.
Answer: B. The Performance tab The Performance tab of EM Database
Control provides a quick overview of how the host system, user sessions,
and throughput are impacted by the system slowdown. You can also drill
down into any of these three areas to take a look at details about this
slowdown
ADMINISTRATION TWO FINAL TEST 2026
QUESTIONS WITH CORRECT ANSWERS
GRADED A+
◍ Which view displays database parameters and values modified using the
SCOPE=SPFILE clause?
A. V$SPPARAMETER
B. V$NLS_PARAMETER
C. V$HS_PARAMETER
D. V$PARAMETER.
Answer: A. V$SPPARAMETER
◍ Data management.
Answer: A process that focuses on data collection, storage, and retrieval.
Common data management functions include addition, deletion,
modification, and listing.
◍ 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.
Answer: B. %s C. %r D. %tThe substitution variable %d, which represents
the database ID, is required only if multiple databases share the same
archive log destination.
◍ Which object can be added to an existing bigfile tablespace?
A. datafiletemp table
, B. table data
C. tablespacedictionary table
D. undo data.
Answer: B. table data
◍ Which method is used to perform an in-place upgrade?
A. Database Upgrade Assistant
B. Export/import
C. Transportable tablespace
D. Oracle GoldenGate.
Answer: A. Database Upgrade Assistant
◍ When dynamic service registration is used, you will not see the service
listed in which of the following files where it would normally be located?
A. sqlnet.ora
B. tnsnames.ora
C. listener.ora
D. None of the above.
Answer: C. listener.ora When services are dynamically registered with the
listener, their information is not present in the listener.ora file
◍ Which of the following statements enables the role user_admin in the
current session?
A. alter session enable role user_admin;
B. alter session set role user_admin;
C. alter role user_admin enable;
D. set role user_admin;.
Answer: D. set role user_admin;The SET ROLE statement enables or
disables roles in the current session.
◍ You performed the following statement in the database. What actions can
you perform on the CUST_INFO table in the CUST_DATA tablespace.
(Choose Two.) ALTER TABLESPACE CUST_DATA READ ONLY;
A. ALTER TABLE CUST_INFO DROP COLUMN xx;
B. TRUNCATE TABLE CUST_INFO;
, C. INSERT INTO CUST_INFO VALUES (...);
D. DROP TABLE CUST_INFO;
E. RENAME CUST_INFO TO CUSTOMER_INFO;.
Answer: D. DROP TABLE CUST_INFO; E. RENAME CUST_INFO TO
CUSTOMER_INFO;When a tablespace is read-only, DML operations and
operations that affect data in the table are not allowed. TRUNCATE is not
allowed, but the DROP operation is allowed. You can also rename the table
using the RENAME statement or the ALTER TABLE statement.
◍ WHERE.
Answer: A SQL clause that adds conditional restrictions to a SELECT
statement that limit the rows returned by the query.
◍ superclass.
Answer: In a class hierarchy, the superclass is the more general
classification from which the subclasses inherit data structures and
behaviors.
◍ Which of the following pieces of information is not available in the control
file?
A. Instance name
B. Database name
C. Tablespace names
D. Log sequence number.
Answer: A. Instance nameThe instance name is not in the control file. The
control file has information about the physical database structure.
◍ atomic attribute.
Answer: An attribute that cannot be further subdivided to produce
meaningful components. For example, a person's last name attribute cannot
be meaningfully subdivided.
◍ Object.
Answer: An abstract representation of a real world entity that has a unique
identity, embedded properties, and the ability to interact with other objects
and itself.
, ◍ AVG.
Answer: A SQL aggregate function that outputs the mean average for a
specified column or expression.
◍ atomicity.
Answer: The transaction property that requires all parts of a transaction to be
treated as a single, indivisible, logical unit of work. All parts of a transaction
must be completed or the entire transaction is aborted.
◍ Which parameter determines how long information should be kept before it
is overwritten in an undo tablespace?
A. UNDO_RETENTION
B. DBA_FLASHBACK_RETENTION_TARGET
C. SORT_AREA_RETAINED_SIZE
D. UNDO_MANAGEMENT.
Answer: A. UNDO_RETENTION
◍ schema.
Answer: A logical grouping of database objects, such as tables, indexes,
views, and queries, that are related to each other. Usually, a schema belongs
to a single user or application.
◍ Your users have called to complain that system performance has suddenly
decreased markedly. Which is the most likely place to look for the cause of
the problem in EM Database Control?
A. The Main screen
B. The Performance tab
C. The Administration tab
D. The Maintenance tab.
Answer: B. The Performance tab The Performance tab of EM Database
Control provides a quick overview of how the host system, user sessions,
and throughput are impacted by the system slowdown. You can also drill
down into any of these three areas to take a look at details about this
slowdown
