WGU D426 – Objective Assessment Exam |
OA Questions and Answers | 2026/27 Updates
| 100% correct
Correct 150
Incorrect
Questions and Answers
A supertype entity identifies its subtype entities. The identifying
relationship is called an ____________ _.
IsA relationship
, Many-to-many relationship Foreign key constraint
Don't know?
2 of 150
Definition
An ______ _______ is a set of things. Ex: All employees in a company.
Give this one a try later!
Attribute Set Relationship Instance
Primary Key Entity Type
Don't know?
3 of 150
Definition
A _________ entity is a subset of another entity type, called the supertype
entity.
Give this one a try later!
Subtype Supertype
, Relationship Attribute
Don't know?
4 of 150
Definition
Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
Give this one a try later!
Parser Model Relational Model
Database Model Entity-relationship Model
Don't know?
5 of 150
Definition
________ ______ are rules for designing tables with less redundancy.
Give this one a try later!
, Primary keys SQL triggers
Foreign constraints Normal forms
Don't know?
6 of 150
Definition
Informally, a table is in ______________ when all non-key columns
depend on the key, the whole key, and nothing but the key.
Give this one a try later!
First Normal Form Second Normal Form
Third Normal Form Boyce-Codd Normal Form
Don't know?
OA Questions and Answers | 2026/27 Updates
| 100% correct
Correct 150
Incorrect
Questions and Answers
A supertype entity identifies its subtype entities. The identifying
relationship is called an ____________ _.
IsA relationship
, Many-to-many relationship Foreign key constraint
Don't know?
2 of 150
Definition
An ______ _______ is a set of things. Ex: All employees in a company.
Give this one a try later!
Attribute Set Relationship Instance
Primary Key Entity Type
Don't know?
3 of 150
Definition
A _________ entity is a subset of another entity type, called the supertype
entity.
Give this one a try later!
Subtype Supertype
, Relationship Attribute
Don't know?
4 of 150
Definition
Data structures that prescribe how data is organized.
Operations that manipulate data structures.
Rules that govern valid data.
Give this one a try later!
Parser Model Relational Model
Database Model Entity-relationship Model
Don't know?
5 of 150
Definition
________ ______ are rules for designing tables with less redundancy.
Give this one a try later!
, Primary keys SQL triggers
Foreign constraints Normal forms
Don't know?
6 of 150
Definition
Informally, a table is in ______________ when all non-key columns
depend on the key, the whole key, and nothing but the key.
Give this one a try later!
First Normal Form Second Normal Form
Third Normal Form Boyce-Codd Normal Form
Don't know?