Access the latest CBSE Class 11 Informatics Practices My Sql Worksheet Set F. We have provided free printable Class 11 Informatics Practices worksheets in PDF format, specifically designed for My Sql. These practice sets are prepared by expert teachers following the 2025-26 syllabus and exam patterns issued by CBSE, NCERT, and KVS.
My Sql Informatics Practices Practice Worksheet for Class 11
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 session.
Download Class 11 Informatics Practices My Sql Worksheet PDF
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
| CBSE Class 11 Informatics Technology Computer Fundamentals Worksheet |
| CBSE Class 11 Informatics Technology Computer Organization And Network Worksheet |
| CBSE Class 11 Informatics Technology Computer Organization And User Perspective Worksheet |
| CBSE Class 11 Informatics Practices Hardware Concepts Worksheet |
| CBSE Class 11 Informatics Technology IT Applications Worksheet |
| CBSE Class 11 Informatics Practices Java Programming Worksheet |
| CBSE Class 11 Informatics Practices Java Programming Decision Structures Worksheet |
| CBSE Class 11 Informatics Practices Java Programming List Box Worksheet |
| CBSE Class 11 Informatics Practices Java Programming Looping Structures Worksheet |
| CBSE Class 11 Informatics Practices Java Programming Variables Worksheet |
| CBSE Class 11 Informatics Technology Networking And Internet Worksheet |
| CBSE Class 11 Informatics Technology Open Office Calc Worksheet |
| CBSE Class 11 Informatics Technology Open Office Impress Worksheet |
| CBSE Class 11 Informatics Technology Open Office Writer Worksheet Set A |
| CBSE Class 11 Informatics Technology Open Office Writer Worksheet Set B |
| CBSE Class 11 Informatics Practices Python Conditional And Iterative Worksheet |
| CBSE Class 11 Informatics Practices Simple Queries Worksheet |
| CBSE Class 11 Informatics Practices Simple Queries Worksheet Set A |
| CBSE Class 11 Informatics Technology Word Processing Worksheet |
Important Practice Resources for Class 11 Informatics Practices
My Sql CBSE Class 11 Informatics Practices Worksheet
Students can use the My Sql practice sheet provided above to prepare for their upcoming school tests. This solved questions and answers follow the latest CBSE syllabus for Class 11 Informatics Practices. You can easily download the PDF format and solve these questions every day to improve your marks. Our expert teachers have made these from the most important topics that are always asked in your exams to help you get more marks in exams.
NCERT Based Questions and Solutions for My Sql
Our expert team has used the official NCERT book for Class 11 Informatics Practices to create this practice material for students. After solving the questions our teachers have also suggested to study the NCERT solutions which will help you to understand the best way to solve problems in Informatics Practices. You can get all this study material for free on studiestoday.com.
Extra Practice for Informatics Practices
To get the best results in Class 11, students should try the Informatics Practices MCQ Test for this chapter. We have also provided printable assignments for Class 11 Informatics Practices on our website. Regular practice will help you feel more confident and get higher marks in CBSE examinations.
You can download the teacher-verified PDF for CBSE Class 11 Informatics Practices My Sql Worksheet Set F 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 F 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 F 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 F without any registration.