WGU D415 Database Fundamentals |PA| Pre-Assessment Graded A+|Accurate|Verified 2026

WGU D415 Database Fundamentals |PA| Pre-
Assessment Graded A+


1. What is the primary purpose of a primary key?
A) Store duplicate data
B) Uniquely identify each row
C) Create relationships automatically
D) Improve query speed

2. Which normal form removes repeating groups?
A) 1NF
B) 2NF
C) 3NF
D) BCNF

3. A foreign key is used to:
A) Enforce uniqueness
B) Link tables together
C) Create indexes
D) Sort data

4. Which relationship represents one-to-many?
A) One student – one ID
B) One order – many products
C) One car – one VIN
D) One login – one password

5. What does NULL represent?
A) Zero
B) Blank space
C) Unknown or missing value
D) False

6. Which constraint prevents duplicate values?
A) NOT NULL
B) UNIQUE

, C) FOREIGN KEY
D) CHECK

7. In ER diagrams, rectangles represent:
A) Attributes
B) Entities
C) Relationships
D) Keys

8. A composite key is:
A) Two foreign keys
B) A key made of multiple columns
C) A duplicate key
D) A calculated field

9. 2NF removes:
A) Repeating groups
B) Partial dependencies
C) Transitive dependencies
D) All redundancy

10. A table without a primary key risks:
A) Faster performance
B) Duplicate records
C) Automatic indexing
D) Better normalization

11. Cardinality refers to:
A) Table size
B) Relationship count between entities
C) Number of columns
D) Data type

12. Which is a transitive dependency? A → B and B → C
A) Yes
B) No

13. Which command retrieves data?
A) INSERT
B) SELECT