Solve

Listen Your cousin asks you to help her prepare for her computer science exam next week. She gives you two clues about a type of relational database key: No column values may be NULL, and columns must be necessary for uniqueness. Which type of key is she referring to? Select one answer. Foreign key Alternate key Composite primary key O Simple primary key Question 2 (2 points) Listen During a casual discussion, your colleague claims that both data types and names of foreign and primary keys must be the same. Is this true or false? True False Question 3 (2 points) Listen There are four actions and outcomes listed below. These four actions can be implemented on a database to autocorrect violations of referential integrity. Match the action name with the outcome. Instructions: Choose your responses from the drop-down menus below. Responses cannot be used more than once. Propagates primary key changes to foreign keys 1. Restrict Sets invalid foreign keys to a default primary key value, 2. Set Null specified in SQL Rejects an insert, update, 3. Set Default or delete 4. Cascade Sets invalid foreign keys to NULL Question 4 (2 points) How can referential integrity be violated? Select all that apply. A primary key is inserted. )A row containing a primary key is deleted. A foreign key is updated.A row containing a foreign key is deleted. A primary key is updated. )A row containing a foreign key is inserted. Question 5 (2 points) For primary key deletions and updates, most databases support only the corrective action Restrict. True False