12/8/24, 1:37 PM WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 3…
WGU C170 OBJECTIVE ASSESSMENT EXAM AND
PRACTICE EXAM /WGU C 170 DATA
MANAGEMENT APPLICATIONS OA 300
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+
Practice questions for this set
Learn
Studied 7 terms
Nice work, you're crushing it
Continue studying in Learn
Terms in this set (61)
A salesperson is Many-to-many
authorized to sell many
products and a product
can be sold by many
salespersons.
Which kind of binary
relationship does this
scenario describe?
https://quizlet.com/981643107/wgu-c170-objective-assessment-exam-and-practice-exam-wgu-c-170-data-management-applications-oa-300-question… 1/17
,12/8/24, 1:37 PM WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 3…
Many-to-many unary
Which kind of relationship
is displayed in this entity-
relationship diagram?
Unary one-to-one
Which kind of relationship
is displayed in this entity-
relationship diagram?
How is this portion of the At least one book was written
entity-relationship by an author.
diagram read, from left to
right?
Which two examples are An employee number
attributes?
A meeting code
Choose 2 answers
Which delete rule sets Set-to-Null
column values in a child
table to a missing value
when the matching data is
deleted from the parent
table?
In this entity-relationship The delete is prohibited.
diagram, Salesperson 361
is related to two
customers. The table
follows the restrict delete
rule.
What happens if someone
tries to delete
Salesperson 361 from the
customer records?
https://quizlet.com/981643107/wgu-c170-objective-assessment-exam-and-practice-exam-wgu-c-170-data-management-applications-oa-300-question… 2/17
, 12/8/24, 1:37 PM WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 3…
Refer to the given SQL member_id
statement.
CREATE TABLE member expiration
(
member_id INT
UNSIGNED NOT NULL
AUTO_INCREMENT,
PRIMARY KEY
(member_id),
last_name VARCHAR(20)
NOT NULL,
first_name VARCHAR(20)
NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE
NULL,email
VARCHAR(100) NULL,
street VARCHAR(50)
NULL,
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
zip VARCHAR(10) NULL,
phone VARCHAR(20)
NULL,
interests VARCHAR(255)
NULL);
Which two columns are
created as something
other than variable-length
strings in this statement?
Choose 2 answers
https://quizlet.com/981643107/wgu-c170-objective-assessment-exam-and-practice-exam-wgu-c-170-data-management-applications-oa-300-question… 3/17
WGU C170 OBJECTIVE ASSESSMENT EXAM AND
PRACTICE EXAM /WGU C 170 DATA
MANAGEMENT APPLICATIONS OA 300
QUESTIONS AND CORRECT DETAILED ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+
Practice questions for this set
Learn
Studied 7 terms
Nice work, you're crushing it
Continue studying in Learn
Terms in this set (61)
A salesperson is Many-to-many
authorized to sell many
products and a product
can be sold by many
salespersons.
Which kind of binary
relationship does this
scenario describe?
https://quizlet.com/981643107/wgu-c170-objective-assessment-exam-and-practice-exam-wgu-c-170-data-management-applications-oa-300-question… 1/17
,12/8/24, 1:37 PM WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 3…
Many-to-many unary
Which kind of relationship
is displayed in this entity-
relationship diagram?
Unary one-to-one
Which kind of relationship
is displayed in this entity-
relationship diagram?
How is this portion of the At least one book was written
entity-relationship by an author.
diagram read, from left to
right?
Which two examples are An employee number
attributes?
A meeting code
Choose 2 answers
Which delete rule sets Set-to-Null
column values in a child
table to a missing value
when the matching data is
deleted from the parent
table?
In this entity-relationship The delete is prohibited.
diagram, Salesperson 361
is related to two
customers. The table
follows the restrict delete
rule.
What happens if someone
tries to delete
Salesperson 361 from the
customer records?
https://quizlet.com/981643107/wgu-c170-objective-assessment-exam-and-practice-exam-wgu-c-170-data-management-applications-oa-300-question… 2/17
, 12/8/24, 1:37 PM WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 3…
Refer to the given SQL member_id
statement.
CREATE TABLE member expiration
(
member_id INT
UNSIGNED NOT NULL
AUTO_INCREMENT,
PRIMARY KEY
(member_id),
last_name VARCHAR(20)
NOT NULL,
first_name VARCHAR(20)
NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE
NULL,email
VARCHAR(100) NULL,
street VARCHAR(50)
NULL,
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
zip VARCHAR(10) NULL,
phone VARCHAR(20)
NULL,
interests VARCHAR(255)
NULL);
Which two columns are
created as something
other than variable-length
strings in this statement?
Choose 2 answers
https://quizlet.com/981643107/wgu-c170-objective-assessment-exam-and-practice-exam-wgu-c-170-data-management-applications-oa-300-question… 3/17
