What is the difference between an inner join and an outer join? MCQ with Answer and Explanation

Question

Share Report Error

What is the difference between an inner join and an outer join?

A. They are the same

B. Outer join is used for more than two tables

C. Inner join returns only matching rows; outer join returns matching plus non-matching rows from one or both tables

D. Inner join returns all rows; outer join returns matching only

Answer: Option C

Solution (By JKSSB Mock Tests)

Inner join returns rows where the join condition matches. Outer join (left, right, full) returns unmatched rows as well with NULLs.

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

What is a subquery in SQL?

A. A query nested inside another query

B. A query that returns multiple results

C. A query that is used to create a table

D. A query that is always correlated

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A subquery is a SELECT statement nested within another SQL statement (e.g., SELECT, INSERT, UPDATE, DELETE).

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

Question #2

Which of the following terms refers to the duplication of data across multiple locations in a non-DBMS file system?

A. Data Isolation

B. Data Redundancy

C. Data Security

D. Data Integrity

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Data Redundancy refers to the unnecessary duplication of the exact same data in multiple files or locations, which wastes storage and can cause inconsistencies.

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

Question #3

What is the purpose of the SQL 'IN' operator?

A. To check if a value is null

B. To check if a value is between two values

C. To join tables

D. To check if a value matches any value in a list

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
IN is used to test membership in a set of values.

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

Explore All Database Management System (DBMS) MCQs