What is the purpose of a Foreign Key? MCQ with Answer and Explanation

Question
What is the purpose of a Foreign Key?
A. To uniquely identify records
B. To create indexes
C. To sort data
D. To link two tables and enforce referential integrity
Answer: Option D
Solution (By JKSSB Mock Tests)
A foreign key establishes a relationship between tables and maintains referential integrity.
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
A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?
A. Partial Dependency
B. Trivial Dependency
C. Transitive Dependency
D. Join Dependency
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.
This question belongs to: Computer Database Management System (DBMS)
Question #2
In SQL, which statement is used to create a new database?
A. NEW DATABASE
B. CREATE TABLE
C. CREATE DATABASE
D. CREATE SCHEMA
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
CREATE DATABASE is used to create a new database in SQL.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Candidate keys that are not selected or designated as the primary key of a table are known as what?
A. Super Keys
B. Foreign Keys
C. Composite Keys
D. Alternate Keys
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Software 347 Internet and Web Technologies 461 Computer Fundamentals 326 Microsoft Office 1199 CPU (Central Processing Unit) 327
Explore Subjects
Computer 5279 Static General Knowledge 6362 English 15164 Current Affairs 575 History GK 3374
Practice Mix
The difference between simple interest and compound interest on a certain sum of money for 2 years at 9% per annum is Rs. 81. Find the sum.
The process by which plants lose water in the form of liquid droplets is:
The 'Vote on Account' is used to:
Software programs that are custom engineered for banking automated teller machines (ATMs) to connect securely to institutional transaction ledger networks are classified as:
Which is the capital of South Africa (legislative)?