What is the purpose of the SQL 'JOIN' clause? MCQ with Answer and Explanation

Question

Share Report Error

What is the purpose of the SQL 'JOIN' clause?

A. To delete records from a table

B. To combine rows from two or more tables based on a related column

C. To create a new table

D. To combine columns from multiple tables into a single table

Answer: Option B

Solution (By JKSSB Mock Tests)

JOIN is used to combine rows from different tables based on a common column, allowing querying across related 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

A view in DBMS is:

A. A backup of the database

B. An index on the table

C. A virtual table based on the result of a query

D. A physical copy of the table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A view is a virtual table derived from one or more base tables.

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

Question #2

Which SQL set operator combines the output of two queries but preserves all duplicate rows without filtering them?

A. MINUS

B. UNION

C. INTERSECT

D. UNION ALL

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
UNION ALL appends the results of multiple SELECT queries together without performing any deduplication, making it faster than UNION.

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

Question #3

Data that has been processed, organized, structured, or presented in a given context to make it useful is known as what?

A. Information

B. Raw facts

C. Field

D. Database

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Information is data that has been processed, structured, or organized in a meaningful way to provide context and utility to the user.

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

Explore All Database Management System (DBMS) MCQs