Which type of relationship is represented by a foreign key in a relational database? MCQ with Answer and Explanation

Question

Share Report Error

Which type of relationship is represented by a foreign key in a relational database?

A. Many-to-many

B. All of the above

C. One-to-one

D. One-to-many

Answer: Option B

Solution (By JKSSB Mock Tests)

Foreign keys can represent various relationships, including one-to-one, one-to-many, and many-to-many (via junction 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 of the following is a valid SQL statement to update a record?

A. UPDATE table_name SET column1 = value1 WHERE condition;

B. CHANGE table_name SET column1 = value1 WHERE condition;

C. MODIFY table_name SET column1 = value1 WHERE condition;

D. UPDATE table_name column1 = value1 WHERE condition;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
The correct syntax for UPDATE is: UPDATE table_name SET column1 = value1 WHERE condition;

This question belongs to: Computer Database Management System (DBMS)

Question #2

Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time?

A. Trigger

B. Index

C. View

D. Cursor

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
A Cursor is a database control structure that allows an application or script to traverse over the records of a query result set row by row.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Who proposed the relational database model based on mathematical relation theory in 1970?

A. Charles Bachman

B. E.F. Codd

C. Dennis Ritchie

D. James Gosling

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Dr. Edgar Frank Codd (E.F. Codd) invented the relational model for database management while working for IBM in 1970.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs