The JOIN operation in SQL is used to: MCQ with Answer and Explanation

Question Report Error

The JOIN operation in SQL is used to:

A. Sort data

B. Delete rows

C. Create a new database

D. Combine rows from two or more tables

Answer: Option D

Solution (By JKExamLibrary)

JOIN combines data from multiple tables based on related columns.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error

Which of the following is not an aggregate function in SQL?

A. DESC

B. AVG

C. MAX

D. SUM

View Answer & Solution Discuss

Correct Answer: Option A

Explanation:
DESC is a keyword for sorting order, not an aggregate function.

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

Question #2 Report Error

Which of the following is a valid SQL string function?

A. CONCAT

B. REPLACE

C. All of the above

D. SUBSTRING

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
SUBSTRING, CONCAT, and REPLACE are common string functions in SQL.

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

Question #3 Report Error

What is a database cursor?

A. A user account

B. A control structure that enables traversal over rows in a result set

C. A type of index

D. A backup file

View Answer & Solution Discuss

Correct Answer: Option B

Explanation:
A cursor allows row-by-row processing of query results, often used in procedural extensions of SQL.

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

Explore All Database Management System (DBMS) MCQs