Skip to main content
Chapter 1 of 7
Practice Quiz

Querying and SQL Functions

CBSE · Class 12 · Informatics Practices

Practice quiz for Querying and SQL Functions — CBSE Class 12 Informatics Practices. MCQs and questions with answers to test your preparation.

111 questions84 flashcards5 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.

1,000+ Class 12 students started this chapter today

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 available

Practice All

Frequently Asked Questions

What are the important topics in Querying and SQL Functions for CBSE Class 12 Informatics Practices?
Querying and SQL Functions covers several key topics that are frequently asked in CBSE Class 12 board exams. Focus on the core concepts listed on this page and practise related questions to build confidence.
How to score full marks in Querying and SQL Functions — CBSE Class 12 Informatics Practices?
Understand the core concepts first, then work through the 111 practice questions available for this chapter. Revise formulas and definitions regularly, and use flashcards for quick recall before the exam.

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 — for free.

Quizzes, flashcards, AI doubt-solver and a step-by-step study plan for CBSE Class 12 Informatics Practices.