Skip to main content
Chapter 1 of 7
Important Questions

Querying and SQL Functions — Important Questions

CBSE · Class 12 · Informatics Practices

111 important questions from Querying and SQL Functions for CBSE Class 12 Informatics Practices, with answers. Written for the board exams 2027.

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 important questions and more.

Free trial, no card needed.

111 Questions·
multiple choicemultiple correcttrue falsenumerical

Important Questions from Querying and SQL Functions

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 important questions are there in Querying and SQL Functions?
Super Tutor has 111 practice questions for Querying and SQL Functions, including multiple choice, multiple correct, true false, numerical questions. A sample with answers is on this page.

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.