12th Grade Functions & Expressions Quizzes, Questions & Answers

12th Grade

Top Trending Functions & Expressions Quizzes

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 1
Which SQL keyword is used to test if a value exists within a specified range?

BETWEEN

IN

LIKE

EXISTS

Sample Question 2
What does the CASE statement in SQL return when no WHEN condition is met?

NULL

0

The ELSE value

An error

Sample Question 3
In SQL, which operator is used to combine multiple conditions where ALL must be true?

OR

AND

NOT

XOR

Recent Functions & Expressions Quizzes

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: 1501 | Last updated: Mar 21, 2025

Sample Question
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