Informatics Practices
With SELECT statement used for joins, the ON subclause produces …………… join.
- Equi-join
- Natural
- Left Join
- Right Join
Related Questions
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
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
What is the correct statement for describing the INTERSECT operation?
- It returns the common values from the results of any two different queries
- It returns the common rows of two different queries which have the same set of attributes in the select clause
- It returns the common rows of two different queries which have the same condition in the where clause
- None of these