CBSE Class 11 Informatics Practices My Sql Worksheet Set F

Read and download free pdf of CBSE Class 11 Informatics Practices My Sql Worksheet Set F. Download printable Informatics Practices Class 11 Worksheets in pdf format, CBSE Class 11 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 11 Assignments and practice them daily to get better marks in tests and exams for Class 11. Free chapter wise worksheets with answers have been designed by Class 11 teachers as per latest examination pattern

My Sql Informatics Practices Worksheet for Class 11

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

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

Practice Worksheets for Class 11 Information Practices
CBSE Class 11 Informatics Practices Hardware Concepts 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 Practices Java Programming Worksheet
CBSE Class 11 Informatics Practices My Sql Worksheet Set A
CBSE Class 11 Informatics Practices My Sql Worksheet Set B
CBSE Class 11 Informatics Practices My Sql Worksheet Set C
CBSE Class 11 Informatics Practices My Sql Worksheet Set D
CBSE Class 11 Informatics Practices My Sql Worksheet Set E
CBSE Class 11 Informatics Practices My Sql Worksheet Set F
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 Practices Sql Worksheet
CBSE Class 11 Informatics Practices Worksheet Set A Solved
CBSE Class 11 Informatics Practices Worksheet Set B Solved
CBSE Class 11 Informatics Practices Worksheet Set C Solved
CBSE Class 11 Informatics Practices Worksheet Set D Solved
CBSE Class 11 Informatics Practices Worksheet Set E Solved
CBSE Class 11 Informatics Practices Worksheet Set F Solved
CBSE Class 11 Informatics Practices Worksheet Set G Solved
CBSE Class 11 Informatics Practices Worksheet Set H Solved
CBSE Class 11 Informatics Practices Worksheet Set I Solved
CBSE Class 11 Informatics Practices Worksheet Set J Solved
CBSE Class 11 Informatics Practices Worksheet Set K Solved
CBSE Class 11 Informatics Practices Worksheet Set L Solved
CBSE Class 11 Informatics Practices Worksheet Set M Solved
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 Technology IT Applications Worksheet
CBSE Class 11 Informatics Technology Networking And Internet Worksheet
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set A
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set B
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set C
CBSE Class 11 Informatics Technology Office Automation Tools Worksheet Set D
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 Technology Presentation Worksheet Set F
CBSE Class 11 Informatics Technology Troubleshooting Hardware Software And Networking Worksheet Set A
CBSE Class 11 Informatics Technology Troubleshooting Hardware Software And Networking Worksheet Set B
CBSE Class 11 Informatics Technology Word Processing Worksheet

CBSE Class 11 Informatics Practices My Sql Worksheet

The above practice worksheet for My Sql has been designed as per the current syllabus for Class 11 Informatics Practices released by CBSE. Students studying in Class 11 can easily download in Pdf format and practice the questions and answers given in the above practice worksheet for Class 11 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 11 Informatics Practices students to get all the latest study material free of cost.

Worksheet for Informatics Practices CBSE Class 11 My Sql

Teachers of studiestoday have referred to the NCERT book for Class 11 Informatics Practices to develop the Informatics Practices Class 11 worksheet. If you download the practice worksheet for the above chapter daily, you will get better scores in Class 11 exams this year as you will have stronger concepts. Daily questions practice of Informatics Practices printable worksheet and its study material will help students to have a stronger understanding of all concepts and also make them experts on all scoring topics. You can easily download and save all revision Worksheets for Class 11 Informatics Practices also from www.studiestoday.com without paying anything in Pdf format. 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 11 Informatics Practices designed by our teachers

My Sql worksheet Informatics Practices CBSE Class 11

All practice paper sheet given above for Class 11 Informatics Practices have been made as per the latest syllabus and books issued for the current academic year. The students of Class 11 can be assured that the answers have been also provided by our teachers for all test paper of Informatics Practices so that you are able to solve the problems and then compare your answers with the solutions provided by us. We have also provided a lot of MCQ questions for Class 11 Informatics Practices in the worksheet so that you can solve questions relating to all topics given in each chapter. All study material for Class 11 Informatics Practices students have been given on studiestoday.

My Sql CBSE Class 11 Informatics Practices Worksheet

Regular printable worksheet practice helps to gain more practice in solving questions to obtain a more comprehensive understanding of My Sql concepts. Practice worksheets play an important role in developing an understanding of My Sql in CBSE Class 11. Students can download and save or print all the printable worksheets, assignments, and practice sheets of the above chapter in Class 11 Informatics Practices in Pdf format from studiestoday. You can print or read them online on your computer or mobile or any other device. After solving these you should also refer to Class 11 Informatics Practices MCQ Test for the same chapter.

Worksheet for CBSE Informatics Practices Class 11 My Sql

CBSE Class 11 Informatics Practices best textbooks have been used for writing the problems given in the above worksheet. If you have tests coming up then you should revise all concepts relating to My Sql and then take out a print of the above practice sheet and attempt all problems. We have also provided a lot of other Worksheets for Class 11 Informatics Practices which you can use to further make yourself better in Informatics Practices

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

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

Can I download the Practice worksheets of Class 11 Informatics Practices My Sql in Pdf

Yes, you can click on the links above and download chapter-wise Practice worksheets in PDFs for Class 11 for Informatics Practices My Sql

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

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

How can I download the My Sql Class 11 Informatics Practices Practice worksheets

You can easily access the links above and download the Class 11 Practice worksheets Informatics Practices for My Sql

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

There is no charge for the Practice worksheets for Class 11 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 11 Informatics Practices

Regular revision of practice worksheets given on studiestoday for Class 11 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 11 Informatics Practices My Sql

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

Can test sheet papers for My Sql Class 11 Informatics Practices be accessed on mobile devices

Yes, studiestoday provides worksheets in Pdf for My Sql Class 11 Informatics Practices in mobile-friendly format and can be accessed on smartphones and tablets.

Are practice worksheets for Class 11 Informatics Practices My Sql available in multiple languages

Yes, practice worksheets for Class 11 Informatics Practices My Sql are available in multiple languages, including English, Hindi