Testtrackers
1
DAD 220 - 3-1 QUIZ EXAM QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) ||ALREADY GRADED A+||NEWEST
VERSION
Quiz: 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.
Ans: Composite primary key
Quiz: 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?
Ans: False
o
o
© 2025 TestTrackers
WhatsApp or call o Resources & Updates: [Testtrackers - Stuvia US]
o Your Success is Our Mission!
[+ 254707240657]
o For online exams and tutor expert, please
whatsapp me in the number given.
, Testtrackers
2
Quiz: 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.
Ans: 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
Quiz: Which of these are ways in which referential integrity can be
violated? Select all that apply.
o
o
© 2025 TestTrackers
WhatsApp or call o Resources & Updates: [Testtrackers - Stuvia US]
o Your Success is Our Mission!
[+ 254707240657]
o For online exams and tutor expert, please
whatsapp me in the number given.
1
DAD 220 - 3-1 QUIZ EXAM QUESTIONS AND
CORRECT DETAILED ANSWERS (VERIFIED
ANSWERS) ||ALREADY GRADED A+||NEWEST
VERSION
Quiz: 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.
Ans: Composite primary key
Quiz: 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?
Ans: False
o
o
© 2025 TestTrackers
WhatsApp or call o Resources & Updates: [Testtrackers - Stuvia US]
o Your Success is Our Mission!
[+ 254707240657]
o For online exams and tutor expert, please
whatsapp me in the number given.
, Testtrackers
2
Quiz: 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.
Ans: 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
Quiz: Which of these are ways in which referential integrity can be
violated? Select all that apply.
o
o
© 2025 TestTrackers
WhatsApp or call o Resources & Updates: [Testtrackers - Stuvia US]
o Your Success is Our Mission!
[+ 254707240657]
o For online exams and tutor expert, please
whatsapp me in the number given.
