Find CBSE Class 11 Informatics Practices My Sql Worksheet Set 06 right below. We offer free printable Class 11 Informatics Practices worksheets in PDF for My Sql. Built by expert teachers for the 2026-27 session, these practice exercises align with standard CBSE, NCERT, and KVS patterns.
Practice Paper: Class 11 Informatics Practices My Sql
Students should use these Class 11 Informatics Practices chapter-wise worksheets for daily practice to improve their conceptual understanding. This detailed test papers include important questions and solutions for My Sql, to help you prepare for school tests and final examination. Regular practice of these Class 11 Informatics Practices questions will help improve your problem-solving speed and exam accuracy for the 2026-27 session.
My Sql Worksheet Download for Class 11 Informatics Practices
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
Free study material for Informatics Practices
Exam Preparation Worksheet for Class 11 Informatics Practices My Sql
Revision Worksheet: My Sql (CBSE)
Make use of the My Sql practice set listed above to review effectively for school tests. Prepared according to current CBSE guidelines for Class 11 Informatics Practices, the material can be saved easily as a PDF format download. Routine problem-solving based on essential exam topics ensures steady grade improvement.
Solved Practice Sets & NCERT Solutions for My Sql
Compiled using the standard NCERT book for Class 11 Informatics Practices, these practice exercises ensure accurate guidance. Completing the questions should be followed by checking our comprehensive NCERT solutions, designed to teach clear techniques for Informatics Practices questions. Every resource is available free of cost.
Extra Practice for Informatics Practices
For top-tier results in Class 11, learners are encouraged to attempt the chapter-wise Informatics Practices MCQ test. Our platform also offers a wide range of printable assignments for Class 11 Informatics Practices. Consistent practice builds solid self-assurance and secures higher grades in CBSE assessments.
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.