CBSE Class 12 Informatics Practices My Sql Worksheet Set A

Read and download free pdf of CBSE Class 12 Informatics Practices My Sql Worksheet Set A. Download printable Informatics Practices Class 12 Worksheets in pdf format, CBSE Class 12 Informatics Practices My Sql Worksheet has been prepared as per the latest syllabus and exam pattern issued by CBSE, NCERT and KVS. Also download free pdf Informatics Practices Class 12 Assignments and practice them daily to get better marks in tests and exams for Class 12. Free chapter wise worksheets with answers have been designed by Class 12 teachers as per latest examination pattern

My Sql Informatics Practices Worksheet for Class 12

Class 12 Informatics Practices students should refer to the following printable worksheet in Pdf in Class 12. This test paper with questions and solutions for Class 12 Informatics Practices will be very useful for tests and exams and help you to score better marks

Class 12 Informatics Practices My Sql Worksheet Pdf

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

My Sql CBSE Class 12 Informatics Practices Worksheet

The above practice worksheet for My Sql has been designed as per the current syllabus for Class 12 Informatics Practices released by CBSE. Students studying in Class 12 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 12 Informatics Practices on a daily basis. All the latest practice worksheets with solutions have been developed for Informatics Practices by referring to the most important and regularly asked topics that the students should learn and practice to get better scores in their examinations. Studiestoday is the best portal for Printable Worksheets for Class 12 Informatics Practices students to get all the latest study material free of cost. Teachers of studiestoday have referred to the NCERT book for Class 12 Informatics Practices to develop the Informatics Practices Class 12 worksheet. After solving the questions given in the practice sheet which have been developed as per the latest course books also refer to the NCERT solutions for Class 12 Informatics Practices designed by our teachers. After solving these you should also refer to Class 12 Informatics Practices MCQ Test for the same chapter. We have also provided a lot of other Worksheets for Class 12 Informatics Practices which you can use to further make yourself better in Informatics Practices.

Where can I download latest CBSE Practice worksheets for Class 12 Informatics Practices My Sql

You can download the CBSE Practice worksheets for Class 12 Informatics Practices My Sql for the latest session from StudiesToday.com

Are the Class 12 Informatics Practices My Sql Practice worksheets available for the latest session

Yes, the Practice worksheets issued for My Sql Class 12 Informatics Practices have been made available here for the latest academic session

Is there any charge for the Practice worksheets for Class 12 Informatics Practices My Sql

There is no charge for the Practice worksheets for Class 12 CBSE Informatics Practices My Sql you can download everything free

How can I improve my scores by solving questions given in Practice worksheets in My Sql Class 12 Informatics Practices

Regular revision of practice worksheets given on studiestoday for Class 12 subject Informatics Practices My Sql can help you to score better marks in exams

Are there any websites that offer free Practice test papers for Class 12 Informatics Practices My Sql

Yes, studiestoday.com provides all the latest Class 12 Informatics Practices My Sql test practice sheets with answers based on the latest books for the current academic session