UNIVERSE PUBLIC SCHOOL
AISSC EXAMINATION SESSION 2025-26
Class XII
Computer Science (083) Practical
Time: 3 Hours. Maximum Marks: 30
General Instructions:
All programs should be written in Python 3.
Use MySQL for database-related questions.
Answer all questions.
Marks are indicated against each question.
Write meaningful variable names and add comments where necessary.
Q1. PROGRAMMING IN PYTHON (10 Marks)
Write a Python program to manage student records using a dictionary.
The program should:
- Accept details of n students (Roll No, Name, Marks).
- Display details of all students.
- Find and display the student(s) who scored maximum marks.
- Allow searching of a student using Roll Number.
Q2. FILE HANDLING (8 Marks)
Create a text file named '[Link]' and write some sample lines into it.
Write a Python program to:
1. Count and display the total number of lines in the file.
2. Count and display the number of words in the file.
3. Display only those lines that start with a vowel.
Q3. DATABASE CONNECTIVITY (MySQL + Python) (8 Marks)
A table EMPLOYEE is stored in a MySQL database COMPANY_DB.
Table Structure:
EID | ENAME | DEPT | SALARY
Write Python code to:
1. Establish connection with MySQL database.
2. Insert two records into the EMPLOYEE table.
3. Display all records where SALARY > 50000.
Q4. VIVA VOCE (4 Marks)