WGU D426 V2 OA AND PRE ASSESSMENT TEST 2026
COMPLETE ACTUAL TEST QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) NEWEST
UPDATED VERSION |GUARANTEED PASS A+
A database that stores data in main memory, instead of or in
addition to storage media. Ex: SQL Server In-Memory OLTP -
Oracle Database In-Memory - MySQL
In-Memory Databases
3 multiple choice options
A database that is packaged with a programming language. AKA: In-
Process Database (Database Architecture) - SQLite - SQL Server
Compact
Embedded Databases
3 multiple choice options
Collection of two or more participating databases under a
coordinating software layer called middleware.
Federated Database
3 multiple choice options
, Relationships are named and classified by their cardinalities, which
means count (as in the number of items in a set). HAS-A
relationship. Each of the
three types of binary relationships has a different cardinality. Is the
maximum number of entity instances that can participate in a
relationship instance.
Maximum Cardinality
2 multiple choice options
Depict foreign keys. Starts at the foreign key and points to the
referenced
table. RESTRICT, CASCADE, or SET NULL appears on the arrow, on
top read left-to-right, on bottom read right-to-left.
Arrows
2 multiple choice options
States that every value of a foreign key must match a value of an
existing primary key or be fully NULL.
Referential Integrity
3 multiple choice options
,Minimum number of entity instances that must participate in a
relationship instance. These values typically assume a value of zero
(optional) or one
(mandatory).
Minimum Cardinality
2 multiple choice options
An entity whose instances cannot exist in the database without
the existence of an instance of another entity.
Weak Entity
2 multiple choice options
Can exist in the database independently.
Strong Entity
2 multiple choice options
Can be exclusive or inclusive. Can be a part of an IS-A relationship.
Subtype Entities
2 multiple choice options
, Depicted with square corners
Tables
3 multiple choice options
Indicate primary key columns
Bullets
3 multiple choice options
Description of the structure and format of the occurrences of the
entity, similar to a recipe or architectural blueprints.
Entity Class
3 multiple choice options
COMPLETE ACTUAL TEST QUESTIONS AND CORRECT
DETAILED ANSWERS (VERIFIED ANSWERS) NEWEST
UPDATED VERSION |GUARANTEED PASS A+
A database that stores data in main memory, instead of or in
addition to storage media. Ex: SQL Server In-Memory OLTP -
Oracle Database In-Memory - MySQL
In-Memory Databases
3 multiple choice options
A database that is packaged with a programming language. AKA: In-
Process Database (Database Architecture) - SQLite - SQL Server
Compact
Embedded Databases
3 multiple choice options
Collection of two or more participating databases under a
coordinating software layer called middleware.
Federated Database
3 multiple choice options
, Relationships are named and classified by their cardinalities, which
means count (as in the number of items in a set). HAS-A
relationship. Each of the
three types of binary relationships has a different cardinality. Is the
maximum number of entity instances that can participate in a
relationship instance.
Maximum Cardinality
2 multiple choice options
Depict foreign keys. Starts at the foreign key and points to the
referenced
table. RESTRICT, CASCADE, or SET NULL appears on the arrow, on
top read left-to-right, on bottom read right-to-left.
Arrows
2 multiple choice options
States that every value of a foreign key must match a value of an
existing primary key or be fully NULL.
Referential Integrity
3 multiple choice options
,Minimum number of entity instances that must participate in a
relationship instance. These values typically assume a value of zero
(optional) or one
(mandatory).
Minimum Cardinality
2 multiple choice options
An entity whose instances cannot exist in the database without
the existence of an instance of another entity.
Weak Entity
2 multiple choice options
Can exist in the database independently.
Strong Entity
2 multiple choice options
Can be exclusive or inclusive. Can be a part of an IS-A relationship.
Subtype Entities
2 multiple choice options
, Depicted with square corners
Tables
3 multiple choice options
Indicate primary key columns
Bullets
3 multiple choice options
Description of the structure and format of the occurrences of the
entity, similar to a recipe or architectural blueprints.
Entity Class
3 multiple choice options
