C170 - PRE-ASSESSMENT GUIDING QUESTIONS |100% CORRECT| #LATEST

C170 - PRE-ASSESSMENT GUIDING QUESTIONS |100% CORRECT| #LATEST 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 *Ans* Many-to-many Which two examples are attributes? Choose 2 answers A person attending a meeting An employee number A sales meeting A meeting code *Ans* An employee number A meeting code Which delete rule sets 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 *Ans* Set-to-Null Refer to the given SQL statement. 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) NUL