WGU D426 DATA MANAGEMENT FOUNDATIONS
FINAL EXAM accurate 2025 update. (100%
complete questions and answers).
Architecture - ANSWER-Describes the internal components AND the relationships between
components.
Query Processor - ANSWER-Interprets queries, creates a plan to modify the database or retrieve the
data, and returns query results to the application. Performs query optimization.
Query Optimization - ANSWER-Ensures efficient instructions are executed on the data from the Query
Processor.
Storage Manager - ANSWER-Translates the query processor instructions into low- level file-system
commands that modify OR retrieve data. Uses indexes to quickly locate data.
Transaction Manager - ANSWER-Ensures transactions are properly executed. Prevents conflicts
between concurrent transactions. Also restores the database to a consistent state in the event of a
failure.
Log - ANSWER-A file containing a complete record of ALL inserts, updates, and deletes processed by
the database. The records can be used to restore a database.
Catalog/Data Dictionary/Repository - ANSWER-A directory of tables, columns, indexes, and other
database objects.
Relational Database - ANSWER-Stores data in tables, columns, and rows, SIMILAR to a spreadsheet.
It also supports SQL. Made up of relations.
NoSQL - ANSWER-A new generation of DBMS that is NOT based on the traditional relational database
model.
CRUD - ANSWER-Acronym for actions that can be performed by a query.
SQL Statement - ANSWER-A database command such as a query that inserts, retrieves, updates, or
deletes data. Composed of one or more clauses.
INSERT - ANSWER-Inserts rows into a table.
SELECT - ANSWER-Retrieves data from a table.
UPDATE - ANSWER-Modifies data in a table.
DELETE - ANSWER-Deletes rows from a table.
CREATE TABLE - ANSWER-Creates a new table by specifying the table and column names.
, Data Type - ANSWER-Indicates the TYPE of data that can be stored in a field of a column.
Data Independence - ANSWER-Allows database administrators to improve query performance by
changing the organization of data on storage devices, without affecting query results or changes to
programs.
Database Design - ANSWER-A specification of database objects such as tables, columns data types,
and indexes. Also refers to the process used to develop the specifications.
Metadata - ANSWER-Data ABOUT the database, such as column names and the number of rows in
each table.
Database Design - Analysis - ANSWER-This phase specifies database requirements without regard to
a specific database system. May also be referred to as conceptual design, entity-relationship
modeling, and requirements definition.
Database Design - Logical Design - ANSWER-This phase implements database requirements in a
specific database system. Depicted in a table diagram.
Database Design - Physical Design - ANSWER-This phase adds indexes and specifies HOW tables are
organized on storage media. Specified with SQL statements.
Key - ANSWER-A column used to identify individual rows of a table. Used to refer to only one specific
row or record.
Application Programming Language (API) - ANSWER-A library of procedures or classes that links a
host programming language to a database.
Schema - ANSWER-The structure of tables in the database.
Foreign Key - ANSWER-What a primary key from one table is called when it is referenced in another
table. Important when starting to build relationships between tables. Refers to a primary key.
One-to-Many - ANSWER-This is the most common relationship. Associates ONE record in ONE table
with MULTIPLE records in another table.
One-to-One - ANSWER-Associates only ONE record on one table with ONE record on another table.
Data Manipulation Language (DML) - ANSWER-What language am I?
Allows users to access and modify the data to MAKE queries, and GENERATE reports. Interacting with
the data.
Data Definition Language (DDL) - ANSWER-What language am I?
Allows a database administrator to DEFINE the database structure, schema, and subschema.
Data Control Language (DCL) - ANSWER-What language am I?
Commands that CONTROL a database. Includes administering privileges and committing data.
MySQL Community/MySQL Server - ANSWER-Is a FREE EDITION. Includes a complete set of database
FINAL EXAM accurate 2025 update. (100%
complete questions and answers).
Architecture - ANSWER-Describes the internal components AND the relationships between
components.
Query Processor - ANSWER-Interprets queries, creates a plan to modify the database or retrieve the
data, and returns query results to the application. Performs query optimization.
Query Optimization - ANSWER-Ensures efficient instructions are executed on the data from the Query
Processor.
Storage Manager - ANSWER-Translates the query processor instructions into low- level file-system
commands that modify OR retrieve data. Uses indexes to quickly locate data.
Transaction Manager - ANSWER-Ensures transactions are properly executed. Prevents conflicts
between concurrent transactions. Also restores the database to a consistent state in the event of a
failure.
Log - ANSWER-A file containing a complete record of ALL inserts, updates, and deletes processed by
the database. The records can be used to restore a database.
Catalog/Data Dictionary/Repository - ANSWER-A directory of tables, columns, indexes, and other
database objects.
Relational Database - ANSWER-Stores data in tables, columns, and rows, SIMILAR to a spreadsheet.
It also supports SQL. Made up of relations.
NoSQL - ANSWER-A new generation of DBMS that is NOT based on the traditional relational database
model.
CRUD - ANSWER-Acronym for actions that can be performed by a query.
SQL Statement - ANSWER-A database command such as a query that inserts, retrieves, updates, or
deletes data. Composed of one or more clauses.
INSERT - ANSWER-Inserts rows into a table.
SELECT - ANSWER-Retrieves data from a table.
UPDATE - ANSWER-Modifies data in a table.
DELETE - ANSWER-Deletes rows from a table.
CREATE TABLE - ANSWER-Creates a new table by specifying the table and column names.
, Data Type - ANSWER-Indicates the TYPE of data that can be stored in a field of a column.
Data Independence - ANSWER-Allows database administrators to improve query performance by
changing the organization of data on storage devices, without affecting query results or changes to
programs.
Database Design - ANSWER-A specification of database objects such as tables, columns data types,
and indexes. Also refers to the process used to develop the specifications.
Metadata - ANSWER-Data ABOUT the database, such as column names and the number of rows in
each table.
Database Design - Analysis - ANSWER-This phase specifies database requirements without regard to
a specific database system. May also be referred to as conceptual design, entity-relationship
modeling, and requirements definition.
Database Design - Logical Design - ANSWER-This phase implements database requirements in a
specific database system. Depicted in a table diagram.
Database Design - Physical Design - ANSWER-This phase adds indexes and specifies HOW tables are
organized on storage media. Specified with SQL statements.
Key - ANSWER-A column used to identify individual rows of a table. Used to refer to only one specific
row or record.
Application Programming Language (API) - ANSWER-A library of procedures or classes that links a
host programming language to a database.
Schema - ANSWER-The structure of tables in the database.
Foreign Key - ANSWER-What a primary key from one table is called when it is referenced in another
table. Important when starting to build relationships between tables. Refers to a primary key.
One-to-Many - ANSWER-This is the most common relationship. Associates ONE record in ONE table
with MULTIPLE records in another table.
One-to-One - ANSWER-Associates only ONE record on one table with ONE record on another table.
Data Manipulation Language (DML) - ANSWER-What language am I?
Allows users to access and modify the data to MAKE queries, and GENERATE reports. Interacting with
the data.
Data Definition Language (DDL) - ANSWER-What language am I?
Allows a database administrator to DEFINE the database structure, schema, and subschema.
Data Control Language (DCL) - ANSWER-What language am I?
Commands that CONTROL a database. Includes administering privileges and committing data.
MySQL Community/MySQL Server - ANSWER-Is a FREE EDITION. Includes a complete set of database
