CIT 111 FINAL EXAM ACTUAL EXAM
2025 | ALL QUESTIONS AND
CORRECT ANSWERS (VERIFIED
ANSWERS) | GRADED A+ | LATEST
EXAM | JUST RELEASED
Save
Terms in this set (218)
You can use the SELECT
AS keyword with
the CREATE
TABLE statement
to create a copy
of a table from a
____________________
statement.
,When you code NULL
a column list in
an INSERT
statement, you
can omit
columns with
default values
and columns
that allow
________________________
____ values.
,If you code a DEFAULT
column list in an
INSERT
statement that
includes a
column that's
defined with a
default value,
you can insert
the default value
for that column
by coding the
____________________
keyword in the
VALUES clause
of the INSERT
statement.
, By default, DELETE
MySQL
automatically
commits
changes to the
database
immediately
after each
INSERT,
UPDATE, and
______________
statement that
you issue
2025 | ALL QUESTIONS AND
CORRECT ANSWERS (VERIFIED
ANSWERS) | GRADED A+ | LATEST
EXAM | JUST RELEASED
Save
Terms in this set (218)
You can use the SELECT
AS keyword with
the CREATE
TABLE statement
to create a copy
of a table from a
____________________
statement.
,When you code NULL
a column list in
an INSERT
statement, you
can omit
columns with
default values
and columns
that allow
________________________
____ values.
,If you code a DEFAULT
column list in an
INSERT
statement that
includes a
column that's
defined with a
default value,
you can insert
the default value
for that column
by coding the
____________________
keyword in the
VALUES clause
of the INSERT
statement.
, By default, DELETE
MySQL
automatically
commits
changes to the
database
immediately
after each
INSERT,
UPDATE, and
______________
statement that
you issue
