1|Page
WGU C170 EXAM || MOST RECENT EXAM ACTUAL
COMPLETE REAL VERIFIED EXAM QUESTIONS AND
CORRECT ANSWERS (VERIFIED ANSWERS)
ALREADY GRADED A+ | GUARANTEED SUCCESS!!
NEWEST EXAM!!!
Employee_ID Employee_Name Office_Address
12342 Jacob 54123 Main Street
12346 Michael 354 Center Avenue
12846 Ethan 54123 Main Street
12887 Joshua 54123 Main Street
12894 Daniel 354 Center Avenue
13097 Alexander 354 Center Avenue
13112 Anthony 54123 Main Street
13411 William 354 Center Avenue
13987 Christopher 354 Center Avenue
13998 Matthew 54123 Main Street
This database table has ten different employee numbers in
the first column. Employee_ID is the primary key. In
addition, it has ten different names in the second column
and two office addresses repeated five times each in the
third column.
,2|Page
Which action should be used to translate this data into
third normal form?
Move the data from the third column into the first column.
Move the data from the third column into its own table.
Move the data from the first two columns into separate
tables.
Move the data from the second column into the third
column. - Answer-Move the data from the third column into
its own table.
A database manager starts to convert data that has been
normalized into a form that conforms to the relational
model. A simple primary key has been established and all
the repeating groups have been deleted.
In which form is this data?
First normal form
Second normal form
Third normal form
,3|Page
Fourth normal form - Answer-Second normal form
Two attributes in two related tables have the exact same
domain of values. The attribute is a primary key in one
table.
Which kind of key is the attribute in the other table?
Foreign
Primary
Compound
Composite - Answer-Foreign
When a product is deleted from the product table, all
corresponding rows for the product in the pricing table are
deleted automatically as well.
What is this referential integrity technique called?
Foreign key constraint
Referential delete
, 4|Page
Cascaded delete
Dynamic update - Answer-Cascaded delete
Refer to the given information.
CREATE TABLE 'test1' (
contact_id INT(10),
name VARCHAR(10),
event_id INT(5),
A salesperson is authorized to sell many products and a
product can be sold by many salespersons.
Which kind of binary relationship does this scenario
describe?
One-to-one
One-to-many
Many-to-many
One-to-one binary - Answer-Many-to-many
Which two examples are attributes?
WGU C170 EXAM || MOST RECENT EXAM ACTUAL
COMPLETE REAL VERIFIED EXAM QUESTIONS AND
CORRECT ANSWERS (VERIFIED ANSWERS)
ALREADY GRADED A+ | GUARANTEED SUCCESS!!
NEWEST EXAM!!!
Employee_ID Employee_Name Office_Address
12342 Jacob 54123 Main Street
12346 Michael 354 Center Avenue
12846 Ethan 54123 Main Street
12887 Joshua 54123 Main Street
12894 Daniel 354 Center Avenue
13097 Alexander 354 Center Avenue
13112 Anthony 54123 Main Street
13411 William 354 Center Avenue
13987 Christopher 354 Center Avenue
13998 Matthew 54123 Main Street
This database table has ten different employee numbers in
the first column. Employee_ID is the primary key. In
addition, it has ten different names in the second column
and two office addresses repeated five times each in the
third column.
,2|Page
Which action should be used to translate this data into
third normal form?
Move the data from the third column into the first column.
Move the data from the third column into its own table.
Move the data from the first two columns into separate
tables.
Move the data from the second column into the third
column. - Answer-Move the data from the third column into
its own table.
A database manager starts to convert data that has been
normalized into a form that conforms to the relational
model. A simple primary key has been established and all
the repeating groups have been deleted.
In which form is this data?
First normal form
Second normal form
Third normal form
,3|Page
Fourth normal form - Answer-Second normal form
Two attributes in two related tables have the exact same
domain of values. The attribute is a primary key in one
table.
Which kind of key is the attribute in the other table?
Foreign
Primary
Compound
Composite - Answer-Foreign
When a product is deleted from the product table, all
corresponding rows for the product in the pricing table are
deleted automatically as well.
What is this referential integrity technique called?
Foreign key constraint
Referential delete
, 4|Page
Cascaded delete
Dynamic update - Answer-Cascaded delete
Refer to the given information.
CREATE TABLE 'test1' (
contact_id INT(10),
name VARCHAR(10),
event_id INT(5),
A salesperson is authorized to sell many products and a
product can be sold by many salespersons.
Which kind of binary relationship does this scenario
describe?
One-to-one
One-to-many
Many-to-many
One-to-one binary - Answer-Many-to-many
Which two examples are attributes?
