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

Question

Share Report Error

The JOIN operation in SQL is used to:

A. Delete rows

B. Sort data

C. Create a new database

D. Combine rows from two or more tables

Answer: Option D

Solution (By JKSSB Mock Tests)

JOIN combines data from multiple tables based on related columns.

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

Share Report

In an Entity-Relationship (ER) diagram, what geometric shape is used to represent an entity type?

A. Rectangle

B. Triangle

C. Ellipse

D. Diamond

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
In standard ER modeling notation, rectangles are used to represent entity sets or entity types.

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

Question #2

Share Report

What is a database transaction?

A. A backup copy of the database

B. A logical unit of work that consists of one or more SQL statements

C. A query that reads data

D. A database schema

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A transaction is a sequence of operations performed as a single logical unit, ensuring ACID properties.

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

Question #3

Share Report

What is the purpose of the SQL 'DEFAULT' constraint?

A. To define a primary key

B. To set a foreign key

C. To provide a default value for a column when no value is supplied

D. To enforce uniqueness

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
DEFAULT assigns a default value to a column if an INSERT statement does not specify a value.

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

Explore All Database Management System (DBMS) MCQs