Pretest

What is a subquery?

• A subquery is a select-from-where expression that is nested within another query

• A subquery is any query that is nested within another query

• A subquery is a relation that is externally specified which can be used to handle data in queries

• A subquery is a condition that excludes all the invalid tuples from the database

A Sub query is an SQL expression that is placed ____ another SQL statement.

• 1. Before

• 1. After

• 1. Inside

• 1. Outside

With which of the following statement(s) can the SQL sub queries be used?

• SELECT

• 1. UPDATE

• 1. INSERT

• 2. All of the above

Whenever a sub query appears in SQL, it is enclosed within ____ and placed to the ____ of the SQL operators.

• 1. Brackets, Left

• 1. Brackets, Right

• 1. Parenthesis, Left

• 1. Parenthesis, Right

Which of the following clause cannot be used in SQL sub queries?

• GROUP BY

• 1. ORDER BY

• 1. DELETE

• 1. FROM

In order to prevent multiple records from being returned by the sub query, ____ must be used before the sub query.

• 1. Many Value Operators

• 1. Multiple Value Operators

• 1. Single Value Operator

• 1. Unique Value Operator

The ____ operator cannot be used with the sub query, but within it.

• 1. IN

• INTO

• BETWEEN

• JOIN

____ value is returned by the SQL Aggregate functions?

• 1. Single

• TWICE

• NULL

• Infinite

What does COUNT() function returns?

• 1. Average value

• 1. Largest value

• 1. Smallest value

• 1. Number of rows

What is the full form of CTE in SQL?

• Character Table Expressions

• 1. Character Table Evaluator

• 1. Common Table Evaluator

• 1. Common Table Expressions