WGU D426 DATA MANAGEMENT FOUNDATIONS
V2: ULTIMATE OA STUDY GUIDE & EXAM PREP
(2026)
The relationship (within the relation) that Functional Dependency
describes how the value of one attribute
may be used to find the value of
another attribute.
An attribute that can be used to find the Determinant
value of another attribute in the
relation.
Value can be used to find the value of Candidate Key
every other non-key attribute in the
table. Unique and minimal.
Define & manage database structures DDL
Adding, deleting, and modifying data DML
- Manipulates data stored in a
database.
Used to create user accounts, DCL
manage permissions and access.
Includes CREATE, DROP, ALTER, DDL
TRUNCATE, RENAME
A view created and stored on the Materialized View
database. Underlying data is changed
and also updated in this view. Uses
memory space.
Not stored in memory. Only computed Virtual View
when used or accessed.
The data about the data. Describes Metadata
elements such as columns, names, and
data type.
Ordered collection of elements in Tuple
parentheses.
% of table rows selected by a query Hit Ration
1/15
, Reads blocks directly, without accessing Table Scan
an index.
Reads index blocks sequentially in Index Scan
order to locate the needed table
blocks.
Database repeatedly splits the index in Binary Search
two until it finds a match.
Database object that maps one or more Tablespace
tables to a single file.
Specifies tables, columns, and keys. Logical Design
Implements database requirements in a
specific database system. Also called
a schema.
Specifies indexes, table structures, and Physical Design
partitions. Specifies how tables are
organized on storage media.
Components of a computer system and Architecture
the relationships between components.
Interact directly with database users Tools
and administrators and send queries to
the query processor. Includes
Connectors & APIs, Workbench, and
utility programs.
Interprets queries. Compiles queries Query Processor
into low-level instructions for the
storage engine. Creates a plan to
modify the database or retrieve data,
and returns query results to the
application.
Link between tools and query processor Connection
Creates connections and manages Connection Manager
communication between tools and
query parser.
Translates the query processor Storage Engine
instructions into low-level file system
commands that modify or retrieve
data.
2/15
V2: ULTIMATE OA STUDY GUIDE & EXAM PREP
(2026)
The relationship (within the relation) that Functional Dependency
describes how the value of one attribute
may be used to find the value of
another attribute.
An attribute that can be used to find the Determinant
value of another attribute in the
relation.
Value can be used to find the value of Candidate Key
every other non-key attribute in the
table. Unique and minimal.
Define & manage database structures DDL
Adding, deleting, and modifying data DML
- Manipulates data stored in a
database.
Used to create user accounts, DCL
manage permissions and access.
Includes CREATE, DROP, ALTER, DDL
TRUNCATE, RENAME
A view created and stored on the Materialized View
database. Underlying data is changed
and also updated in this view. Uses
memory space.
Not stored in memory. Only computed Virtual View
when used or accessed.
The data about the data. Describes Metadata
elements such as columns, names, and
data type.
Ordered collection of elements in Tuple
parentheses.
% of table rows selected by a query Hit Ration
1/15
, Reads blocks directly, without accessing Table Scan
an index.
Reads index blocks sequentially in Index Scan
order to locate the needed table
blocks.
Database repeatedly splits the index in Binary Search
two until it finds a match.
Database object that maps one or more Tablespace
tables to a single file.
Specifies tables, columns, and keys. Logical Design
Implements database requirements in a
specific database system. Also called
a schema.
Specifies indexes, table structures, and Physical Design
partitions. Specifies how tables are
organized on storage media.
Components of a computer system and Architecture
the relationships between components.
Interact directly with database users Tools
and administrators and send queries to
the query processor. Includes
Connectors & APIs, Workbench, and
utility programs.
Interprets queries. Compiles queries Query Processor
into low-level instructions for the
storage engine. Creates a plan to
modify the database or retrieve data,
and returns query results to the
application.
Link between tools and query processor Connection
Creates connections and manages Connection Manager
communication between tools and
query parser.
Translates the query processor Storage Engine
instructions into low-level file system
commands that modify or retrieve
data.
2/15
