SQL Questions Class 12 CBSE 2026 | Informatics Practices, Computerized Accounting, Commerce
Table of Contents
SQL Questions for Class 12 CBSE (Commerce Stream)
Introduction
SQL (Structured Query Language) is an important topic in Class 12 Informatics Practices and Computerized Accounting. CBSE often asks SQL queries in theory exams and practical viva, so students must practice common questions to score good marks.
This article covers important SQL questions, examples, tables, and exam tips for Class 12 Commerce students.
What is SQL? (Class 12 Simple Definition)
SQL is a language used to store, retrieve, update, and delete data from databases.
It is widely used in banks, companies, schools, and online businesses.
Important SQL Commands for Class 12
| Command | Use |
|---|---|
| SELECT | Retrieve data |
| INSERT | Add new data |
| UPDATE | Modify data |
| DELETE | Remove data |
| CREATE | Create tables |
| DROP | Delete tables |
| ALTER | Modify table structure |
Important SQL Questions for Class 12 CBSE
1. Basic SQL Queries
Q1. Write a query to display all records from STUDENT table.
Q2. Write a query to display only student names.
2. SQL WHERE Clause Questions
Q3. Display students with marks greater than 80.
Q4. Display students from Delhi.
3. SQL ORDER BY Questions
Q5. Display students in ascending order of marks.
Q6. Display students in descending order of age.
4. SQL INSERT, UPDATE, DELETE Questions
Q7. Insert a new student record.
Q8. Update marks of Rahul to 90.
Q9. Delete student record with Roll No 101.
5. Aggregate Function Questions
| Function | Use |
|---|---|
| COUNT() | Count records |
| SUM() | Total |
| AVG() | Average |
| MAX() | Highest value |
| MIN() | Lowest value |
Q10. Find total number of students.
Q11. Find average marks of students.
SQL Questions for Computerized Accounting (Commerce Focus)
Sample Accounting Table: ACCOUNT
| AccNo | Name | Balance | City |
|---|---|---|---|
| 101 | Amit | 5000 | Delhi |
| 102 | Neha | 8000 | Mumbai |
Q12. Display accounts with balance above 6000.
Q13. Update balance of Amit to 7000.
High-Weightage SQL Topics for CBSE Exams
These topics are very important for Class 12 CBSE:
-
SELECT, WHERE, ORDER BY
-
INSERT, UPDATE, DELETE
-
Aggregate functions (COUNT, SUM, AVG)
-
Data types (INT, VARCHAR, DATE)
-
Primary Key and Constraints
-
Simple table creation queries
Sample SQL Viva Questions Class 12
| Question | Answer (Short) |
|---|---|
| What is SQL? | Database query language |
| What is DBMS? | Database Management System |
| Difference between DELETE and DROP? | DELETE removes rows, DROP deletes table |
| What is Primary Key? | Unique identifier |
| What is SELECT command? | Used to fetch data |
Tips to Score Full Marks in SQL (Class 12)
-
Practice writing queries daily
-
Learn SQL syntax by heart
-
Understand table structure questions
-
Practice case-based questions
-
Write queries neatly in exam
-
Revise high-weightage SQL commands
Conclusion
SQL is one of the easiest scoring topics in Class 12 Informatics Practices and Computerized Accounting. By practicing basic queries, commands, and viva questions, students can easily score full marks in CBSE exams. Regular practice and understanding of database concepts will help students in future courses like B.Com, BCA, BBA, and MBA.
Click here to read about Informatics Practices Project Topics Class 12 CBSE 2026 | Entrepreneurship & Computerized Accounting: https://dekhocampus.com/news/informatics-practices-project-topics-class-12-cbse-2026
FAQs (Frequently Asked Questions)
CBSE usually asks 2–5 SQL questions in theory and practical papers.
Practice queries on sample tables and revise syntax daily.
SELECT, WHERE, ORDER BY, INSERT, UPDATE, DELETE, and aggregate functions are most important.
I’m Aditi Sharma, a passionate content writer currently pursuing my MA in English from Magadh University. With a strong command of language and a flair for storytelling, I specialize in crafting engaging articles, blogs, and creative content. My academic background enhances my ability to write well-researched, compelling, and grammatically refined pieces. I aim to create content that informs, inspires, and resonates with diverse audiences.
