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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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.

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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.

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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.

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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 retrieve rows from more than one table:

Start

Start

End

End

Join

Join

All of the mentioned

All of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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 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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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

5

5

6

6

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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

Inner Join

Inner Join

All of the mentioned

All of the mentioned

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
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!"]
×

Please login to report

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%

Start Preparing
Detailed performance

Completed

0/0

Accuracy

0%

March 26, 2021