Practical File Informatics Practices Class 11

In this article, I will discuss Practical File Informatics Practices Class 11. This is practical file is strictly prepared as per syllabus of Informatics Practices for session 2023-24. So here we begin!

In CBSE syllabus the suggested MySQL queries will be given, they are as follows:

Suggested MySQL Queries for class 11 IP practicals

1. To create student attendance database and use that database to store different tables.
2. To create STUDENT table.
3. To show names of all tables within STUDENT ATTENDANCE database.
4. To show the structure of STUDENT table.
5. Insert 5 records into STUDENT table.
6. Add primary key to STUDENT table.
7. Change the size of attribute SName varchar(20) to varchar(30)
8. To set default value of SDateofBirth of STUDENT to 10th march 2000.
9. Remove column city from STUDENT table.
10. Remove primary key from STUDENT table.
11. Display name and date of birth of student with roll number 1.
12. Display all details of student except those who are in class 10 or 11.
13. Display details of all students in ascending order of their marks.
14. Display details of all those students whose name starts with ‘S’.
15. Display details of all students whose name ends with ‘i’ and gets a marks more than 75.
16. Display details of all students whose name consists of exactly 7 letters and starts with any letter but has ‘shi’ after that.
17. Display names of all students containing ‘sh’ as substring in a name
18. Display names of all students containing ‘a’ as the second character.
19. Delete the record of student whose roll no is 3.
20. Display the names of student in capital letters.

Additional 20 MySQL queries solved. Click on the link

So let us begin now Practical File Informatics Practices Class 11. I will cover all the queries given above and few more additional queries as per given in the practical structure. So let us start now!

Python Practical Programs for Practical File Informatics Practices Class 11

So let us begin with MySQL queries now.

MySQL queries for Practical File Informatics Practices Class 11

1] To create student attendance database and use that database to store different tables.

3].To show names of all tables within STUDENT ATTENDANCE database.

4] To show the structure of STUDENT table.

5] Insert 5 records into STUDENT table.

6] Add primary key to STUDENT table.

7] Change the size of attribute SName varchar(20) to varchar(30)

8]To set default value of SDateofBirth of STUDENT to 10th march 2000.

9]Remove column city from STUDENT table.

10] Remove primary key from STUDENT table.

11] Display name and date of birth of student with roll number 11.

12] Display all details of student except those who are in class 10 or 11.

13] Display details of all students in ascending order of their marks.

14] Display details of all those students whose name starts with ‘S’.

15] Display details of all students whose name ends with ‘I’ and gets a marks more than 75.

16] Display details of all students whose name consists of exactly 7 letters and starts with any letter but has ‘shi’ after that.

17] Display names of all students containing ‘SH’ as substring in a name

18] Display names of all students containing ‘a’ as the second character.

19] Delete the record of student whose roll no is 3.

20] Display the names of student in Small letters.