SQL Functions - Math, Text & Date: Class XII Practice Worksheets (With Answers)

SQL Functions – Math, Text & Date: Class XII Practice Worksheets (With Answers)

Master Class XII SQL math, text, and date functions (POWER, ROUND, SUBSTRING, NOW, etc.) with 3 sets of interactive worksheets and answer keys.

Worksheet Set 1: SQL Math Functions (`POWER`, `ROUND`, `MOD`)

COMPUTER SCIENCE / INFORMATICS PRACTICES

Worksheet Set 1: SQL Math Functions (POWER, ROUND, MOD)

Name: ________________________ Roll No: _________ Date: ____________

Q1. What will be the output of the query: SELECT POWER(3, 4);?

Q2. What will be the output of the query: SELECT ROUND(156.782, 1);?

Q3. What will be the output of the query: SELECT MOD(17, 5);?

Q4. Write a query to find the cube of 5 using a math function.

Q5. What will be the output of the query: SELECT ROUND(45.923, -1);?

Q6. What will be the output of the query: SELECT MOD(25, 4);?

Q7. Consider a table Product with column Price. Write a query to display prices rounded to 0 decimal places.

Q8. What will be the output of the query: SELECT POWER(2, 0);?

Q9. What will be the output of the query: SELECT ROUND(123.456); (with default decimal places)?

Q10. Explain the difference between integer division / modulo operator and the MOD() function in SQL.

Answer Key – Set 1

Ans 1: 81 (since $3^4 = 81$)

Ans 2: 156.8

Ans 3: 2 (remainder of 17 divided by 5)

Ans 4:

SELECT POWER(5, 3);

Ans 5: 50 (rounds to the nearest tens place)

Ans 6: 1 (remainder of 25 divided by 4)

Ans 7:

SELECT ROUND(Price, 0) FROM Product;

Ans 8: 1 (any number raised to the power of 0 is 1)

Ans 9: 123 (default decimal places is 0)

Ans 10: Both return the remainder of a division operation, but MOD(x, y) is a built-in function accepting two arguments, whereas some SQL dialects use the % operator.

Worksheet Set 2: SQL Text / String Functions (10 Questions)

Focus: UCASE/UPPER, LCASE/LOWER, MID/SUBSTRING/SUBSTR, LENGTH, LEFT, RIGHT, INSTR, LTRIM, RTRIM, TRIM.

COMPUTER SCIENCE / INFORMATICS PRACTICES

Worksheet Set 2: SQL Text / String Functions

Name: ________________________ Roll No: _________ Date: ____________

Q1. What will be the output of the query: SELECT UPPER('informatics');?

Q2. What will be the output of the query: SELECT LENGTH('Computer Science');?

Q3. What will be the output of the query: SELECT SUBSTRING('Database', 3, 4);?

Q4. What will be the output of the query: SELECT LEFT('SQL Programming', 3);?

Q5. What will be the output of the query: SELECT RIGHT('Database', 4);?

Q6. What will be the output of the query: SELECT INSTR('Information', 'or');?

Q7. What is the difference between LTRIM() and RTRIM() functions?

Q8. What will be the output of the query: SELECT LOWER('CBSE CLASS 12');?

Q9. Write a query to remove all leading and trailing spaces from a column named Username in the Users table.

Q10. What will be the output of the query: SELECT MID('Structured', 2, 3);?

Answer Key – Set 2

Ans 1: INFORMATICS

Ans 2: 16 (counts all characters including the space)

Ans 3: taba (starts at position 3 and extracts 4 characters)

Ans 4: SQL (extracts 3 characters from the left)

Ans 5: base (extracts 4 characters from the right)

Ans 6: 6 (returns the 1-based index position where ‘or’ first appears)

Ans 7: LTRIM() removes spaces from the left (beginning) of a string, whereas RTRIM() removes spaces from the right (end) of a string.

Ans 8: cbse class 12

Ans 9:

SELECT TRIM(Username) FROM Users;

Ans 10: tru (starts at position 2 ‘t’ and extracts 3 characters)

Worksheet Set 3: SQL Date Functions (`NOW`, `DATE`, `MONTH`, `MONTHNAME`, `YEAR`, `DAY`, `DAYNAME`)

COMPUTER SCIENCE / INFORMATICS PRACTICES

Worksheet Set 3: SQL Date Functions

Name: ________________________ Roll No: _________ Date: ____________

Q1. What does the NOW() function return in SQL?

Q2. What will be the output of the query: SELECT YEAR('2026-10-15');?

Q3. What will be the output of the query: SELECT MONTH('2026-10-15');?

Q4. What will be the output of the query: SELECT MONTHNAME('2026-05-12');?

Q5. What will be the output of the query: SELECT DAY('2026-11-20');?

Q6. What is the difference between NOW() and DATE() functions?

Q7. Consider a table Orders with column OrderDate. Write a query to extract only the year part from OrderDate.

Q8. What will be the output of the query: SELECT DAYNAME('2026-06-05'); (assuming June 5, 2026 is a Friday)?

Q9. Write a query to extract the date portion from a datetime value stored in a column named LogTimestamp.

Q10. Write a query to find all employees from an Employee table who joined in the month of December (using the MONTH() function).

Answer Key – Set 3

Ans 1: The NOW() function returns the current date and time (timestamp).

Ans 2: 2026

Ans 3: 10

Ans 4: May

Ans 5: 20

Ans 6: NOW() returns both current date and time, whereas DATE() extracts only the date part from a given datetime expression.

Ans 7:

SELECT YEAR(OrderDate) FROM Orders;

Ans 8: Friday

Ans 9:

SELECT DATE(LogTimestamp) FROM Logs;

Ans 10:

SELECT * FROM Employee WHERE MONTH(JoiningDate) = 12;

By Anjeev Kr Singh – Computer Science Educator
Published on : September 19, 2026 | Updated on : September 19, 2026

About the Author

Anjeev Kr Singh

Computer Science Educator, Author, and HOD. Guiding CBSE students in CS, IP, IT, WA & AI via mycstutorial.in. Creator of Question Bank for Class 10 & 12 students.

SQL Functions – Math, Text & Date: Class XII Practice Worksheets (With Answers)