Skip to main content
Chapter 1 of 7
Practice Quiz

Querying and SQL Functions — Practice Quiz

CBSE · Class 12 · Informatics Practices

Try a 4-question quiz on Querying and SQL Functions for CBSE Class 12 Informatics Practices: tap an answer to check it and see why.

111 questions84 flashcards4 formulas & key relations5 concepts

Interactive on Super Tutor

Studying Querying and SQL Functions? Get the full interactive chapter.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan — built for practice quiz and more.

Free trial, no card needed.

Quick Quiz: Querying and SQL Functions

0/4

Tap an answer to check it instantly. No sign-up needed for these 4.

1

Which SQL function is classified as a single row function and also called a scalar function?

2

What is the output of SELECT POWER(2,3); ?

3

What does ROUND(2912.564,1) return?

4

What does MOD(21,2) return?

111 Questions·
multiple choicemultiple correcttrue falsenumerical

Sample Questions

1multiple correct
1 marks

Which functions are numeric single row functions in SQL?

Show answer

POWER(), ROUND(), MOD()

POWER(), ROUND(), and MOD() are numeric functions because they take numeric input and return numeric output.

2multiple choice
1 marks

Which function converts a string into uppercase?

Show answer

UCASE()

UCASE() converts a string into uppercase. UPPER() also does the same job.

3multiple choice
1 marks

Which function returns the number of characters in a string?

Show answer

LENGTH()

LENGTH() returns the number of characters in the specified string.

4multiple choice
1 marks

Which date and time function returns the current system date and time?

Show answer

NOW()

NOW() returns the current system date and time.

+107 more questions on Querying and SQL Functions (CBSE Class 12 Informatics Practices)

Practise All

Frequently Asked Questions

What are the important topics in Querying and SQL Functions for CBSE Class 12 Informatics Practices?
Key topics in Querying and SQL Functions include SQL Functions, String and Date Functions, Aggregate Functions and GROUP BY, Operations on Relations. Study these first, then practise questions on each for the CBSE Class 12 board exam.
How many practice questions are there for Querying and SQL Functions?
There are 111 questions on Querying and SQL Functions. Try the 4-question sample quiz on this page first; each answer shows an explanation when you tap it.

Sources & Official References

Content is aligned to the official syllabus. Refer to the board website for the latest curriculum.

For serious students

Get the full Querying and SQL Functions chapter — start free.

Quizzes, flashcards, an AI doubt solver and a study plan for CBSE Class 12 Informatics Practices. Free to start, no card needed.