Primary and foreign keys are essential concepts in relational database design. They define relationships and ensure data integrity. This quiz on primary key and foreign key in SQL helps learners differentiate between the two and understand how they work together.
Time limit: 0
Quiz Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
What happens when a referenced primary key is deleted without ON DELETE CASCADE?
Correct
Incorrect
Question 7 of 15
7. Question
Which keyword defines a foreign key in SQL?
Correct
Incorrect
Question 8 of 15
8. Question
What is the main purpose of a foreign key?
Correct
Incorrect
Question 9 of 15
9. Question
Which SQL constraint is automatically applied to primary keys?
Correct
Incorrect
Question 10 of 15
10. Question
In a parent-child table relationship, which table holds the primary key?
Correct
Incorrect
Question 11 of 15
11. Question
What does the ON DELETE CASCADE option do for a foreign key?
Correct
Incorrect
Question 12 of 15
12. Question
Can a primary key be a combination of multiple columns?
Correct
Incorrect
Question 13 of 15
13. Question
What is violated if you insert a foreign key value that doesn’t exist in the parent table?
Correct
Incorrect
Question 14 of 15
14. Question
Which type of join is typically used between primary key and foreign key columns?
Correct
Incorrect
Question 15 of 15
15. Question
Can a foreign key reference a unique key instead of a primary key?
Correct
Incorrect
Summary
Understanding primary keys and foreign keys is crucial for designing normalized, relational databases. This quiz on SQL primary key, foreign key explores definitions, constraints, relationships, and common use cases of keys in SQL.
At QuizOrbit, our team specializes in fun, informative quizzes across topics like general knowledge, technology, and entertainment. Boost your knowledge with our expert-designed quizzes.
