WGU D426 Data Management -Foundations Knowledge Test
Exam Questions with 100% Correct Answers- Latest
2025/2026
A is a column, or group of columns, used to identify a row. - ANSWER - Primary key
A consists of a single column. - ANSWER - Simple primary key
A key consists of multiple columns. - ANSWER - Composite primary
All primary keys columns are necessary for uniqueness. When any column is removed, the resulting
simple or composite column is no longer unique. - ANSWER - Minimal
The constraint in the CREATE TABLE statement names the table's . The constraint ensures
that a column or group of columns is always unique and non-null. - ANSWER - Primary key
An is a numeric column that is assigned an automatically incrementing value when a new row is
inserted. - ANSWER - Auto-increment column
The keyword defines an auto-increment column. It follows the column's data type in a CREATE
TABLE statement. - ANSWER - AUTO_INCREMENT
A is a column, or group of columns, that refer to a primary key. - ANSWER - Foreign key
requires foreign key values must either be NULL or match some value of the referenced primary
key. - ANSWER - Referential integrity
pg. 1
, A constraint is added to a CREATE TABLE statement with the and REFERENCES keywords. -
ANSWER - Foreign key; references
A foreign key is a simple or composite foreign key in which all columns are NULL. - ANSWER - Fully
NULL
is a relational rule that requires foreign key values to either be fully NULL or match some primary
key value. - ANSWER - Referential integrity
Actions are specified in the optional and clauses of the FOREIGN KEY constraint. and
are followed by either RESTRICT, SET NULL, SET DEFAULT, or CASCADE. - ANSWER - ON UPDATE and
ON DELETE
A is a rule that governs allowable values in a database. are based on relational and business
rules, and implemented with special keywords in a CREATE TABLE statement. The database automatically
rejects insert, update, and delete statements that violate a constraint. - ANSWER - Constraint(s)
A appears after the column name and data type in a CREATE TABLE statement. Column constraints
govern values in a single column. - ANSWER - Column constraint
A appears in a separate clause of a CREATE TABLE statement and governs values in one or more
columns. - ANSWER - Table constraint
The constraint ensures that values in a column, or group of columns, are unique. - ANSWER -
UNIQUE
The constraint specifies an expression on one or more columns of a table. The constraint is violated
when the expression is FALSE and satisfied when the expression is either TRUE or NULL. - ANSWER -
CHECK
Table may be names using the optional CONSTRAINT keyword, followed by the constraint name
and declaration. - ANSWER - CONSTRAINT
pg. 2
Exam Questions with 100% Correct Answers- Latest
2025/2026
A is a column, or group of columns, used to identify a row. - ANSWER - Primary key
A consists of a single column. - ANSWER - Simple primary key
A key consists of multiple columns. - ANSWER - Composite primary
All primary keys columns are necessary for uniqueness. When any column is removed, the resulting
simple or composite column is no longer unique. - ANSWER - Minimal
The constraint in the CREATE TABLE statement names the table's . The constraint ensures
that a column or group of columns is always unique and non-null. - ANSWER - Primary key
An is a numeric column that is assigned an automatically incrementing value when a new row is
inserted. - ANSWER - Auto-increment column
The keyword defines an auto-increment column. It follows the column's data type in a CREATE
TABLE statement. - ANSWER - AUTO_INCREMENT
A is a column, or group of columns, that refer to a primary key. - ANSWER - Foreign key
requires foreign key values must either be NULL or match some value of the referenced primary
key. - ANSWER - Referential integrity
pg. 1
, A constraint is added to a CREATE TABLE statement with the and REFERENCES keywords. -
ANSWER - Foreign key; references
A foreign key is a simple or composite foreign key in which all columns are NULL. - ANSWER - Fully
NULL
is a relational rule that requires foreign key values to either be fully NULL or match some primary
key value. - ANSWER - Referential integrity
Actions are specified in the optional and clauses of the FOREIGN KEY constraint. and
are followed by either RESTRICT, SET NULL, SET DEFAULT, or CASCADE. - ANSWER - ON UPDATE and
ON DELETE
A is a rule that governs allowable values in a database. are based on relational and business
rules, and implemented with special keywords in a CREATE TABLE statement. The database automatically
rejects insert, update, and delete statements that violate a constraint. - ANSWER - Constraint(s)
A appears after the column name and data type in a CREATE TABLE statement. Column constraints
govern values in a single column. - ANSWER - Column constraint
A appears in a separate clause of a CREATE TABLE statement and governs values in one or more
columns. - ANSWER - Table constraint
The constraint ensures that values in a column, or group of columns, are unique. - ANSWER -
UNIQUE
The constraint specifies an expression on one or more columns of a table. The constraint is violated
when the expression is FALSE and satisfied when the expression is either TRUE or NULL. - ANSWER -
CHECK
Table may be names using the optional CONSTRAINT keyword, followed by the constraint name
and declaration. - ANSWER - CONSTRAINT
pg. 2
