DAD 220 - 3-1 Exam Questions with 100% Correct Answers | Verified | Updated 2024, Exams of Advanced Education

Download DAD 220 - 3-1 Exam Questions with 100% Correct Answers | Verified | Updated 2024 and more Exams Advanced Education in PDF only on Docsity!

DAD 220 - 3-1 Exam Questions with

100% Correct Answers | Verified |

Updated 2024

Your cousin, a senior in high school, asks you to play a Jeopardy-style game with her to help prepare for her computer science exam next week. She gives you these two clues about a type of relational database key: No column values may be NULL, and columns may be combined to create a unique primary key. Which type of key is she referring to? Select one. - Correct Answer-Composite primary key 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? - Correct Answer-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. - Correct Answer-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 Which of these are ways in which referential integrity can be violated? Select all that apply. - Correct Answer-a primary key is updated a foreign key is updated a row containing a foreign key is inserted a row containing a primary key is deleted. 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. - Correct Answer-False 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. - Correct Answer-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. - Correct Answer-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. 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. - Correct Answer-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 Your coworker has decided to take an online course about the basics of databases so that he can improve his job performance. As you study with him at lunch, he says that he thinks attributes are essential in an ER diagram. Is this true or false? - Correct Answer-False 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. - Correct Answer-Order by