SQL Functions Aptitude Questions and Answers.

This section contains Aptitude Questions and Answers on SQL Functions - Aggregate and Scalar functions.

List of SQL Functions - Aggregate and Scalar Aptitude Questions

1) What are the SQL Aggregate Functions?
  1. Functions that return single value based on column values.
  2. Functions that return single value based on input values.
  3. Both 1 and 2.
  4. None of these.

2) What are the SQL Scalar Functions?
  1. Functions that return single value based on column values.
  2. Functions that return single value based on input values.
  3. Both 1 and 2.
  4. None of these.

3) Which is not an Aggregate Function?
  1. COUNT()
  2. MAX()
  3. MIN()
  4. ROUND()

4) Which is not a Scalar Function?
  1. UCASE()
  2. LCASE()
  3. AVG()
  4. ROUND()

5) Is SELECT NOW(); statement is correct to get system date and time?
  1. YES
  2. NO