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 create a new table

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

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

D. To delete records from a table

Answer: Option C

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

Which SQL statement is used to delete an existing view from the database catalog?

A. DELETE VIEW

B. DROP VIEW

C. CLEAR VIEW

D. REMOVE VIEW

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Because a View is a database structural object, it is removed from the database schema using the DDL command 'DROP VIEW'.

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

Question #2

What is the term for a column in a database table?

A. Tuple

B. Relation

C. Attribute

D. Entity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
An attribute is a column or field in a table, representing a property of the entity.

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

Question #3

Which type of integrity constraint ensures that a foreign key value must either match an existing primary key value in the parent table or be NULL?

A. Key Integrity

B. Referential Integrity

C. Entity Integrity

D. Domain Integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Referential Integrity ensures that relationships between tables remain consistent, requiring a foreign key to point to a valid existing row in the referenced table.

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

Explore All Database Management System (DBMS) MCQs