Loading...

SQL Server

Aggregate functions are functions that take a ___________ as input and return a single value.
  1. Collection of values
  2. Single value
  3. Double value
  4. All of the mentioned
SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.
  1. Group by
  2. With
  3. Where
  4. Having
The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
  1. In
  2. Lateral
  3. Having
  4. With
Which of the following is not a aggregate function ?
  1. Avg
  2. Sum
  3. With
  4. Min
If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.
  1. Distinct
  2. Count
  3. Avg
  4. Primary key
All aggregate functions except __________ ignore null values in their input collection.
  1. Count(attribute)
  2. Count(*)
  3. Avg
  4. Sum
A Boolean data type that can take values true, false, and ____________
  1. 1
  2. 0
  3. Null
  4. Unknown
The phrase “greater than at least one” is represented in SQL by ___________
  1. < all
  2. < some
  3. > all
  4. > some
We can test for the nonexistence of tuples in a subquery by using the __________ construct.
  1. Not exist
  2. Not exists
  3. Exists
  4. Exist
Which of the following is a set function ?
  1. RANK
  2. NTILE
  3. Window
  4. All of the mentioned