WGU PRE-ASSESSMENT: DATA MANAGEMENT - APPLICATIONS (FJO1) (PFJO) NEWEST ACTUAL EXAM COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS

WGU - Pre-Assessment: Data Management -
Applications (FJO1) (PFJO)

Terms in this set (54)

A salesperson is authorized Many-to-many
to sell many products and a
product can be sold by
many salespersons.


Which kind of binary
relationship does this
scenario describe?

Which two examples are An employee number
attributes? A meeting code
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?

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

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