📝 Unit 2 Board Questions + Practice
2026-27 syllabus में Unit 2 के 25 marks हैं। Part A में 24 नए practice questions answers के साथ हैं (पहले ख़ुद हल करें, फिर "Answer देखें" दबाएँ)। Part B में पिछले CBSE board papers (2022, 2023, 2024, 2025, 2026) के Unit 2 के सभी 57 questions original रूप में हैं – tables, code और internal choice सहित, हर एक के answer के साथ। Questions board paper की तरह English में हैं।
1) पहले unit के lessons पढ़ें। 2) Part A notebook में हल करें, फिर answers मिलाएँ। 3) Part B को paper-wise timer लगाकर हल करें – लगभग 1.5 minute प्रति mark। 4) गलत हुए questions पर निशान लगाएँ और उस lesson को दोबारा पढ़ें।
Part A – Practice questions (answers के साथ)
Predict: SELECT POWER(3, MOD(14,4));
Answer देखें
9.
Predict: SELECT ROUND(482.376,2);
Answer देखें
482.38.
Predict: SELECT INSTR('SCHOOL DATA','XYZ');
Answer देखें
0.
A table contains 5 rows and 2 NULL entries in Email. State COUNT(*) and COUNT(Email).
Answer देखें
5 and 3.
Which clause filters grouped results using an aggregate condition: WHERE, HAVING, ORDER BY or DISTINCT?
Answer देखें
HAVING.
True or false: UPDATE changes the structure of a table by adding a column.
Answer देखें
False. ALTER TABLE adds a column; UPDATE changes stored row values.
Predict both outputs: (i) SELECT SUBSTRING('DIGITAL INDIA',9,5); (ii) SELECT UPPER(RIGHT('Learning',3));
Answer देखें
INDIA; ING.
Write queries to display (i) the month name of '2027-02-15', (ii) only the date part of '2027-02-15 09:30:00'.
Answer देखें
SELECT MONTHNAME('2027-02-15');
SELECT DATE('2027-02-15 09:30:00');Explain COUNT(column) versus COUNT(*) with an example that contains NULL.
Answer देखें
COUNT(column) counts non-NULL values; COUNT(*) counts all rows. For [10,NULL,20], counts are 2 and 3.
Correct this query to display each house having more than two students.
SELECT House, COUNT(*) FROM STUDENT WHERE COUNT(*) > 2 GROUP BY House;
Answer देखें
SELECT House, COUNT(*) FROM STUDENT GROUP BY House HAVING COUNT(*) > 2;
Define domain and tuple in the relational model.
Answer देखें
Domain: allowed set of values for an attribute. Tuple: a row/record in a relation.
For STUDENT(SID, Name, Marks), write commands to (i) increase all Marks by 2, (ii) add City VARCHAR(25).
Answer देखें
UPDATE STUDENT SET Marks=Marks+2; ALTER TABLE STUDENT ADD City VARCHAR(25);
| SID | Name | House | Marks | City | DOB |
|---|---|---|---|---|---|
| 1 | Asha | Red | 84 | Khurja | 2009-05-12 |
| 2 | Bilal | Blue | 76 | Aligarh | 2009-08-20 |
| 3 | Charu | Red | 92 | Khurja | 2008-12-01 |
| 4 | Dev | Blue | NULL | Delhi | 2009-05-03 |
| 5 | Esha | Green | 68 | Aligarh | 2008-11-15 |
| 6 | Farhan | Red | 80 | Khurja | 2009-08-14 |
SID is a unique, non-NULL student identifier. Each sub-part is independent and uses this original data.
Write queries to display (i) Name and Marks for marks >= 80, (ii) all rows in descending Marks order, (iii) names with unknown marks.
Answer देखें
SELECT Name,Marks FROM STUDENT WHERE Marks>=80; SELECT * FROM STUDENT ORDER BY Marks DESC; SELECT Name FROM STUDENT WHERE Marks IS NULL;
Write queries for (i) house-wise number of students, (ii) average Marks of Red house, (iii) houses with more than two students.
Answer देखें
SELECT House,COUNT(*) FROM STUDENT GROUP BY House; SELECT AVG(Marks) FROM STUDENT WHERE House='Red'; SELECT House,COUNT(*) FROM STUDENT GROUP BY House HAVING COUNT(*)>2;
Predict: (i) SELECT COUNT(*),COUNT(Marks) FROM STUDENT; (ii) SELECT MAX(Marks),MIN(Marks) FROM STUDENT; (iii) SELECT SUM(Marks) FROM STUDENT WHERE House='Red';
Answer देखें
(6,5); (92,68); 256.
Write queries for (i) names of students born in August, (ii) names in lower case, (iii) first three letters of names of Khurja students.
Answer देखें
SELECT Name FROM STUDENT WHERE MONTH(DOB)=8; SELECT LOWER(Name) FROM STUDENT; SELECT LEFT(Name,3) FROM STUDENT WHERE City='Khurja';
Write queries to (i) insert (7, Gauri, Green, 88, Delhi, 2009-06-11), (ii) change SID 2 city to Khurja, (iii) delete SID 4, (iv) display Name and birth year for all students. Treat each subpart independently.
Answer देखें
INSERT INTO STUDENT VALUES(7,'Gauri','Green',88,'Delhi','2009-06-11'); UPDATE STUDENT SET City='Khurja' WHERE SID=2; DELETE FROM STUDENT WHERE SID=4; SELECT Name,YEAR(DOB) FROM STUDENT;
Write queries to display (i) each city and average marks, (ii) houses with average marks above 80, (iii) names with marks BETWEEN 75 AND 85, (iv) distinct cities alphabetically.
Answer देखें
SELECT City,AVG(Marks) FROM STUDENT GROUP BY City; SELECT House,AVG(Marks) FROM STUDENT GROUP BY House HAVING AVG(Marks)>80; SELECT Name FROM STUDENT WHERE Marks BETWEEN 75 AND 85; SELECT DISTINCT City FROM STUDENT ORDER BY City;
| CID | CName | Fee |
|---|---|---|
| C1 | Python | 4000 |
| C2 | SQL | 3500 |
| C3 | Networks | 3000 |
| EID | Learner | CID |
|---|---|---|
| 101 | Aman | C1 |
| 102 | Bhavna | C2 |
| 103 | Chirag | C1 |
| 104 | Diya | C3 |
Write equi-join queries to display (i) each learner with course name, (ii) learner and fee where fee >= 3500, (iii) total enrolled learners for each course name.
Answer देखें
SELECT E.Learner,C.CName FROM ENROL E,COURSE C WHERE E.CID=C.CID; SELECT E.Learner,C.Fee FROM ENROL E,COURSE C WHERE E.CID=C.CID AND C.Fee>=3500; SELECT C.CName,COUNT(*) FROM ENROL E,COURSE C WHERE E.CID=C.CID GROUP BY C.CName;
Predict the result: SELECT C.CName,COUNT(*) FROM COURSE C,ENROL E WHERE C.CID=E.CID GROUP BY C.CName ORDER BY C.CName;
Answer देखें
Networks 1; Python 2; SQL 1.
Create BOOK with BookID INT PRIMARY KEY, Title VARCHAR(40), Price DECIMAL(8,2), PurchaseDate DATE. Write another query to increase Price by 50 only when Price < 500.
Answer देखें
CREATE TABLE BOOK(BookID INT PRIMARY KEY, Title VARCHAR(40), Price DECIMAL(8,2), PurchaseDate DATE); UPDATE BOOK SET Price=Price+50 WHERE Price<500;
Write five queries to display (i) the square of 19, (ii) remainder of 47 divided by 6, (iii) length of 'Data Science' including the space, (iv) ' Khurja ' with both outer spaces removed, (v) current date and time.
Answer देखें
SELECT POWER(19,2);
SELECT MOD(47,6);
SELECT LENGTH('Data Science');
SELECT TRIM(' Khurja ');
SELECT NOW();For PAYMENT(PID, Customer, Amount, PayDate), write independent queries to display (i) highest Amount, (ii) lowest Amount, (iii) Customer without trailing spaces, (iv) Customer without leading spaces, (v) day name and day number of each PayDate.
Answer देखें
SELECT MAX(Amount) FROM PAYMENT; SELECT MIN(Amount) FROM PAYMENT; SELECT RTRIM(Customer) FROM PAYMENT; SELECT LTRIM(Customer) FROM PAYMENT; SELECT DAYNAME(PayDate),DAY(PayDate) FROM PAYMENT;
Explain primary, candidate and alternate keys using BOOK(BookID, ISBN, Title). Assume every BookID and ISBN is unique and non-NULL; Title may repeat. Select BookID as the primary key. Give a command to remove the BOOK table.
Answer देखें
Candidate keys: BookID and ISBN. Primary key: BookID. Alternate key: ISBN. Title is not a key under these assumptions. DROP TABLE BOOK;
Part B – पिछले वर्षों के board questions (Unit 2)
CBSE Board Paper 2026 – 12 questions

Answer देखें
False – an aggregate function returns a single value for the whole column (or one value per group).

Answer देखें
(C) 9 – the space is also counted.

Answer देखें
(D) Data Manipulation Language

Answer देखें
True

Answer देखें
(C) 15.68

Answer देखें
(A) – both are true and the reason correctly explains the assertion.

Answer देखें
a. Domain: the set of all allowed values for an attribute (column), e.g. Gender can be only M or F. b. Tuple: a single row (record) of a relation (table).

Answer देखें
SELECT MONTH('2026-01-01'); -- (I) 1
SELECT YEAR('2026-01-01'); -- (II) 2026
Answer देखें
CREATE TABLE PRODUCTS (
PID INT PRIMARY KEY,
PName VARCHAR(30),
PCat CHAR(15),
Price DECIMAL(10, 2)
); -- (i)
UPDATE PRODUCTS SET Price = Price + 100 WHERE PCat = 'Grocery'; -- (ii)

Answer देखें
(a)
DELETE FROM SUBJECT WHERE TID = 4; -- (I) SELECT TName FROM TEACHER WHERE Experience > 5 AND City = 'Nagpur'; -- (II) SELECT S.SubName, T.TName FROM SUBJECT S, TEACHER T WHERE S.TID = T.TID; -- (III)
OR (b)
(I) BookId and Title – in the given data both have unique, non-NULL values in every row, so either can identify a book. (BookId is the better choice for primary key because two different books may have the same title in future.) Genre repeats and Price has NULL, so they are not candidate keys.
INSERT INTO LIBRARY VALUES (501, 'AI for ALL', 'Technology', 589); -- (II) ALTER TABLE LIBRARY ADD Author CHAR(20); -- (III) (VARCHAR(20) also accepted)


Answer देखें
(a)
SELECT UPPER(RIGHT(GuestName, 3)) FROM Guest; -- I SELECT GuestName, DAYNAME(CheckInDate) FROM Guest; -- II SELECT MOD(Charges, 1000) FROM Guest; -- III SELECT MID(GuestName, 2, 3) FROM Guest; -- IV
OR (b) Output:
I. Hemant, Neha, Keshav
II. Hemant 10, Keshav 5
III. March, January, December
IV. 101 → 1, 102 → NULL, 103 → 20, 104 → 25


Answer देखें
(a)
SELECT DATE('2026-01-01 10:10:10'); -- I
SELECT LOWER(Cust_Name) FROM Customer; -- II
SELECT LEFT(City_Name, 4) FROM Location; -- III
SELECT LTRIM(CITY) FROM EVENT; -- IV
SELECT AVG(Salary) FROM Employees; -- VOR (b)
SELECT POWER(17, 2); -- I (289) SELECT DAY(Hire_Date) FROM Employee; -- II SELECT MAX(Bill_Amount) FROM Bill; -- III SELECT TRIM(Location) FROM Branch; -- IV SELECT SUM(tot_sal) FROM Employees; -- V
CBSE Board Paper 2025 – 12 questions

Answer देखें
(D) August

Answer देखें
(C) LEFT()

Answer देखें
False – MOD() returns the remainder, not the quotient.

Answer देखें
(B) POWER()

Answer देखें
(B) (i)-(b) ROUND, (ii)-(a) COUNT, (iii)-(d) YEAR, (iv)-(c) RIGHT

Answer देखें
(C) – Assertion is true, Reason is false: ROUND() is a math (numeric) function, not a string function.

Answer देखें
SELECT UPPER('Informatics Practices'); -- (i) INFORMATICS PRACTICES
SELECT LENGTH('Informatics Practices'); -- (ii) 21
Answer देखें
A DBMS is software used to create, store, manage, update and retrieve data in databases in an organised and secure way, while controlling access and reducing redundancy. Examples: MySQL, Oracle, Microsoft SQL Server, PostgreSQL.

Answer देखें
CREATE TABLE Customer (
CID INT PRIMARY KEY,
FName VARCHAR(20),
LName VARCHAR(20),
Age INT
); -- (i)
SELECT * FROM Customer ORDER BY LName DESC; -- (ii)

Answer देखें
(a)
SELECT CITY, COUNT(*) FROM STUDENTS GROUP BY CITY; -- (i) SELECT AVG(AGE) FROM STUDENTS; -- (ii) SELECT S.NAME, G.GRADE FROM STUDENTS S, GRADES G WHERE S.S_ID = G.S_ID; -- (iii)
OR (b)
DELETE FROM SALES WHERE UnitsSold < 80; -- (i) SELECT PName FROM PRODUCTS WHERE Category IS NULL; -- (ii) SELECT P.PName, S.UnitsSold FROM PRODUCTS P, SALES S WHERE P.PID = S.PID; -- (iii)


Answer देखें
(a)
INSERT INTO COURSE VALUES ('C106', 'Introduction to AI', 'Ms. Preeti', 55); -- (i)
SELECT MAX(DURATION) FROM COURSE; -- (ii)
SELECT COUNT(*) FROM COURSE; -- (iii)
SELECT LOWER(INSTRUCTOR) FROM COURSE; -- (iv)OR (b) Output: (i) PRIYA (ii) RAVI SHARMA (iii) ARJUN SINGH, PRIYA JAIN (iv) 4 (NULL is not counted)

Answer देखें
(a)
SELECT SUM(Score) FROM STUDENTS; -- (i) SELECT LEFT(Name, 5) FROM STUDENTS; -- (ii) SELECT RTRIM(Name) FROM STUDENTS; -- (iii) SELECT MIN(Score) FROM GRADES; -- (iv) UPDATE STUDENTS SET FEE = FEE + 100; -- (v)
OR (b)
SELECT POWER(15, 2); -- (i) 225
SELECT ROUND(456.789); -- (ii) 457
SELECT INSTR('mycommercial.com', 'com'); -- (iii) 3
SELECT DAYNAME('2024-11-07'); -- (iv) Thursday
SELECT NOW(); -- (v)CBSE Board Paper 2024 – 12 questions

Answer देखें
(iv) 4 – MOD(17,3) = 2 and POWER(2,2) = 4.

Answer देखें
(iii) LCASE()

Answer देखें
(iii) ALTER TABLE

Answer देखें
(ii) 2023

Answer देखें
(ii) INSERT INTO

Answer देखें
(iii) MID()

Answer देखें
(i) YAN3 (ii) 76345.46

Answer देखें
UPDATE is a DML command – it changes the data (values) stored in rows, e.g. UPDATE STUDENT SET Marks = 90 WHERE RollNo = 3;
ALTER TABLE is a DDL command – it changes the structure of the table (add/drop/modify a column or a key), e.g. ALTER TABLE STUDENT ADD City VARCHAR(20);

Answer देखें
(a)
SELECT Sid, SName FROM Sports WHERE MONTH(DateofPlay) = 9; -- (i) SELECT LOWER(SName) FROM Sports; -- (ii) SELECT RIGHT(SName, 2) FROM Sports WHERE Fees < 1500; -- (iii) gives 'te' (Karate)
OR (b) Output: (i) BADMINTON (ii) Law, Bad (iii) S3, S4

Answer देखें
(i) 6 tuples (ii) salesman_id (unique for every salesman)
(iii)
SELECT * FROM Salesman ORDER BY commission DESC;

Answer देखें
SELECT WINNER FROM NOBEL WHERE SUBJECT = 'Literature' AND YEAR = 1970; -- (i) SELECT SUBJECT, CATEGORY FROM NOBEL WHERE COUNTRY IS NULL; -- (ii) SELECT * FROM NOBEL WHERE CATEGORY = 'Scientist'; -- (iii) SELECT COUNT(*) FROM NOBEL WHERE SUBJECT = 'Literature'; -- (iv)


Answer देखें
UPDATE Employee SET Department = 'IT' WHERE First_name = 'Shivam'; -- (i) DELETE FROM Employee WHERE First_name = 'Alisha'; -- (ii) ALTER TABLE Employee ADD Experience INT; -- (iii) SELECT E.First_name, E.Last_name, R.Amount FROM Employee E, Reward R WHERE E.Employee_id = R.Employee_id; -- (iv) SELECT E.First_name, E.Salary FROM Employee E, Reward R WHERE E.Employee_id = R.Employee_id AND R.Amount < 2000; -- (v)
OR
SELECT YEAR(Joining_date) FROM Employee; -- (i) SELECT Department, AVG(Salary) FROM Employee GROUP BY Department; -- (ii) SELECT E.First_name, R.Date_reward FROM Employee E, Reward R WHERE E.Employee_id = R.Employee_id AND DAYNAME(E.Joining_date) = 'Monday'; -- (iii) SELECT SUM(E.Salary) FROM Employee E, Reward R WHERE E.Employee_id = R.Employee_id AND R.Amount > 3000; -- (iv) DROP TABLE Reward; -- (v)
CBSE Board Paper 2023 – 12 questions

Answer देखें
(i) 7876.46

Answer देखें
(iii) Multiple Row Functions

Answer देखें
(iv) ORDER BY

Answer देखें
(iii) Trim( )

Answer देखें
(iv) 0

Answer देखें
(iv) LEN( ) – MySQL has LENGTH() (a text function), not an aggregate LEN().

Answer देखें
Errors: TOTAL is not an SQL function (use SUM); a condition on a column without grouping should be in WHERE (or use GROUP BY zone with HAVING).
SELECT zone, SUM(bonus) FROM employee WHERE zone = 'WEST';
or
SELECT zone, SUM(bonus) FROM employee GROUP BY zone HAVING zone = 'WEST';

Answer देखें
COUNT(column) counts only the non-NULL values of that column; COUNT(*) counts all rows, including rows with NULL values.
Example: if table EMP has 5 rows and Bonus is NULL in 2 rows, SELECT COUNT(Bonus) FROM EMP; gives 3 and SELECT COUNT(*) FROM EMP; gives 5.

Answer देखें
SELECT * FROM Patient WHERE MONTH(Dateofadm) = 1; -- (i) SELECT COUNT(*) FROM Patient WHERE City = 'Delhi'; -- (ii) SELECT RIGHT(Patientid, 2) FROM Patient WHERE Department = 'Surgery'; -- (iii)

Answer देखें
(i) 6 (ii) 34000 (1700 × 20) (iii) Foun, Nigh
OR: (i) MATE (ii) ION (iii) 8


Answer देखें
SELECT YEAR('2023-05-15'); -- (i)
SELECT LOWER('ABC@XYZ.com'); -- (ii)
SELECT LTRIM(' my country '); -- (iii)
SELECT CURDATE(); -- (iv) or SELECT DATE(NOW());
SELECT POWER(10, 6); -- (v)OR
SELECT LEFT(Itemname, 3) FROM PRODUCT; -- (i) SELECT Itemname FROM PRODUCT WHERE DAYNAME(Stockdate) = 'Monday'; -- (ii) SELECT SUM(Price) FROM PRODUCT; -- (iii) SELECT MAX(Price) FROM PRODUCT; -- (iv) SELECT AVG(Price) FROM PRODUCT WHERE Company = 'Logitech'; -- (v)


Answer देखें
SELECT Gender, AVG(Marks) FROM Schooldata GROUP BY Gender; -- (i) SELECT MIN(Marks) FROM Schooldata WHERE Grade = 10; -- (ii) SELECT Club, COUNT(*) FROM Schooldata GROUP BY Club HAVING COUNT(*) > 1; -- (iii) SELECT Gender, MAX(Marks), MIN(Marks) FROM Schooldata GROUP BY Gender; -- OR (iii)
CBSE Board Paper 2022 (Term-2, 35 marks) – 9 questions

Answer देखें
(i) 7658.35 (ii) 2 – ROUND(13.9,0) = 14 and 14 MOD 3 = 2.
OR: POWER(m, n) is a single-row (math) function that returns m raised to n for each row; SUM() is an aggregate function that returns one total of a whole column/group. POWER takes two arguments, SUM takes one column.

Answer देखें
(i) INDIA MOVEMENT (ii) 8 – 'IA' first occurs at position 8 in ARTIFICIAL.

Answer देखें
Error: an aggregate condition cannot be written in WHERE; it must be in HAVING after GROUP BY. To count students, COUNT(*) is needed (not MAX(Marks)).
SELECT Class, COUNT(*) FROM STUDENT GROUP BY Class HAVING COUNT(*) > 3;


Answer देखें
SELECT LTRIM(Name) FROM SCHOOLDATA; -- (i) SELECT Name FROM SCHOOLDATA WHERE DAYNAME(Dob) = 'Sunday'; -- (ii)
(For the given data no student was born on a Sunday, so (ii) returns an empty set.)
OR – Output: (i) 91 (ii)
+----------------+--------------+ | LEFT(Gender,1) | Name | +----------------+--------------+ | F | Swapnil Pant | | M | Rahil Arora | +----------------+--------------+

Answer देखें
(i) ALL THE BEST (ii) 25 (iii) INDIA
OR
SELECT UPPER(Breed) FROM MYPET; -- (i) SELECT SUM(Price) FROM MYPET; -- (ii) SELECT AVG(LifeSpan) FROM MYPET; -- (iii) NULL is ignored: 51/4 = 12.75

Answer देखें
(i) MONTHNAME() (ii) LOWER() / LCASE() (iii) LENGTH()

Answer देखें
(i) 12 – MOD(5,3) = 2, 10 + 2 = 12
(ii) 52.50 and 75.30 (Eraser 10.50×5, Gel Pen 25.10×3)
(iii) ER, EN, EN, ER

Answer देखें
SELECT * FROM ITEM ORDER BY Stockdate DESC; -- (i) SELECT Type, COUNT(*) FROM ITEM GROUP BY Type; -- (ii) SELECT MIN(Price) FROM ITEM; -- (iii) SELECT Itemname, ROUND(Price, 1) FROM ITEM; -- (iv)

Answer देखें
(i) MAX = 280, MIN = 68 (ii) 5 (NULL is not counted) (iii) 4 and 5 (Ravi, Ankit) (iv) Ankit
OR
SELECT COUNT(*) FROM SALESMAN; -- (i) SELECT Area, MAX(Qtysold) FROM SALESMAN GROUP BY Area; -- (ii) SELECT Area, AVG(Qtysold) FROM SALESMAN GROUP BY Area HAVING COUNT(*) > 1; -- (iii) SELECT * FROM SALESMAN ORDER BY Area; -- (iv)
आगे: Unit 3 – Networks, Devices और Topologies।
