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












Was this page helpful? YES NO

Are you a blogger? Join our Blogging forum.



Comments and Discussions


We are using Google to publish ads on our website; Google has its own privacy policies. They may save log, cookies on your system. Google may also collect information of your system like IP address, region, city, country. For more details please go through the Google’s privacy policy.