InfyTQ Joins Quiz 1

Question 1

Time: 00:00:00
Which join returns all the rows from Table 2 and only those rows which match with that of Table 1 ?

Inner Join

Inner Join

Full Outer Join

Full Outer Join

Left Join

Left Join

Right Join

Right Join

Question 2

Time: 00:00:00
What is the use of INNER JOIN Clause in SQL ?

To return rows from both the tables that match.

To return rows from both the tables that match.

To return rows from the left table that matches

To return rows from the left table that matches

To return rows from the right table that matches

To return rows from the right table that matches

None of the above.

None of the above.

Question 3

Time: 00:00:00
What is the use of RIGHT JOIN Clause in SQL ?

To return rows from both the tables that match.

To return rows from both the tables that match.

To return rows from the left table that matches

To return rows from the left table that matches

To return all rows from the right table, even if there are no matches in the left table.

To return all rows from the right table, even if there are no matches in the left table.

None of the above.

None of the above.

Question 4

Time: 00:00:00
What is the use of CARTESIAN JOIN in SQL ?

To return rows from both the tables that match.

To return rows from both the tables that match.

To return rows from the left table that matches

To return rows from the left table that matches

To return the Cartesian product of the sets of records from the two or more joined tables.

To return the Cartesian product of the sets of records from the two or more joined tables.

None of the above.

None of the above.

Question 5

Time: 00:00:00
Which among the following query retrieve rows from more than one table:

Start

Start

End

End

Join

Join

All of the mentioned

All of the mentioned

Question 6

Time: 00:00:00
Which of the following is not a type of join in SQL?

Natural Join

Natural Join

Cross Join

Cross Join

cross join

cross join

out join

out join

Question 7

Time: 00:00:00
How many types of join are available in MYSQL ?

2

2

3

3

5

5

6

6

Question 8

Time: 00:00:00
Which among the following are the join types in MYSQL ?:

Cross join

Cross join

Natural join

Natural join

Inner Join

Inner Join

All of the mentioned

All of the mentioned

Question 9

Time: 00:00:00
Which among the following products is returned in a join query which has no join condition mentioned ?

Equi joins

Equi joins

Cartesian

Cartesian

Both Equi joins and Cartesian

Both Equi joins and Cartesian

None of the mentioned

None of the mentioned

Question 10

Time: 00:00:00
Which among the following view contains multi-table in the FROM clause of the SELECT statement:

Join view

Join view

Datatable join view

Datatable join view

Updatable join view

Updatable join view

All of the mentioned

All of the mentioned

null
null
×

Please login to report