Computer Science · Database Management Systems
Which of the following statements most accurately describes the structural definition and null-allowance characteristics of a Foreign Key within the relational database model?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1It is a minimal set of attributes that uniquely identifies every tuple within a single relation, and to ensure data consistency, it strictly prohibits the inclusion of any NULL values.
- 2It is a dynamically computed attribute that exists solely during query execution, relying entirely on the Primary Key of its own relation to generate temporary, non-null values.
- 3It is an attribute or set of attributes in one relation that references the Primary Key of another relation to enforce referential integrity, and unlike a Primary Key, it generally permits NULL values.✓
- 4It is any encompassing set of attributes that uniquely identifies a tuple, which may contain redundant attributes and fundamentally prohibits NULL values to maintain entity integrity.
Correct answer
It is an attribute or set of attributes in one relation that references the Primary Key of another relation to enforce referential integrity, and unlike a Primary Key, it generally permits NULL values.
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Database Management Systems MCQs →Want more practice questions on Database Management Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Management Systems