AISSCE PRACTICAL EXAMINATION 2024-25

SCHOOL CODE:75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII SET:1 Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON
1. To write a Python Program to read a text file "Story.txt" and displays the number of
Vowels/ Consonants/ Lowercase / Uppercase/characters in the file (4)

2. To write a Python program Create a CSV file to store Empno, Name, Salary and search
any Empno and display Name, Salary and if not found display appropriate
message.Table:Emp (4)

SECTION B: MYSQL
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01-10 120
2 Ankit M 21 History 1998-01-24 200
3 Anu F 20 Hindi 1996-12-12 300
4 Bala M 19 NULL 1999-07-01 400
5 Charan M 18 Hindi 1997-09-05 250
6 Deepa F 19 History 1997-06-27 300
7 Dinesh M 22 Computer 1997-02-25 210
8 Usha F 23 NULL 1997-07-31 200
a) Write a query to Rollno, Name and Department of the students from STU table
b) Write a Query to select distinct Department from STU table.
c) Write a Query to list name of female students in Hindi Department.
d) Write a Query to list name of the students whose ages are between 18 to 20.
(4)

3. Report File 7
4. Project (5+3)
5. Viva voice 3
 AISSCE PRACTICAL EXAMINATION 2024-25
SCHOOL CODE:75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII SET:2 Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON
1. To write a menu driven Python Program to find Factorial and sum of list of numbers
using function. (4)
2. To write a Python Program to Create a binary file with roll number and name. Search for
a given roll number and display the name, if not found display appropriate message. (4)

SECTION B: MYSQL
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01- 120
10
2 Ankit M 21 History 1998-01- 200
24
3 Anu F 20 Hindi 1996-12- 300
12
4 Bala M 19 NULL 1999-07- 400
01
5 Charan M 18 Hindi 1997-09- 250
05
6 Deepa F 19 History 1997-06- 300
27
7 Dinesh M 22 Computer 1997-02- 210
25
8 Usha F 23 NULL 1997-07- 200
31

a) Write a query to Display Rollno, Name and Department of the students from STU table
b) Write a Query to select distinct Department from STU table.
c) Write a Query to Delete Age Column from the table STU.
d) Write a Query to Display Name of all students whose DEPT Contains NULL.
(4)

1. Report File 7
2. Project (5+3)
3. Viva voce 3
 AISSCE PRACTICAL EXAMINATION 2024-25
SCHOOL CODE:75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII SET:3 Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON
1. To write a menu driven Python Program to perform Arithmetic operations (+,-*,/) based on the
user’s choice using function. (4)
2. To write a Python program to implement Stack using a list data-structure, to perform the
following operations:
(i) To Push an object containing Doc_ID and Doc_name of doctors who specialize in "ENT"
to the stack.
(ii) To Pop the objects from the stack and display them.
(iii) To display the elements of the stack (after performing PUSH or POP). (4)

SECTION B: MYSQL
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01-10 120
2 Ankit M 21 History 1998-01-24 200
3 Anu F 20 Hindi 1996-12-12 300
4 Bala M 19 NULL 1999-07-01 400
5 Charan M 18 Hindi 1997-09-05 250
6 Deepa F 19 History 1997-06-27 300
7 Dinesh M 22 Computer 1997-02-25 210
8 Usha F 23 NULL 1997-07-31 200

a) Write a query to list the names of those students whose name have second alphabet 'n' in their names.
b) Write a Query to add a new column Area of type varchar in table STU.
c) Write a Query to Display Name of all students whose Area Contains NULL
d) Write a Query to change the fess of Student to 170 whose Roll number is 1, if the existing fess is less than
130.. (4)

3. Report File 7
4. Project (5+3)
5. Viva voice 3
 AISSCE PRACTICAL EXAMINATION 2024-25
SCHOOL CODE:75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII SET:4 Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON
1. To write a Python Program to read a text file "Story.txt" and displays the number of Vowels/
Consonants/ Lowercase / Uppercase/characters in the file (4)
2. To write a Python Program to Create a binary file with roll number, name, mark and update/modify the
mark for a given roll number (4)

SECTION B: MYSQL
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01- 120
10
2 Ankit M 21 History 1998-01- 200
24
3 Anu F 20 Hindi 1996-12- 300
12
4 Bala M 19 NULL 1999-07- 400
01
5 Charan M 18 Hindi 1997-09- 250
05
6 Deepa F 19 History 1997-06- 300
27
7 Dinesh M 22 Computer 1997-02- 210
25
8 Usha F 23 NULL 1997-07- 200
31

a) Write a query to list the names of those students whose name have second alphabet 'n' in their names.
b)| Write a Query to add a new column Area of type varchar in table STU.
c) Write a Query to list name of female students in Hindi Department.
d) Write a Query to change the fess of Student to 170 whose Roll number is 1, if the existing fess is less than
130.. (4)

3. Report File 7
4. Project (5+3)
5. Viva voice 3
 AISSCE PRACTICAL EXAMINATION 2024-25
SCHOOL CODE:75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII SET:5 Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON
1. To Write a method Disp() in Python, to read the lines from poem.txt and display those words
which are less than 5 characters. (4)
2. To write a Python Program to Create a binary file with roll number, name, mark and
update/modify the mark for a given roll number. (4)

SECTION B: MYSQL
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01-10 120
2 Ankit M 21 History 1998-01-24 200
3 Anu F 20 Hindi 1996-12-12 300
4 Bala M 19 NULL 1999-07-01 400
5 Charan M 18 Hindi 1997-09-05 250
6 Deepa F 19 History 1997-06-27 300
7 Dinesh M 22 Computer 1997-02-25 210
8 Usha F 23 NULL 1997-07-31 200

a) Write a query to list the names of those students whose name have second alphabet 'n' in their names.
b) Write a Query to add a new column Area of type varchar in table STU.
c) Write a Query to display the name of the students whose name is starting with 'A'.
d) Write a Query to change the fess of Student to 170 whose Roll number is 1, if the existing fess is less than
130.. (4)

3. Report File 7
4. Project (5+3)
5. Viva voice 3
 AISSCE PRACTICAL EXAMINATION 2024-25
SCHOOL CODE:75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII SET:6 Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON
1. To Write a method Disp() in Python, to read the lines from poem.txt and display those words which
are less than 5 characters. (4)
2. To write a Python program to implement Stack using a list data-structure, to perform the following
operations:
(iii) To Push an object containing Doc_ID and Doc_name of doctors who specialize in "ENT" to the
stack.
(iv) To Pop the objects from the stack and display them.

(iii) To display the elements of the stack (after performing PUSH or POP). (4)
SECTION B: MYSQL
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01- 120
10
2 Ankit M 21 History 1998-01- 200
24
3 Anu F 20 Hindi 1996-12- 300
12
4 Bala M 19 NULL 1999-07- 400
01
5 Charan M 18 Hindi 1997-09- 250
05
6 Deepa F 19 History 1997-06- 300
27
7 Dinesh M 22 Computer 1997-02- 210
25
8 Usha F 23 NULL 1997-07- 200
31

a) Write a query to list the names of those students whose name have second alphabet 'n' in their names.
b) Write a Query to display the name of the students whose name is starting with 'A'.

c)Write a Query to Display Name of all students whose DEPT Contains NULL
d)Write a Query to insert a row of above table :”9,'Sunil','M', 24,'COMPUTER','1997-10-10', 320”. (4)

b) Report File 7
c) Project (5+3)
d) Viva voice 3
 AISSCE PRACTICAL EXAMINATION 2024-25
SCHOOL CODE: 75512
SUBJECT: COMPUTER SCIENCE (083)
Class: XII Time:3 Hours
Date: 30 .01.2025 Marks:30
SECTION A :PYTHON (4x2=8)
1. To write a Python Program to read a text file "Story.txt" and displays the number of Vowels/
Consonants/ Lowercase / Uppercase/characters in the file

2. To write a Python program Create a CSV file to store Empno, Name, Salary and search any Empno
and display Name, Salary and if not found display appropriate message.Table:Emp

3. To write a menu driven Python Program to find Factorial and Sum of list of numbers using function

4. To write a Python Program to Create a binary file with roll number and name. Search for

a given roll number and display the name, if not found display appropriate message.

5. To write a menu driven Python Program to perform Arithmetic operations (+,-*,/) based on the
user’s choice using function.

6.To write a Python program to implement Stack using a list data-structure, to perform the following
operations:

(i) To Push an object containing Doc_ID and Doc_name of doctors who specialize in "ENT"
to the stack.

(ii) To Pop the objects from the stack and display them.

(iii) To display the elements of the stack (after performing PUSH or POP).

7.To write a Python Program to Create a binary file with roll number, name, mark and update/modify
the mark for a given roll number.

8. To Write a method Disp() in Python, to read the lines from poem.txt and display those words which
are less than 5 characters.
 SECTION B: MYSQL (4x1=4)
TABLE:STU

ROLLNO NAME GENDER AGE DEPT DOA FEES

1 Arun M 24 Computer 1997-01-10 120
2 Ankit M 21 History 1998-01-24 200
3 Anu F 20 Hindi 1996-12-12 300
4 Bala M 19 NULL 1999-07-01 400
5 Charan M 18 Hindi 1997-09-05 250
6 Deepa F 19 History 1997-06-27 300
7 Dinesh M 22 Computer 1997-02-25 210
8 Usha F 23 NULL 1997-07-31 200
a) Write a query to Display Rollno, Name and Department of the students from STU table
b) Write a Query to select Distinct Department from STU table.
c) Write a Query to list name of female students in Hindi Department.
d) Write a Query to list name of the students whose ages are between 18 to 20.
e) Write a Query to delete Area Column from the table STU.
f) Write a Query to Display Name of all students whose Area Contains NULL.
g) Write a query to list the names of those students whose name have second
alphabet 'n' in their names.
h) Write a Query to Add a new column Area of type varchar in table STU.
i) Write a Query to display the name of the students whose name is starting with 'A'.
j) Write a Query to change the fess of Student to 170 whose Roll number is 1, if the existing fess
is less than 130..
k) Write a query to list the names of those students whose name have second alphabet 'n' in their
names
l)Write a Query to insert a row of above table :”9,'Sunil','M', 24,'COMPUTER','1997-10-10',
320”.

 Report File 7
 Project (5+3)
 Viva voice 3