Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side? MCQ with Answer and Explanation

Question

Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side?

A. Natural Join

B. Inner Join

C. Cross Join

D. Full Outer Join

Answer: Option D

Solution (By JKSSB Mock Tests)

A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.

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

Which of the following is a valid SQL statement to add a new column to a table?

A. Both A and C

B. ALTER TABLE table_name ADD column_name datatype;

C. ADD COLUMN TO table_name column_name datatype;

D. ALTER TABLE table_name ADD COLUMN column_name datatype;

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Both 'ADD column_name datatype' and 'ADD COLUMN column_name datatype' are valid syntax in some DBMS, but standard SQL uses 'ADD column_name datatype'. However, many DBMS support both.

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