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.

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

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

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

Please login to submit your explanation

Start

Question 4

Time: 00:00:00
Which of the following operations is not considered a simple operation of SQL ?

Join

Join

Selection

Selection

Union

Union

Cross product

Cross product

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

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.

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

0

0

35

35

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

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%