CBSE · SQL · 7 min read
SQL for CBSE Class 12: Where the Marks Actually Are
SQL carries 20 of the 70 theory marks in Computer Science (083) and 25 of 70 in Informatics Practices (065). Most of those marks come from a small, repeating set of clauses: SELECT with WHERE, ORDER BY, aggregate functions, GROUP BY with HAVING, and joins. Students lose marks on clause order far more often than on ideas.
SQL is the most predictable block in the paper
Programming questions vary. SQL questions do not, because the syllabus fixes a small set of clauses and the board keeps testing them. That makes SQL the highest return per hour of revision in either subject.
How much it is worth
- Computer Science (083): Database Management, 20 of 70 theory marks.
- Informatics Practices (065): Database Query using SQL, 25 of 70 theory marks.
- Plus SQL appears again in the practical, where a set of queries is standard.
The clauses that repeat
Learn these until they are automatic and most of the block is secure:
SELECT ... FROM ... WHEREwith AND, OR, NOT, BETWEEN, IN, LIKE and IS NULLORDER BYascending and descending- Aggregate functions: COUNT, SUM, AVG, MIN, MAX, and the difference between COUNT(*) and COUNT(column)
GROUP BYwithHAVING- Joins across two tables, including the Cartesian product and equi-join
- DDL and DML basics: CREATE, ALTER, INSERT, UPDATE, DELETE
Where marks are actually lost
Almost never on the concept. Nearly always on one of these:
- Clause order. WHERE before GROUP BY, HAVING after it. Writing them out of order loses the mark even when the logic is right.
- WHERE versus HAVING. WHERE filters rows, HAVING filters groups. Examiners test exactly this distinction.
- COUNT(*) versus COUNT(column). One counts rows, the other skips NULLs.
- Output questions. Being asked what a query prints, not to write one, and guessing instead of tracing.
How to practise so it becomes routine
- Keep one SQL file that grows all year, and revise queries rather than definitions.
- For every query you write, also predict its output before running it.
- Do previous years' SQL questions in a single sitting; the repetition becomes obvious fast.
- Practise on a real table with NULLs in it, since that is where COUNT and aggregate questions get their marks.
{ }
Frequently asked questions
How many marks is SQL in CBSE Class 12?+
In Computer Science (083) database management carries 20 of the 70 theory marks. In Informatics Practices (065) database query using SQL carries 25 of 70.
What is the difference between WHERE and HAVING?+
WHERE filters individual rows before grouping. HAVING filters groups after GROUP BY has been applied. Questions testing this distinction appear regularly.
Do I need to memorise SQL syntax?+
You need it automatic rather than memorised. Because the examined clause set is small and repeats, regular writing makes recall reliable in a way memorising does not.
Is SQL asked in the practical exam too?+
Yes. A set of SQL queries is a standard part of the practical component in both Computer Science and Informatics Practices.