WGU D426
Data Management – Foundations
Objective Assessment Exam Questions and Answers|
Latest Update
1. Which statement best describes a database management system
(DBMS)?
A. Software that defines, creates, maintains, and controls access to a
database
B. A network protocol for sharing data
C. A programming language used only for reports
D. A collection of hardware used to store files
Answer: A
Rationale: A DBMS (for example MySQL, Oracle, PostgreSQL) manages
the data and provides tools for storing, querying, securing, and recovering
it. The database is the data itself.
WGU D426 Exam | Page 1
,2. Which is a key advantage of using a database system over file-
based processing?
A. No need for security controls
B. Guaranteed faster performance for every query
C. Reduced data redundancy and improved integrity and data
independence
D. Elimination of the need for backups
Answer: C
Rationale: Centralized data management reduces duplicated data,
enforces integrity rules, and separates data storage from applications.
Backups and security are still required.
3. SQL is best described as which type of language?
A. Procedural, specifying every step to retrieve data
B. Declarative, specifying what data is wanted rather than how to get it
C. Object-oriented only
D. Assembly language
Answer: B
Rationale: In SQL, the user states the desired result and the query
optimizer determines the execution plan.
WGU D426 Exam | Page 2
,4. Which SQL statement is a Data Definition Language (DDL)
statement?
A. SELECT
B. INSERT
C. UPDATE
D. CREATE TABLE
Answer: D
Rationale: DDL defines or changes structure (CREATE, ALTER, DROP,
TRUNCATE in many systems). SELECT, INSERT, UPDATE, and
DELETE are DML.
5. Which SQL statement is a Data Control Language (DCL) statement?
A. DELETE
B. GRANT
C. COMMIT
D. CREATE VIEW
Answer: B
Rationale: DCL controls permissions with GRANT and REVOKE.
COMMIT and ROLLBACK are transaction control statements.
6. What is the correct order of the database design phases?
A. Analysis, physical design, logical design
B. Physical design, analysis, logical design
C. Logical design, analysis, physical design
D. Analysis, logical design, physical design
Answer: D
Rationale: Analysis produces a conceptual model of the requirements
(often an ER model), logical design converts it to tables and keys, and
physical design specifies indexes and storage.
WGU D426 Exam | Page 3
, 7. Which product results from the analysis (conceptual design) phase?
A. An entity-relationship model independent of any specific DBMS
B. Stored table data
C. SQL CREATE INDEX statements
D. Disk block allocations
Answer: A
Rationale: Analysis captures entities, relationships, and business rules
without regard to a specific DBMS.
8. Which statement describes physical data independence?
A. Storage structures can change without requiring changes to queries
or applications
B. Data is always stored on a single disk
C. Every user sees the same data
D. Tables can never be modified
Answer: A
Rationale: Physical independence lets the DBA add indexes or change
file organization without rewriting queries.
9. Which describes an OLTP system?
A. Long-term archival of raw files
B. Static reports with no updates
C. Complex analytical queries over historical data
D. Many short transactions such as order entry and banking that read
and update small amounts of data
Answer: D
Rationale: OLTP supports day-to-day operations, needs high
concurrency and accuracy. OLAP and data warehouses support analysis.
WGU D426 Exam | Page 4
Data Management – Foundations
Objective Assessment Exam Questions and Answers|
Latest Update
1. Which statement best describes a database management system
(DBMS)?
A. Software that defines, creates, maintains, and controls access to a
database
B. A network protocol for sharing data
C. A programming language used only for reports
D. A collection of hardware used to store files
Answer: A
Rationale: A DBMS (for example MySQL, Oracle, PostgreSQL) manages
the data and provides tools for storing, querying, securing, and recovering
it. The database is the data itself.
WGU D426 Exam | Page 1
,2. Which is a key advantage of using a database system over file-
based processing?
A. No need for security controls
B. Guaranteed faster performance for every query
C. Reduced data redundancy and improved integrity and data
independence
D. Elimination of the need for backups
Answer: C
Rationale: Centralized data management reduces duplicated data,
enforces integrity rules, and separates data storage from applications.
Backups and security are still required.
3. SQL is best described as which type of language?
A. Procedural, specifying every step to retrieve data
B. Declarative, specifying what data is wanted rather than how to get it
C. Object-oriented only
D. Assembly language
Answer: B
Rationale: In SQL, the user states the desired result and the query
optimizer determines the execution plan.
WGU D426 Exam | Page 2
,4. Which SQL statement is a Data Definition Language (DDL)
statement?
A. SELECT
B. INSERT
C. UPDATE
D. CREATE TABLE
Answer: D
Rationale: DDL defines or changes structure (CREATE, ALTER, DROP,
TRUNCATE in many systems). SELECT, INSERT, UPDATE, and
DELETE are DML.
5. Which SQL statement is a Data Control Language (DCL) statement?
A. DELETE
B. GRANT
C. COMMIT
D. CREATE VIEW
Answer: B
Rationale: DCL controls permissions with GRANT and REVOKE.
COMMIT and ROLLBACK are transaction control statements.
6. What is the correct order of the database design phases?
A. Analysis, physical design, logical design
B. Physical design, analysis, logical design
C. Logical design, analysis, physical design
D. Analysis, logical design, physical design
Answer: D
Rationale: Analysis produces a conceptual model of the requirements
(often an ER model), logical design converts it to tables and keys, and
physical design specifies indexes and storage.
WGU D426 Exam | Page 3
, 7. Which product results from the analysis (conceptual design) phase?
A. An entity-relationship model independent of any specific DBMS
B. Stored table data
C. SQL CREATE INDEX statements
D. Disk block allocations
Answer: A
Rationale: Analysis captures entities, relationships, and business rules
without regard to a specific DBMS.
8. Which statement describes physical data independence?
A. Storage structures can change without requiring changes to queries
or applications
B. Data is always stored on a single disk
C. Every user sees the same data
D. Tables can never be modified
Answer: A
Rationale: Physical independence lets the DBA add indexes or change
file organization without rewriting queries.
9. Which describes an OLTP system?
A. Long-term archival of raw files
B. Static reports with no updates
C. Complex analytical queries over historical data
D. Many short transactions such as order entry and banking that read
and update small amounts of data
Answer: D
Rationale: OLTP supports day-to-day operations, needs high
concurrency and accuracy. OLAP and data warehouses support analysis.
WGU D426 Exam | Page 4
