InfyTQ Joins Quiz 3

Question 1

Time: 00:00:00
SELECT * FROM Employees JOIN takes USING (ID);
Which among the following is similar to the given query?

SELECT *FROM Employees INNER JOIN takes USING (ID);

SELECT *FROM Employees INNER JOIN takes USING (ID);

SELECT * FROM Employees OUTER JOIN takes USING (ID);

SELECT * FROM Employees OUTER JOIN takes USING (ID);

SELECT * FROM Employees LEFT OUTER JOIN takes USING (ID);

SELECT * FROM Employees LEFT OUTER JOIN takes USING (ID);

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 2

Time: 00:00:00
How many tables can be included with a join at a time?

One

One

Two

Two

Three

Three

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 3

Time: 00:00:00
Which among the following join types can be included in the join condition?

Cross join

Cross join

Natural join

Natural join

Join with USING clause

Join with USING clause

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 4

Time: 00:00:00
The operation which is not considered a basic operation of relational algebra is

Join

Join

Selection

Selection

Union

Union

Cross product

Cross product

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
The given SQL statement [select * from N, U] is Similar to:

Select * from N natural join U

Select * from N natural join U

Select * from N cross join U

Select * from N cross join U

Select * from N union join U

Select * from N union join U

Select * from N inner join U

Select * from N inner join U

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 cases would be best fit to use a FULL OUTER JOIN?

Both tables have NULL values.

Both tables have NULL values.

You want all unmatched data from one table.

You want all unmatched data from one table.

You want all matched data from both tables.

You want all matched data from both tables.

You want all unmatched data from both tables.

You want all unmatched data from both tables.

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
The Table T1 has 8 tuples and 5 attributes. Table T2 has 0 tuples and 9 attributes. When a CROSS JOIN is achieved between T1 and T2, how many tuples will be available in result ?

28

28

10

10

35

35

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 commands outputs unique rows?

UNION

UNION

UNION ALL

UNION ALL

None of the above

None of the above

Both A and B

Both A and B

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

Accuracy

0%

Related Banners
prepinsta
prepinsta
Prepinsta Prime
Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Explore Prime or check Course List
Check out our instagram

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.

Instagram Whatsapp Telegram Linkedin
Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta
prepinsta
prepinsta
prepinsta
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 Prime Course List

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 Prime Course List

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

See Full list here
Get Prime

Programming

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

See Full list here
Get Prime

Skills

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

See Full list here
Get Prime

Related Pages

Infosys Syllabus

Infosys Aptitude Questions

Infosys Logical Reasoning Questions

Infosys Verbal Ability Questions

Infosys Pseudo Code Questions

Infosys Puzzles Questions

March 26, 2021