SENIOR SECONDARY CERTIFICATE EXAMINATION (SSCE)- 2025

DATE: 06/01/2026 SUBJECT: Computer Science

DAY: TUESDAY SUBJECT CODE: 083
DURATION: 3 hrs
Distribution of Marks:
Programming in Python : 8M
SQL commands : 4M
Project Work : 8M
Practical File : 7M
Viva : 3M
PYTHON PROGRAMS
1. Write a menu driven python program using user defined function to take a number
as input and :
i) find the factorial of the number
ii) to check the given is a prime number
iii) exit

2. Write a menu driven python program using user defined function to take a string
as input and :
i) to check whether the given string is Palindrome
ii) to check a character and print whether the given character is the alphabet, digit or
any other character.
iii) exit
3. Write a python program to
a) create a text file ‘[Link]’ and enter the data.
b) read the above file and display the no. of vowels, consonants , uppercase and
lowercase character in the file.
Example: If the file content is as follows:
An apple a day keeps the doctor away.
We all pray for everyone’s safety.
A marked difference will come in our country.
4. Write a python program to
a) create a text file “[Link]” and enter the data.
b) read the above file line by line and display each words separated by #.
For example, If the file contents are as follows:
Whose woods these are I think I know.
His house is in the village though;
5. Write a Program in Python that defines and calls the following user defined
functions:
(i) add() – To accept and add data of an employee to a CSV file ‘[Link]’. Each
record consists of a list with field
elements as fid, fname and fprice to store furniture id, furniture name and furniture
price respectively.
(ii) search()- To display the records of the furniture whose price is more than 10000.

6. A binary file “[Link]” has structure [BookNo, Book_Name, Author, Price].

i. Write a user defined function CreateFile() to input data for a record and add to
[Link] .
ii. Write a function CountRec(Author) in Python which accepts the Author name as
parameter and count and return number of books by the given Author are stored in
the binary file “[Link]”

7. Alam has a list containing 10 integers. You need to help him create a program
with separate user defined functions to perform the following operations based on
this list.
i) Traverse the content of the list and push the even numbers into a stack.
ii)Pop and display the content of the stack.
For Example: If the sample Content of the list is as follows: N=[12, 13, 34, 56, 21,
79, 98, 22, 35, 38]
Sample Output of the code should be: 38 22 98 56 34 12

8. A binary file "[Link]" has structure [Pno, P_Name, Quantity, Price]

i. Write a user defined function CreateFile() to input data for a record and add to
Product. dat.
ii. Write a function DispRec () in Python to display only those product records whose
quantities are more than 100 from the binary file "[Link]"

9. Ragav wants to write a program in Python to insert the following record

in the table named Student in MYSQL database, SCHOOL:
● rno(Roll number )- integer

● name(Name) - string

● DOB (Date of birth) – Date

● Fee – float
Note the following to establish connectivity between Python and
MySQL:
▪ Username - root

▪ Password - tiger

▪ Host - localhost
The values of fields rno, name, DOB and fee has to be accepted from
the user. Help Ragav to write the program in Python.

10. Sartaj has created a table named Student in MYSQL database,

SCHOOL:
● rno(Roll number )- integer

● name(Name) - string

● DOB (Date of birth) – Date

● Fee – float
Note the following to establish connectivity between Python and
MySQL:
▪ Username - root

▪ Password - tiger

▪ Host - localhost
Sartaj, now wants to display the records of students whose fee is more than 5000.
Help Sartaj to write the program in Python.

SQL - Queries
SET - 1
Table – Books
BId BName AName Publ Price Type Qty
F0001 C++ Sumitha First 700 Program 10
F0002 Tears Williams First 750 Fiction 5
T0002 My First C++ Brain EPB 250 Text 10
T0001 Brain Works A.W. Rossaine TDM 325 Text 5
C0001 Fast Cook Latha EPB 350 Cookery 8

Table - Bkissued
BId Qty_Iss
F0001 3
T0001 1
C0001 5

Consider the relations name Books and Bkissued and write the queries :

i. To show book name, author name and price of books of EPB publisher .
ii. To display the names and price of books in descending order of price
iii. To increase the price of of all of first publisher by 100
iv. To display the BName and qty_issued for all the books which have been issued
 SET - 2

Table - Stocks

Ino Item Dcode Qty UPrice

5005 Pen 102 100 16
5003 Pencil 102 150 10
5009 Eraser 105 60 10
5004 Sharpener 103 100 8

Table – seller

Dcode Dname
102 Camlin
103 Classic
105 King

Consider the following table stocks and seller. write sql commands .
i. To display details of all items in the stock table in descending order of quantity
ii. To display item, ino of those items from stocks whose unit prices more than 9
iii. To display the details of those items whose sellercode is 102 or quantity in
stock is more than 100 from the table stock
iv. Update Uprice by 10 for those record where item is sharpener .
 SET - 3
Table - Client
C_ID ClientName City P_ID
1 Cosmetic Shop Delhi FW05
6 Total Health Mumbai BS01
12 Live Life Delhi SH06
15 Pretty Woman Delhi FW12
16 Dreams Bangalore TP01

Table – Product
P_ID ProductName Manufacturer Price
BS01 Bath Soap ABC 55.00
FW0
Face Wash ABC 45.00
5
FW1
Face Wash XYZ 95.00
2
120.0
SH06 Shampoo XYZ
0
TP01 Talcum Powder LAK 40.00
Write SQL commands for the tables product and client .
i. to display the details of those clients whose city is Delhi
ii. to display the details of those clients the clientname, City from table client and
productname and price from table product, with their corresponding
matching PID
iii. remove the record whose manufacturer is 'LAK'
iv. to display the ProductName and the price multiplied by 4, with the resulting
column labeled as Adjusted_Price.

SET - 4
TABLE - Stationary
S_ID Stationary Name Company Price
DP01 Dot Pen ABC 10
PL02 Pencil XYZ 6
ER05 Eraser XYZ 7
PL01 Pencil CAM 5
GP02 Gel Pen ABC 15

TABLE – Consumer
C_ID ConsumerName Address S_ID
1 Good Learner Delhi PI01
6 Write Well Mumbai GP02
12 Topper Delhi DP01
15 Write & Draw Delhi PL02
16 Motivation Bangalore PL01

Consider the relations Stationary and Consumer and write the queries :
 i. To display the details of those consumer whose address is delhi.
ii. To display the details of stationary whose price is in the range of 8 to 15 (both
values included).
iii. To increase the price of all stationary by 2.

iv. To display distinct company from stationary.

SET – 5
TABLE – DOCTOR

ID Name Dept Sex Experience

101 John ENT M 15

104 Smith ENT M 12

107 George SKIN M 3

109 K. George CARDIOLOGY F 10

TABLE – SALARY

ID Basic Allowance Consultation

101 42000 12000 1000

104 32000 2300 300

107 23000 4000 500

109 42000 5200 200

Consider the relations DOCTOR and SALARY and write the queries :
 i. Display Name from the table Doctor and Basic, Allowance from the table
Salary with their corresponding matching ID.
ii. To display distinct Department from the table Doctor.
iii. To display Name of all doctors who are in "ENT" having more than 10 years of
experience from the table Doctor.
iv. Display the minimum Allowance of female doctors.

INTERNAL EXAMINER EXTERNAL EXAMINER