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












Comments and Discussions

Ad: Are you a blogger? Join our Blogging forum.





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates


© https://www.includehelp.com some rights reserved.