CGVA/CS/PRACTICAL2024_25
CHOPRAJHAR GREEN VALLEY ACADEMY
PRACTICAL QUESTIONS
CLASS – XII (CS)
TOPIC- SQL
1. CREATE a database School.
2. Write a command to use the database School.
3. Create a table student with the following specification.(Write the SQL command)
Column Name Data type
Adm_No Char(5)
S_Name Varchar(30)
Class Int
Sec Char
Adress Varchar(50)
4. Write a SQL command to describe Student table.
5. Write a SQL command to ADD a Primary key to Adm_no column.
6. Write a SQL command to ADD a new column MARKS Int(5).
7. Write a SQL command to Insert any 10 records into the Student table.
8. Write a SQL command to display the content of the Student table.
9. Write a SQL command to display the unique Adm_no.
10. Write a SQL command to display student name,Class,Marks where classes are 11 & 12.
11. Write a SQL command to display the details of all the students in descending order to their
class.
12. Write a SQL command to to display Student name, Class, Section and Marks of those
students whose name starts with ‘M’.
13. Write a SQL command to display Student name, Class, Section and Marks of those students
whose name ends with ‘A’
14. Write a SQL command to display the student details of those students whose name
contains 'sc' as substring in name.
15. Write a SQL command to claculate average marks.
16. Write a SQL command to Count number of record present in table Student.
17. Create a table Sports with the following specification.(Write the SQL command)
Column Name Data type
Sno Char(5)
Adm_no Char(5)
Class Int
Section char
Coach_name Varchar(30)
BY INDRANIL ROY (PGT-CS)
CGVA/CS/PRACTICAL2024_25
Sports_name Varchar(10)
18. Add Primary key to Sno attribute in the table Sports.
19. Add Foreign key to Adm_no in the table Sports.
20. Write a SQL command to Studnt name,coach name and Sport name where the coach name
is “S.Khan”.
21. Write a SQL command to diplay the student name,class and section where the sports is
Cricket.
22. Write a SQL command to delete a column.
23. Write a SQL command to remove primary key.
24. Write a SQL command to delete a table.
BY INDRANIL ROY (PGT-CS)
