WGU D169 QA Final Exam – Data Management Applications Objective Assessment Prep

WGU D169 QA Final Exam – Data Management
Applications Objective Assessment Prep

Save




Terms in this set (53)


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?


One-to-one
One-to-many
Many-to-many
One-to-one binary

Which two examples are An employee number
attributes? A meeting code


Choose 2 answers


A person attending a
meeting
An employee number
A sales meeting
A meeting code

,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?


Restrict
Cascade
Matching
Set-to-Null

,Refer to the given SQL member_id
statement. expiration


CREATE TABLE member
(
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


member_id

, last name
suffix
expiration
email
city