WGU D426 V2 COURSE STUDY GUIDE // A+ GRADED PRESENTATION
// DATA MANAGEMENT FOUNDATIONS DATABASE CONCEPTS SQL
PRINCIPLES AND INFORMATION SYSTEM APPLICATIONS FOR
STUDENT MASTERY // ACADEMIC YEAR 2025/2026
The relationship (within the relation) that describes how the value of one
attribute may be used to find the value of another attribute.
Functional Dependency
3 multiple choice options
An attribute that can be used to find the value of another attribute in the
relation.
Determinant
3 multiple choice options
Value can be used to find the value of every other non-key attribute in the
table. Unique and minimal.
Candidate Key
3 multiple choice options
Define & manage database structures
DDL
2 multiple choice options
Adding, deleting, and modifying data - Manipulates data stored in a
database.
DML
2 multiple choice options
Used to create user accounts, manage permissions and access.
,DCL
2 multiple choice options
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
DDL
2 multiple choice options
A view created and stored on the database. Underlying data is changed
and also updated in this view. Uses memory space.
Materialized View
2 multiple choice options
Not stored in memory. Only computed when used or accessed.
Virtual View
2 multiple choice options
The data about the data. Describes elements such as columns, names,
and data type.
Metadata
3 multiple choice options
Ordered collection of elements in parentheses.
Tuple
3 multiple choice options
% of table rows selected by a query
Hit Ration
3 multiple choice options
Reads blocks directly, without accessing an index.
Table Scan
3 multiple choice options
, Reads index blocks sequentially in order to locate the needed table blocks.
Index Scan
2 multiple choice options
Database repeatedly splits the index in two until it finds a match.
Binary Search
3 multiple choice options
Database object that maps one or more tables to a single file.
Tablespace
3 multiple choice options
Specifies tables, columns, and keys. Implements database requirements in
a specific database system. Also called a schema.
Logical Design
3 multiple choice options
Specifies indexes, table structures, and partitions. Specifies how tables are
organized on storage media.
Physical Design
3 multiple choice options
Components of a computer system and the relationships between
components.
Architecture
3 multiple choice options
Interact directly with database users and administrators and send queries
to the query processor. Includes Connectors & APIs, Workbench, and utility
programs.
Tools
3 multiple choice options
// DATA MANAGEMENT FOUNDATIONS DATABASE CONCEPTS SQL
PRINCIPLES AND INFORMATION SYSTEM APPLICATIONS FOR
STUDENT MASTERY // ACADEMIC YEAR 2025/2026
The relationship (within the relation) that describes how the value of one
attribute may be used to find the value of another attribute.
Functional Dependency
3 multiple choice options
An attribute that can be used to find the value of another attribute in the
relation.
Determinant
3 multiple choice options
Value can be used to find the value of every other non-key attribute in the
table. Unique and minimal.
Candidate Key
3 multiple choice options
Define & manage database structures
DDL
2 multiple choice options
Adding, deleting, and modifying data - Manipulates data stored in a
database.
DML
2 multiple choice options
Used to create user accounts, manage permissions and access.
,DCL
2 multiple choice options
Includes CREATE, DROP, ALTER, TRUNCATE, RENAME
DDL
2 multiple choice options
A view created and stored on the database. Underlying data is changed
and also updated in this view. Uses memory space.
Materialized View
2 multiple choice options
Not stored in memory. Only computed when used or accessed.
Virtual View
2 multiple choice options
The data about the data. Describes elements such as columns, names,
and data type.
Metadata
3 multiple choice options
Ordered collection of elements in parentheses.
Tuple
3 multiple choice options
% of table rows selected by a query
Hit Ration
3 multiple choice options
Reads blocks directly, without accessing an index.
Table Scan
3 multiple choice options
, Reads index blocks sequentially in order to locate the needed table blocks.
Index Scan
2 multiple choice options
Database repeatedly splits the index in two until it finds a match.
Binary Search
3 multiple choice options
Database object that maps one or more tables to a single file.
Tablespace
3 multiple choice options
Specifies tables, columns, and keys. Implements database requirements in
a specific database system. Also called a schema.
Logical Design
3 multiple choice options
Specifies indexes, table structures, and partitions. Specifies how tables are
organized on storage media.
Physical Design
3 multiple choice options
Components of a computer system and the relationships between
components.
Architecture
3 multiple choice options
Interact directly with database users and administrators and send queries
to the query processor. Includes Connectors & APIs, Workbench, and utility
programs.
Tools
3 multiple choice options
