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

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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.

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

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

Start

Start

End

End

Join

Join

All of the mentioned

All of the mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
Which condition among the following condition is similar in SQL __________?

Join in SQL

Join in SQL

Join condition

Join condition

Join in SQL & Condition

Join in SQL & Condition

None of the mentioned

None of the mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

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

2

2

3

3

4

4

5

5

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

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

Cross join

Cross join

Natural join

Natural join

Join with USING clause

Join with USING clause

All of the mentioned

All of the mentioned

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%