IncludeHelp_logo
Skip Navigation Links

Home » Aptitude Questions & Answers » DBMS Aptitude Questions

SQL Functions Aptitude Questions and Answers | Set 1

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.
Answer

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.
Answer

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

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

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

SQL Query Syntaxes Aptitude Questions | Set 3
SQL Functions Aptitude Questions | Set 2



Comments and Discussions!

Load comments ↻



Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.