WGU D426 Exam Questions and Correct Answers 100% Verified Graded A+
A ____ is a column, or group of columns, used to identify a row. - Primary key
A ____ consists of a single column. - Simple primary key
A ____ key consists of multiple columns. - 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. - 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. -
Primary key
An _____ is a numeric column that is assigned an automatically incrementing value when a new
row is inserted. - Auto-increment column
The ____ keyword defines an auto-increment column. It follows the column's data type in a
CREATE TABLE statement. - AUTO_INCREMENT
A ____ is a column, or group of columns, that refer to a primary key. - Foreign key
, ____ requires foreign key values must either be NULL or match some value of the referenced
primary key. - Referential integrity
A ____ constraint is added to a CREATE TABLE statement with the ____ and REFERENCES
keywords. - Foreign key; references
A ____ foreign key is a simple or composite foreign key in which all columns are NULL. -
Fully NULL
____ is a relational rule that requires foreign key values to either be fully NULL or match some
primary key value. - Referential integrity
____ rejects an insert, update, or delete that violates referential integrity. - RESTRICT
____ sets invalid foreign keys to NULL. - SET NULL
____ sets invalid foreign keys to the foreign key default value. - SET DEFAULT
____ propagates primary key changes to foreign keys. - CASCADE
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. -
ON UPDATE and ON DELETE
A ____ is a column, or group of columns, used to identify a row. - Primary key
A ____ consists of a single column. - Simple primary key
A ____ key consists of multiple columns. - 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. - 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. -
Primary key
An _____ is a numeric column that is assigned an automatically incrementing value when a new
row is inserted. - Auto-increment column
The ____ keyword defines an auto-increment column. It follows the column's data type in a
CREATE TABLE statement. - AUTO_INCREMENT
A ____ is a column, or group of columns, that refer to a primary key. - Foreign key
, ____ requires foreign key values must either be NULL or match some value of the referenced
primary key. - Referential integrity
A ____ constraint is added to a CREATE TABLE statement with the ____ and REFERENCES
keywords. - Foreign key; references
A ____ foreign key is a simple or composite foreign key in which all columns are NULL. -
Fully NULL
____ is a relational rule that requires foreign key values to either be fully NULL or match some
primary key value. - Referential integrity
____ rejects an insert, update, or delete that violates referential integrity. - RESTRICT
____ sets invalid foreign keys to NULL. - SET NULL
____ sets invalid foreign keys to the foreign key default value. - SET DEFAULT
____ propagates primary key changes to foreign keys. - CASCADE
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. -
ON UPDATE and ON DELETE
