LALA SARKARU MAL SARVHITKA RI SEN.
SEC. VIDYA MANDIR, KHANNA
PRACTICAL FILE
On
MySQL
CLASS – XI
SESSION 2025 – 2026
INFORMATICS PRACTICES (065)
SUBMITTED TO -
Mr. Manoj Kumar
Submitted by
Name – Yashdeep
Roll no. –
Class –
Section –
[Link] Particulars Pg. No
1. To create a database ‘class 11’ in MySQL 1
2. To use a database ‘class 11’ in MySQL 1
3. To create table ‘student’ in MySQL 1
4. To check description of ‘student’ in MySQL 1
5. To insert values into ‘student’ in MySQL 2
6. To check the inserted values in ‘student’ in 2
MySQL to add column;
7. To delete the values from ‘student’ in MySQL 3
8. To update a row in ‘student’ in MySQL 3
9. To select a particular gender from ‘student’ 4
in MySQL
10. To select specific data from ‘student’ where 4
marks > 50 in MySQL
11. To check average marks from ‘student’ in 5
MySQL
12. To add a new column email in ‘student’ in 5
MySQL
13. To update a column email in ‘student’ in 5
MySQL
14. To select like names in ‘student’ in MySQL 6
15. To specific DOB from ‘student’ in MySQL 6
16. To use order by query in ‘student’ in MySQL 7
17. To use order by query in descending order 7
in ‘student’ in MySQL
18. To select distinct section from ‘student’ in 8
MySQL
19. To use Unique Constraint in MySQL 8
20. To insert values in Unique Constraint in 9
MySQL
21. To use Primary Constraint in MySQL 9
22. To delete a table in MySQL 10
23. To update the data in MySQL 10
Question 1: To create a database in MySQL?
Answer:
Question 2 How to use/select a database in MySQL?
Answer:
Question 3 How to create a table in MySQL?
Answer:
Question 4 How to check description of table in
MySQL?
Answer:
1
Question 5 How to insert values into a table?
Answer:
Question 6: How to check inserted values in the table?
Answer :
2
Question 7: How to delete a column from created table?
Answer:
Question 8: How to update a column in a table?
Answer:
3
Question 9: How to select a particular gender/value
from table?
Answer:
Question 10: How to select specific data from table ?
Answer:
4
Question 11: How to select average value of
marks/integer?
Answer:
Question 12: How to add column in a table ?
Answer:
Question 13: How to update a set in a table?
Answer:
5
Question 14: How to select like name from table ?
Answer:
Question 15: How to select specific time period (dob)
from table?
Answer:
6
Question 16: How to select name in dictionary?
Answer:
Question 17: How to order marks (integer value) by
descending order ?
Answer:
7
Question 18: How to select distinct values from table?
Answer:
Question 19: How to use unique constraint in MySQL?
Answer:
8
Question 20: How to add values in unique constraint?
Answer: To insert values into unique constraint that is
ecode here no values should repeat
Question 21: How to delete a specific row in MySQL?
Answer:
9
Question 22: How to delete a table in MySQL
Answer:
Question 23: How to update data in a table ?
Answer:
10