# 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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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