WGU D426 Data Management -
Foundations | newest/most recent
update | COMPREHENSIVE
QUESTIONS (frequently tested)
WITH VERIFIED ANSWERS (100%
ACCURATE ANSWERS)|ALREADY
GRADED A+
Save
Get a taste for our practice questions
Learn
, Studied 7 terms
Nice work, you're crushing it
Continue studying in Learn
Terms in this set (111)
A ____ is a Primary key
column, or
group of
columns, used
to identify a
row.
A ____ consists of Simple primary key
a single column.
A ____ key Composite primary
consists of
multiple
columns.
,All primary keys Minimal
columns are
necessary for
uniqueness.
When any
column is
removed, the
resulting simple
or composite
column is no
longer unique.
The ____ Primary key
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.
, An _____ is a Auto-increment column
numeric column
that is assigned
an
automatically
incrementing
value when a
new row is
inserted.
The ____ AUTO_INCREMENT
keyword
defines an auto-
increment
column. It
follows the
column's data
type in a
CREATE TABLE
statement.
Foundations | newest/most recent
update | COMPREHENSIVE
QUESTIONS (frequently tested)
WITH VERIFIED ANSWERS (100%
ACCURATE ANSWERS)|ALREADY
GRADED A+
Save
Get a taste for our practice questions
Learn
, Studied 7 terms
Nice work, you're crushing it
Continue studying in Learn
Terms in this set (111)
A ____ is a Primary key
column, or
group of
columns, used
to identify a
row.
A ____ consists of Simple primary key
a single column.
A ____ key Composite primary
consists of
multiple
columns.
,All primary keys Minimal
columns are
necessary for
uniqueness.
When any
column is
removed, the
resulting simple
or composite
column is no
longer unique.
The ____ Primary key
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.
, An _____ is a Auto-increment column
numeric column
that is assigned
an
automatically
incrementing
value when a
new row is
inserted.
The ____ AUTO_INCREMENT
keyword
defines an auto-
increment
column. It
follows the
column's data
type in a
CREATE TABLE
statement.