Q. The left and right joins are also known as __________

View solution

Q. What is joining a table to itself called?

View solution

Q. In which join all the rows from the left table appear in the output irrespective of the content of the other table?

View solution

Q. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________

View solution

Q. The facility that allows nesting one select statement into another is called __________

View solution

Q. Which subquery returns a single value?

View solution

Q. Usage of aggregates in WHERE clause is allowed.

View solution

Q. Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

View solution

Q. The ALL subquery performs which operation?

View solution

Q. Which of these operators perform similar operations like ALL and ANY?

View solution

Q. Which operators test whether a subquery returns any rows?

View solution

Q. An uncorrelated subquery does not contain any reference to the values from the outer query.

View solution

Q. Which subquery cannot be executed by itself as a separate statement?

View solution

Q. Which of these operators does not perform relative-value comparisons?

View solution

Q. To combine multiple retrievals, we write several SELECT statements and put the keyword between them. What is the keyword?

View solution

Q. Which keyword used with UNION does not retain duplicate rows?

View solution

Q. Which keyword used with UNION retains duplicate rows?

View solution

Q. The UNION ALL has a higher precedence than UNION DISTINCT.

View solution

Q. Which clause is used to sort a UNION result as a whole?

View solution

Q. Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword is used for this?

View solution