Which of the following is a valid way to join three tables in SQL? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following is a valid way to join three tables in SQL?

A. Both A and B

B. SELECT * FROM table1 JOIN table2 ON condition1 JOIN table3 ON condition2;

C. Neither

D. SELECT * FROM table1, table2, table3 WHERE condition1 AND condition2;

Answer: Option A

Solution (By JKSSB Mock Tests)

Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.

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 the purpose of the COMMIT statement in SQL?

A. To undo all changes made in a transaction

B. To permanently save all changes made in a transaction

C. To save a point within a transaction

D. To start a new transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
COMMIT finalizes a transaction, making all changes permanent in the database.

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

Question #2

Candidate keys that are not selected or designated as the primary key of a table are known as what?

A. Alternate Keys

B. Foreign Keys

C. Composite Keys

D. Super Keys

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.

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

Question #3

What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second table?

A. Inner Join

B. Left Join

C. Cross Join

D. Natural Join

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.

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

Explore All Database Management System (DBMS) MCQs