Nested Subqueries Multiple Choice Questions (MCQ) PDF Download

MCQ 1: The with clause, was introduced in

1. SQL:1998
2. SQL:1999
3. SQL:2000
4. SQL:2001

MCQ 2: The exist construct returns true as a value, if the argument subquery is

1. Empty
2. Not empty
3. Exist
4. Not exist

MCQ 3: A subquery that uses a correlation name from an outer query is called a

1. Derived subquery
2. Induced Subquery
3. Deduced subquery
4. Correlated subquery

MCQ 4: The SQL comparison = all is not the same to the operator

1. In
2. Like
3. As
4. All of the above

MCQ 5: Scalar subqueries can occur in

1. Select clause
2. From clause
3. Where clause
4. All of the Above