WGU D426 Data Management -Foundations Knowledge Test
Exam/ 100 Exam Questions with Correct Verified Answers-
Latest Update 2024.
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/ 100 Exam Questions with Correct Verified Answers-
Latest Update 2024.
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
