5/18/25, 7:00 PM WGU D426 EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (ALREADY GRADED A+) | VERIFIED ANSWERS | LATE…
WGU D426 EXAM 2025 | ALL QUESTIONS AND
CORRECT ANSWERS (ALREADY GRADED A+) |
VERIFIED ANSWERS | LATEST VERSION | WESTERN
GOVERNORS UNIVERSITY
Terms in this set (111)
A _ is a column, or group of Primary key
columns,
used to identify a row.
A _ consists of a single Simple primary key
column.
A _ key consists of multiple Composite primary
columns.
All primary keys columns are Minimal
necessary for uniqueness.
When any column is
removed, the resulting
simple or composite column
is no longer unique.
The constraint in the CREATE Primary key
TABLE
statement names the table's
____. The ____ constraint
ensures that a column or
group of columns is always
unique and non-null.
An _ is a numeric column that Auto-increment column
is assigned
an automatically
incrementing value when a
new row is inserted.
… 1/1
3
, 5/18/25, 7:00 PM WGU D426 EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (ALREADY GRADED A+) | VERIFIED ANSWERS | LATE…
The keyword defines an auto- AUTO_INCREMENT
increment
column. It follows the
column's data type in a
CREATE TABLE statement.
A _ is a column, or group of Foreign key
columns, that
refer to a primary key.
____ requires foreign key Referential integrity
values must either be NULL
or match some value of
the
referenced primary key.
A _ constraint is added to a Foreign key; references
CREATE
TABLE statement with the and
REFERENCES keywords.
A _ foreign key is a simple or Fully NULL
composite
foreign key in which all
columns are NULL.
____ is a relational rule that Referential integrity
requires foreign key values to
either be fully NULL or match
some primary key value.
____ rejects an insert, update, RESTRICT
or delete that violates
referential integrity.
____ sets invalid foreign keys to SET NULL
NULL.
____ sets invalid foreign keys SET DEFAULT
to the foreign key default
value.
____ propagates primary key CASCADE
changes to foreign keys.
Actions are specified in the ON UPDATE and ON DELETE
optional ____ and
____clauses of the
FOREIGN KEY
constraint. ____ and are
… 2/1
3
WGU D426 EXAM 2025 | ALL QUESTIONS AND
CORRECT ANSWERS (ALREADY GRADED A+) |
VERIFIED ANSWERS | LATEST VERSION | WESTERN
GOVERNORS UNIVERSITY
Terms in this set (111)
A _ is a column, or group of Primary key
columns,
used to identify a row.
A _ consists of a single Simple primary key
column.
A _ key consists of multiple Composite primary
columns.
All primary keys columns are Minimal
necessary for uniqueness.
When any column is
removed, the resulting
simple or composite column
is no longer unique.
The constraint in the CREATE Primary key
TABLE
statement names the table's
____. The ____ constraint
ensures that a column or
group of columns is always
unique and non-null.
An _ is a numeric column that Auto-increment column
is assigned
an automatically
incrementing value when a
new row is inserted.
… 1/1
3
, 5/18/25, 7:00 PM WGU D426 EXAM 2025 | ALL QUESTIONS AND CORRECT ANSWERS (ALREADY GRADED A+) | VERIFIED ANSWERS | LATE…
The keyword defines an auto- AUTO_INCREMENT
increment
column. It follows the
column's data type in a
CREATE TABLE statement.
A _ is a column, or group of Foreign key
columns, that
refer to a primary key.
____ requires foreign key Referential integrity
values must either be NULL
or match some value of
the
referenced primary key.
A _ constraint is added to a Foreign key; references
CREATE
TABLE statement with the and
REFERENCES keywords.
A _ foreign key is a simple or Fully NULL
composite
foreign key in which all
columns are NULL.
____ is a relational rule that Referential integrity
requires foreign key values to
either be fully NULL or match
some primary key value.
____ rejects an insert, update, RESTRICT
or delete that violates
referential integrity.
____ sets invalid foreign keys to SET NULL
NULL.
____ sets invalid foreign keys SET DEFAULT
to the foreign key default
value.
____ propagates primary key CASCADE
changes to foreign keys.
Actions are specified in the ON UPDATE and ON DELETE
optional ____ and
____clauses of the
FOREIGN KEY
constraint. ____ and are
… 2/1
3
