PRACTICAL EXAMINATION AISSCE 2024
COMPUTER SCIENCE (083)
Set A
Date : 17.01.2024 (Wednesday) CBSE Roll No : ____________
Max. Marks: 30 Time: 3:00 Hours
Q1. Lab Test – Python Program: 08 marks
Write a program in Python to Open a text file name "Study.txt" and write few lines of
string in it and then write code to count the occurrence of word “and” or “my”
Me and my friend and his father went to market.
Q2. MySQL Query : 04 marks
Create Database CBSE24 and Create following table inside newly created database.
Consider the table given below and answer the following questions :
TABLE: EMPLOYEE
Ecod
eName Salary Zone Age Grade Dept
e
101 Mukul 30000 West 28 A 11
102 Kritika 35000 Centre 51 A 22
103 Naveen 32000 East 40 NULL 11
105 Uday 38000 North 38 C 33
107 Nupur 32000 East 26 NULL 11
TABLE: DEPARTMENT
Dept Dname Entitlement
11 Sales Taxi
22 Store Air
33 Finance Car
Write the Query for the following:
1. Display the details of all the employees who are getting a salary of less than 33000.
2. Display the sum of salary of Grade ‘B’ employees.
3. Display the employee name, age and zone of employees in the ascending order of their
age of East department
4. Display Employee Code, Employee Name and Department Name for all employees
Q4) Practical File: 07 marks
Q5) Project work: 08 marks
Q6) Viva-voce: 03 marks
(Manish Kumar Gupta)
Internal External
EXAM CENTER : KENDRIYA VIDYALAYA NO. 2 SAGAR MP
AISSCE PRACTICAL EXAMINATION 2024
COMPUTER SCIENCE (083)
Set B
Date : 17.01.2024 (Wednesday) CBSE Roll No : ____________
Max. Marks: 30 Time: 3:00 Hours
Q1. Lab Test – Python Program: 08 marks
Write a program in Python to create stack name “employee” having employee code and
name of 03 employees. Then Insert the details of one more employee to the stack. (PUSH
Operation).
Consider employee code 101,102,103 and name as Kamal, Rajesh and Kush
Q2. MySQL Query : 04 marks
Create Database CBSE24 and Create following table inside newly created database.
Consider the table given below and answer the following questions :
TABLE: STUDENT
Enro Grade
SName Fee House Class Scode
l
101 Nanda 5000 Green 11 A S11
102 Saurabh 3000 Blue 12 B S33
103 Kamal 3000 Green 12 Null S33
105 Praveen 2500 Red 11 C S11
107 Arvind 4500 Blue 12 NULL S22
TABLE: STREAM
Scode Sname Chapters
S11 Science 15
S22 Commerce 11
S33 Humanities 12
Write the Query for the following:
1. Display the details of all the students who are paying fee less than 3000.
2. Display the sum of fee of Class 11 students.
3. Display the student name, class, fee and House of students in the ascending order of their
fee of Blue department
4. Display Student Enrolment no, Student Name and Stream Name for all students
Q4) Practical File: 07 marks
Q5) Project work: 08 marks
Q6) Viva-voce: 03 marks
(Manish Kumar Gupta)
Internal External
EXAM CENTER : KENDRIYA VIDYALAYA NO. 2 SAGAR MP
AISSCE PRACTICAL EXAMINATION 2024
COMPUTER SCIENCE (083)
Set C
Date : 17.01.2024 (Wednesday) CBSE Roll No : ____________
Max. Marks: 30 Time: 3:00 Hours
Q1. Lab Test – Python Program: 08 marks
Write a program in Python to create stack name “employee” having employee code and
name of 03 employees. Then remove the details of one employee from the stack. (POP
Operation)
Consider employee code 101,102,103 and name as Kamal, Rajesh and Kush
Q2. MySQL Query : 04 marks
Create Database CBSE24 and Create following table inside newly created database.
Consider the table given below and answer the following questions :
TABLE: STUDENT
Enro Grade
SName Fee House Class Scode
l
101 Nanda 5000 Green 11 A S11
102 Saurabh 3000 Blue 12 B S33
103 Kamal 3000 Green 12 Null S33
105 Praveen 2500 Red 11 C S11
107 Arvind 4500 Green 12 NULL S22
TABLE: STREAM
Scode Sname Chapters
S11 Science 15
S22 Commerce 11
S33 Humanities 12
Write the Query for the following:
1. Display the details of all the students who are paying fee more than 3000.
2. Display the sum of fee of Class 12 students.
3. Display the student name, class, fee and House of students in the ascending order of their
fee of Green department
4. Display Student Enrolment no, Student Name and Stream Name for all students
Q4) Practical File: 07 marks
Q5) Project work: 08 marks
Q6) Viva-voce: 03 marks
(Manish Kumar Gupta)
Internal External
EXAM CENTER : KENDRIYA VIDYALAYA NO. 2 SAGAR MP
