Read and download free pdf of CBSE Class 11 Informatics Practices My Sql Worksheet Set D. 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
Lab Work Sheet
Type and execute SQL commands to do the following :
1. Create a table STUDENT with the following fields :
Rollno (int), Name (varchar(20)), Gender (char(1)) and Marks (Decimal(4,1))
2. Add the following rows to the table
3. Display the structure of the table
4. Display all tables in the database
5. Display the result of the expression 7+8/3
6. Display details of the male students who have secured less than 90.
7. Display all the details in descending order of marks and in ascending order of Name.
8. Add a new column Grade (char(1)) to the table.
9. Set the Grade as ‘A’ for those students whose mark is above 90.
10. Display the names of the students who do not have a grade.
11. Delete the students whose mark is below 80.
12. Change name to “Anitha” and marks to 89.0 of the student whose roll number is 2.
13. Modify the data type of column Name to varchar(30)
14. Delete the column Grade.
15. Display roll number, name and marks of the students whose roll number is 2 and 4
16. Display name and marks-3 for all students.
17. Display the student details in the following format Deepa ‘has secured’ 86.5
18. Display names of the students having five letters and ending with ‘a’
19. Add a new row with Rollno =10 , name=’Shakthi’ and Gender=’M’
20. Display names of the students whose marks are entered in the table.
21. Create a table BOYS which will have name and marks of all the boys from STUDENT table.
22. Display the contents of BOYS table.
23. Add a PRIMARY KEY data constraint on the column Name.
24. Change Name column in BOYS table to B_NAME.
Please click on below link to download CBSE Class 11 Informatics Practices My Sql Worksheet Set D
My Sql CBSE Class 11 Informatics Practices 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. Teachers of studiestoday have referred to the NCERT book for Class 11 Informatics Practices to develop the Informatics Practices Class 11 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 11 Informatics Practices designed by our teachers. After solving these you should also refer to Class 11 Informatics Practices MCQ Test for the same chapter. 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.
You can download the CBSE Practice worksheets for Class 11 Informatics Practices My Sql for the latest session from StudiesToday.com
Yes, the Practice worksheets issued for My Sql Class 11 Informatics Practices have been made available here for the latest academic session
There is no charge for the Practice worksheets for Class 11 CBSE Informatics Practices My Sql you can download everything free
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
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