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 retrieve 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 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

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

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

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/10

Accuracy

0%

Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Follow us on our Media Handles, we post out OffCampus drives on our Instagram, Telegram, Discord, Whatsdapp etc.

Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get PrepInsta Prime Subscription

Get access to all the courses that PrepInsta offers, check the out below -

Companies

TCS, Cognizant, Delloite, Infosys, Wipro, CoCubes, KPMG, Amazone, ZS Associates, Accenture, Congnizant & other 50+ companies

Programming

Data Structures, Top 500 Codes, C, C++, Java Python & other 10+ subjects

Skills

Full Stack Web Development, Data Science, Machine Learning, AWS Cloud, & other 10+ skills and 20+ projects