10th Grade Functions & Expressions Quizzes, Questions & Answers

Spark curiosity and test your child’s 10th grade Functions And Expressions knowledge with our engaging quizzes! Read more

Functions & Expressions Quizzes By Grade

10th Grade

Find More 10th Grade Subject Quizzes

Computer Science Operating Systems Network Topologies Network Protocols Cybersecurity Network Security Computer Architecture

Top Trending 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: 1453 | 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

Sample Question 3
How to display Number of days from today for a given date(2012-07-31)

Select date(‘2012-07-31’) – curdate() from sysibm/sysdummy1

Select ‘2012-07-31’ – date(curdate()) from sysibm/sysdummy1

Select ‘2012-07-31’ – curdate() from sysibm/sysdummy1

Select date(‘2012-07-31’) – date(curdate()) from sysibm/sysdummy1