CBSE-IP · Database Management

SQL aggregate functions questions with answers

Build accuracy with explanation-led practice, then open a focused search or timed exam drill.

Practise this topic →View CBSE-IP guide
PRACTICE PREVIEW

Five questions to begin your revision

Open each answer only after choosing your own response.

01Hard · ✦ AI-labelled practice

Informatics Practices (065): a Marks column contains 41, 55, 63, 72. What does SELECT SUM(Marks) return?

  1. 231
  2. 232
  3. 230
  4. 233
Check answer and explanation +
A — 231

SUM is applied to the four stated non-NULL values, producing 231.

Source: CBSE Informatics Practices (065) curriculum 2026–27 · original syllabus-aligned practice
02Medium · ✦ AI-labelled practice

Informatics Practices (065): a Marks column contains 42, 56, 64, 73. What does SELECT MAX(Marks) return?

  1. 74
  2. 72
  3. 75
  4. 73
Check answer and explanation +
D — 73

MAX is applied to the four stated non-NULL values, producing 73.

Source: CBSE Informatics Practices (065) curriculum 2026–27 · original syllabus-aligned practice
03Medium · ✦ AI-labelled practice

Informatics Practices (065): a Marks column contains 43, 57, 65, 74. What does SELECT MIN(Marks) return?

  1. 42
  2. 45
  3. 43
  4. 44
Check answer and explanation +
C — 43

MIN is applied to the four stated non-NULL values, producing 43.

Source: CBSE Informatics Practices (065) curriculum 2026–27 · original syllabus-aligned practice
04Medium · ✦ AI-labelled practice

Informatics Practices (065): a Marks column contains 44, 58, 66, 75. What does SELECT COUNT(Marks) return?

  1. 6
  2. 4
  3. 5
  4. 3
Check answer and explanation +
B — 4

COUNT is applied to the four stated non-NULL values, producing 4.

Source: CBSE Informatics Practices (065) curriculum 2026–27 · original syllabus-aligned practice
05Medium · ✦ AI-labelled practice

Informatics Practices (065): a Marks column contains 45, 59, 67, 76. What does SELECT SUM(Marks) return?

  1. 247
  2. 248
  3. 246
  4. 249
Check answer and explanation +
A — 247

SUM is applied to the four stated non-NULL values, producing 247.

Source: CBSE Informatics Practices (065) curriculum 2026–27 · original syllabus-aligned practice
✓

Know what you are practisingVerified and AI-generated records remain labelled separately. Previous-exam claims appear only when the source record supports them.

See every SQL aggregate functions question →
CONTINUE LEARNING

Related CBSE-IP topics