C170 EXAM QUESTIONS WITH 100% CORRECT ANSWERS { GRADED A+}

C170 EXAM QUESTIONS WITH 100%

CORRECT ANSWERS { GRADED A+}




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

✔✔Many-to-many


Which two examples are attributes? - ✔✔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? - ✔✔Set-to-Null


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,

Which two columns are created as something other than variable-length

strings in this statement? - ✔✔member_id


expiration

This database table has ten different employee numbers in the first

column. Employee_ID is the primary

key. In addition, it has ten different names in the second column and two

office addresses repeated five

times each in the third column.

Which action should be used to translate this data into third normal

form? - ✔✔Move the data from the third column into its own table.