SQL DML And SELECT Queries Practice Worksheets For Class XII (With Answers)

SQL DML and SELECT Queries Practice Worksheets for Class XII (With Answers)

Are you studying Structured Query Language (SQL) for your Class XII Computer Science or Informatics Practices curriculum? To master database manipulation and data retrieval, practice is key! Below, you will find five comprehensive sets of worksheets focusing on Data Manipulation Language (DML), the SELECT statement, operators, clauses, handling NULL values, pattern matching (`LIKE`), UPDATE, DELETE commands, and aggregate functions.

Each set contains 10 practice questions. Click the “Show Answer Key” button under each worksheet to check your solutions and review the code examples.

Worksheet Set 1: Basic SELECT, Operators, Aliasing & DISTINCT

COMPUTER SCIENCE / INFORMATICS PRACTICES

SQL Worksheet Set 1: Basic SELECT, Operators, Aliasing & DISTINCT

Name: ________________________ Roll No: _________ Date: ____________

Q1. Write a query to display all records and columns from a table named Employee.

Q2. Consider a table Employee with columns EmpName and Salary. Write a query to display each employee’s name and their calculated annual salary under an alias AnnualSalary (Salary * 12).

Q3. Write a query to display the unique job titles from the Job column in an Employee table without duplicate rows.

Q4. Evaluate the mathematical query output: SELECT 15 + 4 * 3 - 2;.

Q5. Write a query to display only the ItemName and Price columns from a table named Product.

Q6. Given a table Staff with columns Name and Bonus, write a query to display staff names and an alias column NetBonus calculated by adding 500 to their current bonus.

Q7. Write a query to retrieve distinct departments from a Department column in a table named Worker.

Q8. What will be the output of the query: SELECT 50 / 5 + 10;?

Q9. Consider a table Item with columns ItemName and Price. Write a query to display item names and a discounted price column named DiscPrice computed as Price * 0.90.

Q10. Write a query to display unique grades secured by students from a Student table.

Answer Key – Set 1

Ans 1:

SELECT * FROM Employee;

Ans 2:

SELECT EmpName, Salary * 12 AS AnnualSalary FROM Employee;

Ans 3:

SELECT DISTINCT Job FROM Employee;

Ans 4:
Output: 25 (Following operator precedence: 4 * 3 = 12, then 15 + 12 – 2 = 25).

Ans 5:

SELECT ItemName, Price FROM Product;

Ans 6:

SELECT Name, Bonus + 500 AS NetBonus FROM Staff;

Ans 7:

SELECT DISTINCT Department FROM Worker;

Ans 8:
Output: 20 (Division runs before addition: 50 / 5 = 10, then 10 + 10 = 20).

Ans 9:

SELECT ItemName, Price * 0.90 AS DiscPrice FROM Item;

Ans 10:

SELECT DISTINCT Grade FROM Student;

Worksheet Set 2: WHERE Clause, Relational/Logical Operators, BETWEEN, IN & ORDER BY

COMPUTER SCIENCE / INFORMATICS PRACTICES

SQL Worksheet Set 2: WHERE Clause, Operators, BETWEEN, IN & ORDER BY

Name: ________________________ Roll No: _________ Date: ____________

Q1. Write a query to display all details of students from a Student table where Stream is ‘Science’ and Marks are greater than 85.

Q2. Write a query to fetch details of employees whose salary is either 25000, 30000, or 45000 using the IN operator.

Q3. Write a query to display products whose price falls between 100 and 500 (inclusive) using the BETWEEN operator.

Q4. Write a query to list all employee records from a table Staff sorted in descending order of their JoiningDate.

Q5. Write a query to display items whose category is ‘Electronics’ and price is not greater than 2000.

Q6. Write a query to display student names and marks where marks are less than 40 or greater than 90.

Q7. Write a query to list employees working in either ‘HR’, ‘IT’, or ‘Finance’ departments using the IN operator.

Q8. Write a query to display all book details sorted alphabetically by their Title column.

Q9. Write a query to fetch records of customers whose age is between 20 and 30 using the BETWEEN operator.

Q10. Write a query to display items whose quantity is greater than or equal to 50, ordered by quantity in ascending order.

Answer Key – Set 2

Ans 1:

SELECT * FROM Student WHERE Stream = 'Science' AND Marks > 85;

Ans 2:

SELECT * FROM Employee WHERE Salary IN (25000, 30000, 45000);

Ans 3:

SELECT * FROM Product WHERE Price BETWEEN 100 AND 500;

Ans 4:

SELECT * FROM Staff ORDER BY JoiningDate DESC;

Ans 5:

SELECT * FROM Items WHERE Category = 'Electronics' AND Price <= 2000;

Ans 6:

SELECT Name, Marks FROM Student WHERE Marks < 40 OR Marks > 90;

Ans 7:

SELECT * FROM Employee WHERE Department IN ('HR', 'IT', 'Finance');

Ans 8:

SELECT * FROM Book ORDER BY Title ASC; -- (or simply ORDER BY Title)

Ans 9:

SELECT * FROM Customer WHERE Age BETWEEN 20 AND 30;

Ans 10:

SELECT * FROM Items WHERE Quantity >= 50 ORDER BY Quantity ASC;

Worksheet Set 3: Handling NULL Values & Pattern Matching with LIKE

COMPUTER SCIENCE / INFORMATICS PRACTICES

SQL Worksheet Set 3: Handling NULL Values & Pattern Matching (LIKE)

Name: ________________________ Roll No: _________ Date: ____________

Q1. Explain what a NULL value signifies in a relational database table.

Q2. Write a query to display the names of employees whose Commission column contains a NULL value.

Q3. Write a query to list all books from a Book table where the phone number is not missing (i.e., not null).

Q4. Write a query to display the names of all students starting with the letter ‘A’.

Q5. Write a query to find all items where the second character of the item name is ‘u’.

Q6. Write a query to display employee names whose names end with the letter ‘n’.

Q8. Write a query to find customer accounts where the email address is missing (null).

Q9. Write a query to list products where the description column is not empty/null.

Q10. Write a query to display names of employees starting with ‘S’ and ending with ‘h’.

Answer Key – Set 3

Ans 1:
A NULL value represents missing, unknown, or inapplicable data. It is distinct from zero or an empty string/blank space.

Ans 2:

SELECT EmpName FROM Employee WHERE Commission IS NULL;

Ans 3:

SELECT * FROM Book WHERE Phone IS NOT NULL;

Ans 4:

SELECT Name FROM Student WHERE Name LIKE 'A%';

Ans 5:

SELECT ItemName FROM Items WHERE ItemName LIKE '_u%';

Ans 6:

SELECT EmpName FROM Employee WHERE EmpName LIKE '%n';

Ans 7:

SELECT * FROM Student WHERE Name LIKE '%esh%';

Ans 8:

SELECT * FROM Customer WHERE Email IS NULL;

Ans 9:

SELECT * FROM Product WHERE Description IS NOT NULL;

Ans 10:

SELECT EmpName FROM Employee WHERE EmpName LIKE 'S%h';

Worksheet Set 4: UPDATE & DELETE Commands

COMPUTER SCIENCE / INFORMATICS PRACTICES

SQL Worksheet Set 4: UPDATE & DELETE Commands

Name: ________________________ Roll No: _________ Date: ____________

Q1. Write a query to update the salary of all employees to 50000 in the Employee table.

Q2. Write a query to increase the price of all items by 10% in the Inventory table where the category is ‘Stationery’.

Q3. Write a query to change the department to ‘HR’ and raise the salary by 5000 for an employee whose EmpID is 102.

Q4. Write a query to delete all records from a table named TempLogs.

Q5. Write a query to delete records from the Student table where attendance is less than 40.

Q6. Write a query to update email to ‘Not Provided’ where the email column is NULL in a User table.

Q7. Write a query to delete products from an Inventory table where stock quantity is 0.

Q8. Write a query to update account status to ‘Active’ for all customers whose age is greater than or equal to 18.

Q9. Write a query to delete employees from a Staff table who belong to the ‘Temporary’ department.

Q10. Write a query to set a discount percentage to 5 for all items whose price exceeds 1000.

Answer Key – Set 4

Ans 1:

UPDATE Employee SET Salary = 50000;

Ans 2:

UPDATE Inventory SET Price = Price * 1.10 WHERE Category = 'Stationery';

Ans 3:

UPDATE Employee SET Department = 'HR', Salary = Salary + 5000 WHERE EmpID = 102;

Ans 4:

DELETE FROM TempLogs;

Ans 5:

DELETE FROM Student WHERE Attendance < 40;

Ans 6:

UPDATE User SET Email = 'Not Provided' WHERE Email IS NULL;

Ans 7:

DELETE FROM Inventory WHERE Stock = 0;

Ans 8:

UPDATE Customer SET Status = 'Active' WHERE Age >= 18;

Ans 9:

DELETE FROM Staff WHERE Department = 'Temporary';

Ans 10:

UPDATE Items SET Discount = 5 WHERE Price > 1000;

Worksheet Set 5: Aggregate Functions & Mixed Queries

COMPUTER SCIENCE / INFORMATICS PRACTICES

SQL Worksheet Set 5: Aggregate Functions & Mixed Queries

Name: ________________________ Roll No: _________ Date: ____________

Q1. Write a query to find the total number of rows/records in the Customer table.

Q2. Write a query to display the maximum and minimum salary earned by any employee in the Staff table.

Q3. Write a query to calculate the average price of all products available in the Product table.

Q4. Write a query to find the total sum of salaries paid to employees working in the ‘Sales’ department.

Q5. What is the core behavior of aggregate functions when encountering NULL values in a column?

Q6. Write a query to count the total number of students enrolled in the ‘Commerce’ stream.

Q7. Write a query to find the highest marks obtained by any student in the Exam table.

Q8. Write a query to find the lowest price among items belonging to the ‘Grocery’ category.

Q9. Write a query to calculate the average age of employees working in the ‘HR’ department.

Q10. Write a query to calculate the total ordered quantity across all transactions in an Orders table.

Answer Key – Set 5

Ans 1:

SELECT COUNT(*) FROM Customer;

Ans 2:

SELECT MAX(Salary), MIN(Salary) FROM Staff;

Ans 3:

SELECT AVG(Price) FROM Product;

Ans 4:

SELECT SUM(Salary) FROM Employee WHERE Department = 'Sales';

Ans 5:
Aggregate functions (such as SUM, AVG, MAX, MIN, COUNT(column_name)) automatically ignore NULL values during their execution, except for COUNT(*) which counts all rows regardless of nulls.

Ans 6:

SELECT COUNT(*) FROM Student WHERE Stream = 'Commerce';

Ans 7:

SELECT MAX(Marks) FROM Exam;

Ans 8:

SELECT MIN(Price) FROM Items WHERE Category = 'Grocery';

Ans 9:

SELECT AVG(Age) FROM Employee WHERE Department = 'HR';

Ans 10:

SELECT SUM(Quantity) FROM Orders;

By Anjeev Kr Singh – Computer Science Educator
Published on : September 18, 2026 | Updated on : September 18, 2026

About the Author

Anjeev Kr Singh

Computer Science Educator, Author, and HOD. Guiding CBSE students in CS, IP, IT, WA & AI via mycstutorial.in. Creator of Question Bank for Class 10 & 12 students.

SQL DML and SELECT Queries Practice Worksheets for Class XII (With Answers)