WGU D426 Data ManaGeMent FoUnDations
(Latest Version 2026/2027) – Q&a
Data - Answer-Numeric, textual, visual, or audio information that describes real-
world systems. It is collected and processed to aid in a variety of tasks.
Analog Data - Answer-Most common before computers. Audio was recorded as
vibrations impressed on vinyl disks.
Digital Data - Answer-Most common today. Encoded as 0s and 1s on electronic
magnetic data.
Database - Answer-A collection of data in structured format. In principle, can be
stored on paper or even clay tablets.
Database System (DBMS) - Answer-Software that reads and writes in a database.
Query - Answer-A request to retrieve or change data in a database. Typically
inserts new data, retrieves data, updates, data, or deletes data from a database.
Query Language - Answer-Specialized programming language designed specifically
for database systems. Reads and writes data efficiently.
,Database Application - Answer-Software that HELPS business users interact with
database systems.
DROP TABLE - Answer-This statement deletes a table, along with all the table's
rows, from a database.
Operator - Answer-A symbol that computes a value from one or more other values
called operands.
Unary - Answer-Operator that has ONE operand.
Binary - Answer-Operator that has TWO operands.
Condition - Answer-An expression that evaluates to a logical value.
NULL - Answer-Special value that represents either UNKNOWN or inapplicable
data. Not the same as zero.
TRUNCATE - Answer-Deletes ALL ROWS from a table.
MERGE - Answer-Selects data from one table, called the source, and inserts the
data to another table, called the target. If the primary keys of source and target
rows match, the target values are updated to the corresponding values.
Primary Key - Answer-A column, or group of columns, used to identify a row.
Usually the table's FIRST column.
, Simple Primary Key - Answer-Consists of a single column.
Composite Primary Key - Answer-Consists of multiple columns and are denoted
with parentheses ().
Referential Integrity - Answer-A relational rule that requires foreign key values are
either fully NULL or match some primary key value.
CASCADE - Answer-Propagates primary key changes to foreign keys.
Constraint - Answer-A rule that governs allowable values in a database.
Column Constraint - Answer-Appears after the column name and data type in a
CREATE TABLE statement. Govern values in a single column.
Table Constraint - Answer-Appears in a SEPARATE clause of a CREATE TABLE
statement.
BETWEEN operator - Answer-This operator provides an alternative way to
determine if a value is between two other values.
LIKE operator - Answer-When used in a WHERE clause, this operator matches text
against a pattern using the two wildcard characters "%" and "_".
(Latest Version 2026/2027) – Q&a
Data - Answer-Numeric, textual, visual, or audio information that describes real-
world systems. It is collected and processed to aid in a variety of tasks.
Analog Data - Answer-Most common before computers. Audio was recorded as
vibrations impressed on vinyl disks.
Digital Data - Answer-Most common today. Encoded as 0s and 1s on electronic
magnetic data.
Database - Answer-A collection of data in structured format. In principle, can be
stored on paper or even clay tablets.
Database System (DBMS) - Answer-Software that reads and writes in a database.
Query - Answer-A request to retrieve or change data in a database. Typically
inserts new data, retrieves data, updates, data, or deletes data from a database.
Query Language - Answer-Specialized programming language designed specifically
for database systems. Reads and writes data efficiently.
,Database Application - Answer-Software that HELPS business users interact with
database systems.
DROP TABLE - Answer-This statement deletes a table, along with all the table's
rows, from a database.
Operator - Answer-A symbol that computes a value from one or more other values
called operands.
Unary - Answer-Operator that has ONE operand.
Binary - Answer-Operator that has TWO operands.
Condition - Answer-An expression that evaluates to a logical value.
NULL - Answer-Special value that represents either UNKNOWN or inapplicable
data. Not the same as zero.
TRUNCATE - Answer-Deletes ALL ROWS from a table.
MERGE - Answer-Selects data from one table, called the source, and inserts the
data to another table, called the target. If the primary keys of source and target
rows match, the target values are updated to the corresponding values.
Primary Key - Answer-A column, or group of columns, used to identify a row.
Usually the table's FIRST column.
, Simple Primary Key - Answer-Consists of a single column.
Composite Primary Key - Answer-Consists of multiple columns and are denoted
with parentheses ().
Referential Integrity - Answer-A relational rule that requires foreign key values are
either fully NULL or match some primary key value.
CASCADE - Answer-Propagates primary key changes to foreign keys.
Constraint - Answer-A rule that governs allowable values in a database.
Column Constraint - Answer-Appears after the column name and data type in a
CREATE TABLE statement. Govern values in a single column.
Table Constraint - Answer-Appears in a SEPARATE clause of a CREATE TABLE
statement.
BETWEEN operator - Answer-This operator provides an alternative way to
determine if a value is between two other values.
LIKE operator - Answer-When used in a WHERE clause, this operator matches text
against a pattern using the two wildcard characters "%" and "_".
