CBSE Class 12 Informatics Practices My Sql Worksheet Set 01

Download Class 12 Informatics Practices Worksheets for My Sql

Explore reliable practice materials for My Sql tailored for Class 12 learners. Utilizing these Informatics Practices worksheets ensures thorough preparation and strengthens problem-solving speed for upcoming school assessments.

Access My Sql Questions and Exercises

Access the complete worksheet PDF for My Sql below. Regular practice with these targeted questions builds familiarity with standard exam patterns and helps secure higher marks in final Informatics Practices evaluations.

Q1. Given the following table INVENTORY, write SQL Commands based on the table.

CBSE Class 12 Informatics Practices My Sql Worksheet Set A 1

a. Display names of the snack which starts with ‘Y’
 
b. Display names of the beverages whose qty is 10.
 
c. Display names of the products whose price is in the range 15 to 20.
 
d. Display names of beverages and noodles.
 
e. Display names of the products whose code starts with ‘B’ and ends with 2.
 
f. Remove qty column.
 
g. Display the table in descending order of price.
 
h. Remove FRESH tea from the table.
 
i. Change price of WOW to 25.2
 
j. To display the total price category wise for those categories which has at least 2 items.
 
Find output:
 
1. SELECT COUNT(CODE) FROM INVENTORY;
 
2. SELECT SUM(QTY) FROM INVENTORY;
 
3. SELECT DISTINCT CAT FROM INVENTORY;
 
4. SELECT COUNT(DISTINCT CAT) FROM INVENTORY;
 
5. SELECT MIN(PRICE) FROM INVENTORYWHERE PRICE < 15;
 
6. SELECT NAME FROM INVENTORY WHERE CAT LIKE ‘N%l_’;
 
Q2. Given the following table HOSPITAL, write SQL commands on the basis of table HOSPITAL.

CBSE Class 12 Informatics Practices My Sql Worksheet Set A 2
 
DATEOFADM – Date of Admission to the hospital
 
(i) To display names of patients who are admitted in the hospital before 1st January 2019.
 
(ii) To add a new row with the following values 10, ‘Shilpa’, 30, ‘Orthopedic’, ‘2019-01-25’, 12000
 
(iii) To display all the details in descending order of charges.
 
(iv) To increase the Surgery Department charges by 500.
 
(v) To add a new column DOCTOR with datatype VARCHAR(30).
 
(vi) To remove the details of the patients of Cardiology Department whose names have the letter ‘u’ in it.
 
(vii) To remove the column age.
 
(viii) To display the highest charges of departments where date of admission is more than 5th June 2009, department wise.
 
Find Output :
 
(a) SELECT NAME FROM HOSPITAL WHERE DEPARTMENT LIKE ‘_a%’;
 
(b) SELECT COUNT(AGE) FROM HOSPITAL;
 
(c) SELECT ID,NAME FROM HOSPITAL WHERE AGE>30;
 
(d) SELECT MAX(AGE),MIN(AGE) FROM HOSPITAL;
 
(e) SELECT COUNT(DISTINCT DEPARTMENT) FROM HOSPITAL;
 
(f) SELECT AVG(AGE) FROM HOSPITAL WHERE ID>2 GROUP BY DEPARTMENT HAVING MIN(CHARGES) > 5000;


Please click on below link to download CBSE Class 12 Informatics Practices My Sql Worksheet Set A

Free study material for Informatics Practices

My Sql Practice Sheet and Solutions for Class 12 Informatics Practices

Download Practice Sheet: My Sql (Class 12 Informatics Practices)

Review targeted practice exercises for Class 12 Informatics Practices My Sql. Curated to match official CBSE guidelines, these downloadable PDF sheets support daily revision and core concept reinforcement.

Concept Clarification for My Sql

Each worksheet is structured around standard CBSE textbooks, allowing students to check their working steps and correct mistakes early in their revision.

Additional Study Resources for Class 12 Informatics Practices

Follow up your worksheet practice by attempting the interactive online Informatics Practices MCQ test for this chapter to evaluate your execution speed. All platform resources are free to access.

FAQs

Where can I download the latest PDF for CBSE Class 12 Informatics Practices My Sql Worksheet Set 01?

You can download the teacher-verified PDF for CBSE Class 12 Informatics Practices My Sql Worksheet Set 01 from StudiesToday.com. These practice sheets for Class 12 Informatics Practices are designed as per the latest CBSE academic session.

Are these Informatics Practices Class 12 worksheets based on the 2026-27 competency-based pattern?

Yes, our CBSE Class 12 Informatics Practices My Sql Worksheet Set 01 includes a variety of questions like Case-based studies, Assertion-Reasoning, and MCQs as per the 50% competency-based weightage in the latest curriculum for Class 12.

Do you provide solved answers for CBSE Class 12 Informatics Practices My Sql Worksheet Set 01?

Yes, we have provided detailed solutions for CBSE Class 12 Informatics Practices My Sql Worksheet Set 01 to help Class 12 and follow the official CBSE marking scheme.

How does solving CBSE Class 12 Informatics Practices My Sql Worksheet Set 01 help in exam preparation?

Daily practice with these Informatics Practices worksheets helps in identifying understanding gaps. It also improves question solving speed and ensures that Class 12 students get more marks in CBSE exams.

Is there any charge for the Class 12 Informatics Practices practice test papers?

All our Class 12 Informatics Practices practice test papers and worksheets are available for free download in mobile-friendly PDF format. You can access CBSE Class 12 Informatics Practices My Sql Worksheet Set 01 without any registration.