WGU C170 EXAM 1
QUESTIONS AND VERIFED
CORRECT ANSWER GRADED
A+ LATEST 2026-2027 100%
GUARANTEED PASS
Candidate Key - CORRECT ANSWER-An attribute, or combination of attributes, that uniquely
identifies a row in a relation.
Composite Key - CORRECT ANSWER-A primary key that consists of more than one attribute
First Normal Form - CORRECT ANSWER--Eliminate repeating groups in individual tables.
-Create a separate table for each set of related data.
-Identify each set of related data with a primary key.
Second Normal Form - CORRECT ANSWER--Create separate tables for sets of values that apply
to multiple records.
-Relate these tables with a foreign key.
,Third Normal Form - CORRECT ANSWER--Eliminate fields that do not depend on the key.
Signed Number - CORRECT ANSWER-Positive or negative number
Unsigned Number - CORRECT ANSWER-A number that cannot be negative
Entity - CORRECT ANSWER-A person, place, product, concept, or activity
Binary Relationship - CORRECT ANSWER-A relationship between two entity types
Unary Relationship - CORRECT ANSWER-Associate occurrences of an entity type with other
occurrences of the same entity type
Ternary Relationship - CORRECT ANSWER-Involves three different entity types
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
Cascaded delete
Dynamic update - CORRECT ANSWER-Cascaded delete
Refer to the given information.
, CREATE TABLE 'test1' (
contact_id INT(10),
name VARCHAR(10),
event_id INT(5),
Which command should be added to the end to make the event_id attribute the primary key
within a CREATE TABLE statement?
PRIMARY KEY = event_id);
PRIMARY KEY (event_id));
(PRIMARY KEY: event_id);
PRIMARY (event_id)' - CORRECT ANSWER-PRIMARY KEY (event_id));
What does the clause PRIMARY KEY followed by a field name in parentheses mean in a CREATE
TABLE statement?
The primary key value, in parentheses, can be used by a column.
The column, in parentheses, is the primary key for the table.
The foreign key, in parentheses, is linked to the primary key.
The row, in parentheses, can be inserted as the foreign key. - CORRECT ANSWER-The column, in
parentheses, is the primary key for the table.
Which statement should be used so that it assigns a foreign key to the customer name?
FOREIGN KEY ( customer_name ) REFERENCES table_name ( customer_name )
FOREIGN KEY = customer_name REFERENCES table_name ( customer_name )
QUESTIONS AND VERIFED
CORRECT ANSWER GRADED
A+ LATEST 2026-2027 100%
GUARANTEED PASS
Candidate Key - CORRECT ANSWER-An attribute, or combination of attributes, that uniquely
identifies a row in a relation.
Composite Key - CORRECT ANSWER-A primary key that consists of more than one attribute
First Normal Form - CORRECT ANSWER--Eliminate repeating groups in individual tables.
-Create a separate table for each set of related data.
-Identify each set of related data with a primary key.
Second Normal Form - CORRECT ANSWER--Create separate tables for sets of values that apply
to multiple records.
-Relate these tables with a foreign key.
,Third Normal Form - CORRECT ANSWER--Eliminate fields that do not depend on the key.
Signed Number - CORRECT ANSWER-Positive or negative number
Unsigned Number - CORRECT ANSWER-A number that cannot be negative
Entity - CORRECT ANSWER-A person, place, product, concept, or activity
Binary Relationship - CORRECT ANSWER-A relationship between two entity types
Unary Relationship - CORRECT ANSWER-Associate occurrences of an entity type with other
occurrences of the same entity type
Ternary Relationship - CORRECT ANSWER-Involves three different entity types
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
Cascaded delete
Dynamic update - CORRECT ANSWER-Cascaded delete
Refer to the given information.
, CREATE TABLE 'test1' (
contact_id INT(10),
name VARCHAR(10),
event_id INT(5),
Which command should be added to the end to make the event_id attribute the primary key
within a CREATE TABLE statement?
PRIMARY KEY = event_id);
PRIMARY KEY (event_id));
(PRIMARY KEY: event_id);
PRIMARY (event_id)' - CORRECT ANSWER-PRIMARY KEY (event_id));
What does the clause PRIMARY KEY followed by a field name in parentheses mean in a CREATE
TABLE statement?
The primary key value, in parentheses, can be used by a column.
The column, in parentheses, is the primary key for the table.
The foreign key, in parentheses, is linked to the primary key.
The row, in parentheses, can be inserted as the foreign key. - CORRECT ANSWER-The column, in
parentheses, is the primary key for the table.
Which statement should be used so that it assigns a foreign key to the customer name?
FOREIGN KEY ( customer_name ) REFERENCES table_name ( customer_name )
FOREIGN KEY = customer_name REFERENCES table_name ( customer_name )
