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

ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT


Comments and Discussions!




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

ABOUT SECTION
» About us
» Contact us
» Feedback
» Privacy policy

STUDENT'S SECTION
» Internship
» Certificates
» Content Writers of the Month

SUBSCRIBE
» Facebook
» LinkedIn
» Subscribe through email

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