SQL Questions and Answers – SQL Inner Join

This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Inner Join”.

1. When there are no matching values between two tables of a database, which of the following join returns zero records?
a) Self join
b) Full join
c) Inner join
d) Right join
View Answer

2. Which of the following keyword can be used along with INNER JOIN in SQL?
a) Of
b) On
c) By
d) Combine
View Answer

3. Where the join condition should be mentioned, if ON keyword is not used in a query?
a) From
b) Select
c) Where
d) Join
View Answer

4. What is the basic syntax for using INNER JOIN?
a)

SELECT column_list
FROM table1
INNER JOIN table2 ON table1.column = table2.column;

b)

SELECT column_list
FROM table1
INNER JOIN table2;

c)

SELECT column_list
FROM table1 ON table1.column = table2.column
INNER JOIN table2;

d)

SELECT column_list
FROM table1
INNER JOIN table2 table1.column = table2.column;

5. Which of the following sets is similar to table1 INNER JOIN table2?
a) Table1 U Table2
b) Table1 – Table2
c) Table1 ∩ Table2
d) Table1 – Table2
View Answer

Sanfoundry Global Education & Learning Series – SQL.

To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.