Science Computer Science
WGU D426 EXAM 2025 | ALL QUESTIONS AND CORRECT
ANSWERS (ALREADY GRADED A+) | VERIFIED ANSWERS |
LATEST VERSION | WESTERN GOVERNORS UNIVERSITY
Save
Students also studied
Flashcard sets Study guides
SIT How Qlik Sense Business Analyst Exam Watchguard Networ
145 terms 30 terms Teacher 67 terms
Preview avigayelnyambura Preview Muia_Son8
Stretch your brain before your first study session
Learn 1 /7 Study with Learn
Refer to strong entities as ____ and weak entities as ____.
Choose matching definition
1 Independent; dependent 2 Standalone; linked
3 Autonomous; subordinate 4 Self-sufficient; reliant
Don't know?
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.
The ____ keyword defines an AUTO_INCREMENT
auto-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 values Referential integrity
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, or RESTRICT
delete that violates referential
integrity.
____ sets invalid foreign keys to SET NULL
NULL.
____ sets invalid foreign keys to SET DEFAULT
the foreign key default value.
____ propagates primary key CASCADE
changes to foreign keys.
WGU D426 EXAM 2025 | ALL QUESTIONS AND CORRECT
ANSWERS (ALREADY GRADED A+) | VERIFIED ANSWERS |
LATEST VERSION | WESTERN GOVERNORS UNIVERSITY
Save
Students also studied
Flashcard sets Study guides
SIT How Qlik Sense Business Analyst Exam Watchguard Networ
145 terms 30 terms Teacher 67 terms
Preview avigayelnyambura Preview Muia_Son8
Stretch your brain before your first study session
Learn 1 /7 Study with Learn
Refer to strong entities as ____ and weak entities as ____.
Choose matching definition
1 Independent; dependent 2 Standalone; linked
3 Autonomous; subordinate 4 Self-sufficient; reliant
Don't know?
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.
The ____ keyword defines an AUTO_INCREMENT
auto-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 values Referential integrity
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, or RESTRICT
delete that violates referential
integrity.
____ sets invalid foreign keys to SET NULL
NULL.
____ sets invalid foreign keys to SET DEFAULT
the foreign key default value.
____ propagates primary key CASCADE
changes to foreign keys.
