Functions & Expressions Quizzes, Questions & Answers

Select Your Grade

All Grades

Top Trending Functions & Expressions Quizzes

This SQL Date Functions Basics Quiz evaluates your understanding of essential date manipulation in SQL. You'll test your knowledge of common date functions like DATEADD, DATEDIFF, GETDATE, and DATE_FORMAT, along with practical...

Questions: 15 | Attempts: 19 | Last updated: May 2, 2026

Sample Question 1
What does the GETDATE() function return in SQL Server?

The current system date and time

The date from a specific table column

A formatted date string

The number of days since 1900

Sample Question 2
Which function calculates the difference between two dates in SQL?

DATE_SUB()

DATEDIFF()

DATE_CALC()

SUBTRACT_DATES()

SQL Quiz 2: Functions

Functions(Char,Concat,Substr etc) Date Functions Numeric Functions(Sum,Avg etc) Usage of group by and Having with aggregate functions Use of IFNull and Coalease functions Case expression

Questions: 10 | Attempts: 1515 | Last updated: Mar 21, 2025

Sample Question 1
Which one of the following queries will select the Number of Unique Departments from the Department Table below Department Number Employee Number 11 248525 11 267712 12 112456 11 234567 13 661231

Select count(*) from Department_Table

Select count(distinct DepartmentNumber) from Department_Table having distinct DepartmentNumber

Select count(distinct DepartmentNumber) from Department_Table

Select distinct departmentNumber from Department_Table

Sample Question 2
The output from the function dec(-99.9999) would be

-99.9999

-99

99.9999

99

Recent Functions & Expressions Quizzes

Difference Between Scalar and Aggregate Functions Quiz

This quiz evaluates your understanding of the difference between scalar and aggregate functions in SQL and database systems. Scalar functions operate on individual rows and return one value per input row, while aggregate...

Questions: 15 | Attempts: 10 | Last updated: May 2, 2026

Sample Question
What is the primary difference between scalar and aggregate functions?

Scalar functions work on one row; aggregate functions work on multiple rows

Scalar functions return strings; aggregate functions return numbers

Scalar functions are slower than aggregate functions

Scalar functions require a WHERE clause; aggregate functions do not

SQL Conditional Expressions Quiz

Test your understanding of SQL conditional expressions and how they control data retrieval and manipulation. This SQL Conditional Expressions Quiz covers IF, CASE, BETWEEN, IN, and comparison operators at an intermediate level....

Questions: 15 | Attempts: 11 | Last updated: May 2, 2026

Sample Question
Which SQL keyword is used to test if a value exists within a specified range?

BETWEEN

IN

LIKE

EXISTS

SQL String Functions Basics Quiz

This SQL String Functions Basics Quiz evaluates your understanding of essential string manipulation functions in SQL. You'll test your knowledge of functions like UPPER, LOWER, SUBSTRING, LENGTH, and CONCAT that are fundamental...

Questions: 16 | Attempts: 15 | Last updated: May 2, 2026

Sample Question
What does the UPPER() function do in SQL?

Converts text to uppercase letters

Removes spaces from text

Counts characters in text

Reverses the order of text