Which type of join returns all rows from the left table and matching rows from the right table? MCQ with Answer and Explanation

Question

Share Report Error

Which type of join returns all rows from the left table and matching rows from the right table?

A. RIGHT JOIN

B. LEFT JOIN

C. FULL JOIN

D. INNER JOIN

Answer: Option B

Solution (By JKSSB Mock Tests)

LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table, with matching rows from the right table; NULLs appear when no match.

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

The concept that prevents concurrent transactions from interfering with each other and creating data inconsistencies is known as what?

A. Isolation

B. Consistency

C. Durability

D. Atomicity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Isolation ensures that the execution of concurrent transactions does not interfere with one another, making them appear as if they are executing sequentially.

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

Question #2

Share Report

Which of the following commands is a Data Manipulation Language (DML) statement?

A. RENAME

B. TRUNCATE

C. UPDATE

D. COMMENT

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
UPDATE is a DML statement because it is used to modify existing data values within rows of a database table, rather than modifying the structural schema.

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