8/17/25, 4:10 C170 Practice Test Flashcards |
PM Quizlet
C170 Practice Test| questions and Answers
AAAAA you are creating a ON DELETE SET TO NULL
database which will have the 2
tables shown above.
You need to ensure that if a
category is removed from the
Category table, all related
3 multiple choice options
product rows would have their
CategoryID set to a null value.
What should you use?
Which rule would you use in ON DELETE CASCADE 3 multiple choice options
your CREATE TABLE statement
for your Category table if you
would like to have all products
related to a specific category
deleted if they are linked to a
category that is deleted?
Which rule would you use in ON DELETE RESTRICT 3 multiple choice options
your CREATE TABLE statement
for your Category table if you
needed to prevent deletion of
a category if there were
associated products in the
Product table?
You are creating a relational Create a new column in the Course table.
database to store information
about instructors and the courses
that each instructor teaches.
Each course is taught by a
single instructor. You have
created an Instructor table and
a Course table as shown above. 3 multiple choice options
You need to create a relationship
between the Instructor table and
the Course table. You need to
keep duplicate data to a
minimum. What should you do?
https://quizlet.com/812292810/c170-practice-test-flash- 1/
cards/ 19
,8/17/25, 4:10 C170 Practice Test Flashcards |
PM Quizlet
A specific course is taught by one and
only one instructor.
In the relationship depicted below,
which of the following is true?
3 multiple choice options
What is a characteristic of a Tables do not contain multi-valued or repeating fields. 3 multiple choice
database that is normalized to options
the first normal form?
What is a characteristic of a There are no values that are dependent on only part of a composite primary
database that is normalized to key.
the second normal form? 3 multiple choice options
What is a characteristic of a All redundancy has been removed. 3 multiple choice options
database that is normalized to There are no transitive dependencies.
the third normal form? (Choose
2)
Dependencies that are based False 2 multiple choice options
on only a part of a composite
primary key are called transitive
dependencies.
Since a partial dependency can True 2 multiple choice options
exist only if a table's primary key
is composed of two or more
attributes, if a table in 1NF has
a
single-attribute primary key, then
the table is automatically in
2NF.
A(n)___exists when there are transitive dependency 3 multiple choice options
functional
dependencies such that Y is
functionally dependent on X, Z
is functionally dependent on Y,
and X is the primary key.
Dependencies based on only a Partial 3 multiple choice options
part of a composite primary key
are known as _____
dependencies.
A table that is in 2NF and 3NF 3 multiple choice options
contains no transitive
dependencies is said to be in
______________________________
_.
Entity integrity is enforced True 2 multiple choice options
automatically when the primary
key is specified in the CREATE
https://quizlet.com/812292810/c170-practice-test-flash- 2/
cards/ 19
, 8/17/25, 4:10 C170 Practice Test Flashcards |
PM Quizlet
TABLE command sequence.
SQL requires the use of the ADD False 2 multiple choice options
command to enter data into a
table.
When joining three or more tables, False 2 multiple choice options
you
need to specify a join condition for
one pair of tables.
The SQL data manipulation Restricts the selection of grouped rows based on a condition. 3 multiple
command HAVING: choice options
A determinant is any attribute True 2 multiple choice options
whose value determines other
values within a column.
The___constraint assigns a value to DEFAULT 3 multiple choice options
an
attribute when a new row is added
to a table.
https://quizlet.com/812292810/c170-practice-test-flash- 3/
cards/ 19
PM Quizlet
C170 Practice Test| questions and Answers
AAAAA you are creating a ON DELETE SET TO NULL
database which will have the 2
tables shown above.
You need to ensure that if a
category is removed from the
Category table, all related
3 multiple choice options
product rows would have their
CategoryID set to a null value.
What should you use?
Which rule would you use in ON DELETE CASCADE 3 multiple choice options
your CREATE TABLE statement
for your Category table if you
would like to have all products
related to a specific category
deleted if they are linked to a
category that is deleted?
Which rule would you use in ON DELETE RESTRICT 3 multiple choice options
your CREATE TABLE statement
for your Category table if you
needed to prevent deletion of
a category if there were
associated products in the
Product table?
You are creating a relational Create a new column in the Course table.
database to store information
about instructors and the courses
that each instructor teaches.
Each course is taught by a
single instructor. You have
created an Instructor table and
a Course table as shown above. 3 multiple choice options
You need to create a relationship
between the Instructor table and
the Course table. You need to
keep duplicate data to a
minimum. What should you do?
https://quizlet.com/812292810/c170-practice-test-flash- 1/
cards/ 19
,8/17/25, 4:10 C170 Practice Test Flashcards |
PM Quizlet
A specific course is taught by one and
only one instructor.
In the relationship depicted below,
which of the following is true?
3 multiple choice options
What is a characteristic of a Tables do not contain multi-valued or repeating fields. 3 multiple choice
database that is normalized to options
the first normal form?
What is a characteristic of a There are no values that are dependent on only part of a composite primary
database that is normalized to key.
the second normal form? 3 multiple choice options
What is a characteristic of a All redundancy has been removed. 3 multiple choice options
database that is normalized to There are no transitive dependencies.
the third normal form? (Choose
2)
Dependencies that are based False 2 multiple choice options
on only a part of a composite
primary key are called transitive
dependencies.
Since a partial dependency can True 2 multiple choice options
exist only if a table's primary key
is composed of two or more
attributes, if a table in 1NF has
a
single-attribute primary key, then
the table is automatically in
2NF.
A(n)___exists when there are transitive dependency 3 multiple choice options
functional
dependencies such that Y is
functionally dependent on X, Z
is functionally dependent on Y,
and X is the primary key.
Dependencies based on only a Partial 3 multiple choice options
part of a composite primary key
are known as _____
dependencies.
A table that is in 2NF and 3NF 3 multiple choice options
contains no transitive
dependencies is said to be in
______________________________
_.
Entity integrity is enforced True 2 multiple choice options
automatically when the primary
key is specified in the CREATE
https://quizlet.com/812292810/c170-practice-test-flash- 2/
cards/ 19
, 8/17/25, 4:10 C170 Practice Test Flashcards |
PM Quizlet
TABLE command sequence.
SQL requires the use of the ADD False 2 multiple choice options
command to enter data into a
table.
When joining three or more tables, False 2 multiple choice options
you
need to specify a join condition for
one pair of tables.
The SQL data manipulation Restricts the selection of grouped rows based on a condition. 3 multiple
command HAVING: choice options
A determinant is any attribute True 2 multiple choice options
whose value determines other
values within a column.
The___constraint assigns a value to DEFAULT 3 multiple choice options
an
attribute when a new row is added
to a table.
https://quizlet.com/812292810/c170-practice-test-flash- 3/
cards/ 19
