Join-2

A condition given in a Join query is referred to as______

• Join in SQL

• Join condition

• Join in SQL & condition

• None of these

Which of the following is not a join type?

• Empty join

• Natural join

• Equi join

• Right join

Which product is returned in a join query having no join condition?

• Equi join

• Cartesian

• Both Equi joins and Cartesian

• Natural

The Cartesian product is also called _________ join

• Equi join

• Natural

• Unrestricted join

• Restricted join

In which type of join, the join condition contains an equality operator?

• Equi join

• Natural

• Left join

• Right join

In which type of join, duplicate columns are there?

• Equi join

• Natural

• Left join

• Right join

In which type of join, no duplicate columns are there?

• Equi join

• Natural

• Left join

• Right join

With SELECT statement used for joins, the USING subclause produces _________ join

• Equi join

• Natural

• Left join

• Right join

With SELECT statement used for joins, the ON subclause produces _______ join

• Equi join

• Natural

• Left join

• Right join

What is the correct statement for describing the UNION operation?

• It combines the rows of any two different queries

• It combines the unique rows of two different queries which have the same set of attributes in the select clause

• It combines the rows of two different queries which have the same condition in the where clause

• It gives the Cartesian product of the results of any two queries