SNHU DAD 220 - 3-1 Quiz | Latest Update | 2024/2025 | Already Passed

SNHU DAD 220 - 3-1 Quiz | Latest Update | 2024/2025 | Already Passed At a local hackathon, you and your classmates are invited to play a "Deal or No Deal" type of game about databases. To win the first round, you must state whether the following statement is true or false: For primary key deletions and updates, most databases support only the corrective action Restrict. False During a water cooler chat, your colleague claims that both data types and names of foreign and primary keys must be the same. Is this true or false? False Four actions that can be implemented on a database to autocorrect violations of referential integrity, and the outcomes of the actions are listed below. Match the violation with the corrective action. Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once. Sets invalid foreign keys to NULL - Set Null Sets invalid foreign keys to a default primary key value, specified in SQL - Set default Rejects an insert, update, or delete - Restrict Propagates primary key changes to foreign keys - Cascade If you needed the database to select values in a specific order but order them in ascending order, which of the following clauses should you use along with the SELECT command? Select one. Order by Match the join type with the correct definition. Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once. Only matching left table rows by all right table rows - Right join Only matching left and right table rows - Inner join Only matching right table rows but all left table rows - Left join All left and right table rows, regardless of match - Full join Three actions that databases can take when autocorrecting foreign key insertions and updates are listed below, as are the additional limitations on databases for each action. Match each action to its associated limitation. Instructions: Choose your responses from the drop-down menus below. Response options cannot be used more than once. The value specified for it must be a valid primary key - Set default It is applied when no action is specified - Restrict It cannot be used when a foreign key is not NULL - Set Null When the action Cascade propagates the changes made to a primary key to the associated foreign key, which of the following are the outcomes? Select all that apply. Rows containing invalid foreign keys are deleted when the primary key is deleted. Invalid foreign keys are set to the new primary key value when a primary key is updated. Which of these are ways in which referential