ESTUDYR
WGU D426 Database Management & Design – Intensive
NCLEX-Style Practice Questions with Rationales (V2)
1. Which term describes a relationship in a database where the value of one attribute can
determine the value of another attribute?
A. Candidate Key
B. Functional Dependency
C. Referential Integrity
D. Primary Key
Answer: B. Functional Dependency
Rationale: Functional dependency defines how one attribute's value can uniquely determine the
value of another attribute in a relation.
2. Which attribute can be used to determine the value of another attribute in a relation?
A. Foreign Key
B. Primary Key
C. Determinant
D. Candidate Key
Answer: C. Determinant
Rationale: A determinant is any attribute whose value can be used to determine the value of
another attribute in the same relation.
3. What is a unique and minimal attribute or set of attributes that can determine all other
non-key attributes in a table?
A. Surrogate Key
B. Foreign Key
C. Candidate Key
D. Composite Key
Answer: C. Candidate Key
Rationale: Candidate keys are unique and minimal sets of attributes that can serve as primary
keys.
,ESTUDYR
4. Which SQL category is used to define and manage database structures?
A. DML
B. DDL
C. DCL
D. TCL
Answer: B. DDL
Rationale: DDL (Data Definition Language) includes commands like CREATE, ALTER, and
DROP to define or modify database structures.
5. Which SQL category is used for adding, deleting, or modifying data in a database?
A. DDL
B. TCL
C. DML
D. DCL
Answer: C. DML
Rationale: DML (Data Manipulation Language) manipulates stored data, such as using
INSERT, UPDATE, or DELETE commands.
6. Which SQL category is used to manage user accounts, permissions, and access?
A. DML
B. DCL
C. DDL
D. TCL
Answer: B. DCL
Rationale: DCL (Data Control Language) includes commands like GRANT and REVOKE to
control database access.
7. Which of the following commands is included in DDL?
A. INSERT
B. UPDATE
C. TRUNCATE
D. COMMIT
, ESTUDYR
Answer: C. TRUNCATE
Rationale: DDL commands define or modify database objects, such as CREATE, ALTER,
DROP, TRUNCATE, and RENAME.
8. What is a view stored physically in memory, which reflects changes in underlying data?
A. Virtual View
B. Materialized View
C. Temporary Table
D. Derived Table
Answer: B. Materialized View
Rationale: Materialized views occupy memory and are updated when underlying data changes.
9. Which view is computed only when accessed and does not occupy memory?
A. Materialized View
B. Snapshot Table
C. Virtual View
D. Temporary View
Answer: C. Virtual View
Rationale: Virtual views do not occupy storage; they are computed dynamically when queried.
10. What term describes “data about data,” including column names and data types?
A. Metadata
B. Data Dictionary
C. Schema
D. Metadata
Answer: D. Metadata
Rationale: Metadata provides information describing the structure, attributes, and types of data
stored in a database.
11. What is an ordered collection of elements in parentheses in database terminology?
A. Record
B. Table
WGU D426 Database Management & Design – Intensive
NCLEX-Style Practice Questions with Rationales (V2)
1. Which term describes a relationship in a database where the value of one attribute can
determine the value of another attribute?
A. Candidate Key
B. Functional Dependency
C. Referential Integrity
D. Primary Key
Answer: B. Functional Dependency
Rationale: Functional dependency defines how one attribute's value can uniquely determine the
value of another attribute in a relation.
2. Which attribute can be used to determine the value of another attribute in a relation?
A. Foreign Key
B. Primary Key
C. Determinant
D. Candidate Key
Answer: C. Determinant
Rationale: A determinant is any attribute whose value can be used to determine the value of
another attribute in the same relation.
3. What is a unique and minimal attribute or set of attributes that can determine all other
non-key attributes in a table?
A. Surrogate Key
B. Foreign Key
C. Candidate Key
D. Composite Key
Answer: C. Candidate Key
Rationale: Candidate keys are unique and minimal sets of attributes that can serve as primary
keys.
,ESTUDYR
4. Which SQL category is used to define and manage database structures?
A. DML
B. DDL
C. DCL
D. TCL
Answer: B. DDL
Rationale: DDL (Data Definition Language) includes commands like CREATE, ALTER, and
DROP to define or modify database structures.
5. Which SQL category is used for adding, deleting, or modifying data in a database?
A. DDL
B. TCL
C. DML
D. DCL
Answer: C. DML
Rationale: DML (Data Manipulation Language) manipulates stored data, such as using
INSERT, UPDATE, or DELETE commands.
6. Which SQL category is used to manage user accounts, permissions, and access?
A. DML
B. DCL
C. DDL
D. TCL
Answer: B. DCL
Rationale: DCL (Data Control Language) includes commands like GRANT and REVOKE to
control database access.
7. Which of the following commands is included in DDL?
A. INSERT
B. UPDATE
C. TRUNCATE
D. COMMIT
, ESTUDYR
Answer: C. TRUNCATE
Rationale: DDL commands define or modify database objects, such as CREATE, ALTER,
DROP, TRUNCATE, and RENAME.
8. What is a view stored physically in memory, which reflects changes in underlying data?
A. Virtual View
B. Materialized View
C. Temporary Table
D. Derived Table
Answer: B. Materialized View
Rationale: Materialized views occupy memory and are updated when underlying data changes.
9. Which view is computed only when accessed and does not occupy memory?
A. Materialized View
B. Snapshot Table
C. Virtual View
D. Temporary View
Answer: C. Virtual View
Rationale: Virtual views do not occupy storage; they are computed dynamically when queried.
10. What term describes “data about data,” including column names and data types?
A. Metadata
B. Data Dictionary
C. Schema
D. Metadata
Answer: D. Metadata
Rationale: Metadata provides information describing the structure, attributes, and types of data
stored in a database.
11. What is an ordered collection of elements in parentheses in database terminology?
A. Record
B. Table
