Download Class 11 Informatics Practices Worksheets for My Sql
Access printable practice worksheets for My Sql designed to align with the 2026-27 academic syllabus for Class 11 Informatics Practices. These structured exercises help students evaluate their conceptual understanding and improve exam readiness.
Access My Sql Questions and Exercises
Navigate directly to the printable exercises for My Sql using the digital viewer below. Each practice set allows students to isolate specific topics for thorough review and uninterrupted practice alongside standard textbooks.
Topic : MySQL - REVISION
Lab Work Sheet
→ Write SQL Commands to do the following :
1. Create a table LIBRARY with the fields : BookId varchar(10), Name varchar(30), Author varchar(30), Quantity integer, Price Numeric(8,2) and BType varchar(15) Ensure the following constraints are met
• Make BookId as the Primary key
• Quantity should be more than zero
• Default value of Price should be 100
• BType should be Fiction, Classics, Health, Education
2. Insert the details of 5 books in the table.
3. Display the details of the books whose price is in the range 200 and 400
4. Display the names of the books starting with ‘T’
5. Display the various types of books without duplicates
6. Display BookId and name of the books whose quantity is less than 5 and price is more than 500
7. Display Book name and Quantity * Price. Give column alias as Value for the product of Quantity and Price
8. Display the records in the following format BookName is written by Author
9. Display the names of the books which do not have a type.
10. Display the names of the books which have types entered in the table.
11. Display the details of the books in descending order of their price.
12. Display the book names whose type is other than Fiction and Classics
13. Display the highest price, least price, sum of quantity and average price.
14. Display the book name and discount (10% of price) for all the books.
15. Change the quantity as 10 for the book whose Id is B002
16. Delete the books whose price is below 300
17. Add a new column Publisher varchar(40)
18. Modify book name type to varchar(50)
19. Delete the column Publisher.
20. Display the structure of the table
21. Display the list of tables in the database
22. Display the result of the expression 78*5 /4
23. Add a new row with Book name as ‘Informatics Practices’ and BookId as ‘E101’
24. Display current date and time.
25. Display month from the date ‘12th August 2018’
Please click on below link to download CBSE Class 11 Informatics Practices My Sql Worksheet Set F
Exam Preparation Worksheet for Class 11 Informatics Practices My Sql
My Sql Printable Worksheet for Class 11 Informatics Practices
Explore reliable practice questions for My Sql tailored for Class 11 Informatics Practices learners. Use these structured worksheets to evaluate preparedness and strengthen problem-solving skills.
How to Use These Practice Sheets
Each worksheet is structured around standard CBSE textbooks, allowing students to check their working steps and correct mistakes early in their revision.
Enhance Speed with Online Practice
Wrap up your chapter revision by testing your knowledge against standard question formats. Everything on our platform is provided free of charge.
FAQs
You can download the teacher-verified PDF for CBSE Class 11 Informatics Practices My Sql Worksheet Set 06 from StudiesToday.com. These practice sheets for Class 11 Informatics Practices are designed as per the latest CBSE academic session.
Yes, our CBSE Class 11 Informatics Practices My Sql Worksheet Set 06 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 11.
Yes, we have provided detailed solutions for CBSE Class 11 Informatics Practices My Sql Worksheet Set 06 to help Class 11 and follow the official CBSE marking scheme.
Daily practice with these Informatics Practices worksheets helps in identifying understanding gaps. It also improves question solving speed and ensures that Class 11 students get more marks in CBSE exams.
All our Class 11 Informatics Practices practice test papers and worksheets are available for free download in mobile-friendly PDF format. You can access CBSE Class 11 Informatics Practices My Sql Worksheet Set 06 without any registration.