What is a foreign key in a database table? MCQ with Answer and Explanation

Question
What is a foreign key in a database table?
A. A key that allows null values
B. A column that references the primary key of another table
C. A key used to uniquely identify records in the same table
D. A key that is always indexed
Answer: Option B
Solution (By JKSSB Mock Tests)
A foreign key is a field in one table that links to the primary key of another table, establishing a relationship between tables.
This question belongs to: Computer Database Management System (DBMS)
Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
Which schema architecture level describes how the data is physically stored on disk storage media?
A. Conceptual Level
B. Logical Level
C. External Level
D. Internal Level
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Internal (or Physical) level of the three-schema architecture describes the physical storage structure and access paths of the database.
This question belongs to: Computer Database Management System (DBMS)
Question #2
In DBMS, what is the role of a DBA?
A. Data Backup Assistant
B. Dynamic Binary Analyzer
C. Database Application Builder
D. Database Administrator who manages the database system
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The Database Administrator (DBA) is responsible for designing, implementing, maintaining, and securing the database.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a property of a well-designed database?
A. Support for efficient data retrieval
B. All of the above
C. Ease of data maintenance
D. Avoidance of data redundancy
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Good database design aims to minimize redundancy, simplify maintenance, and provide efficient access.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: