Scribd
Upload
3 views1 page

AISSCE Class 12 Computer Science Exam 2025

The document outlines the practical examination for Computer Science (Code 083) for Class XII for the academic year 2025-2026, with a total time of 3 hours and a maximum mark of 30. It includes various tasks such as writing Python functions to handle email extraction and sales record management, as well as SQL commands for data manipulation based on a CLUB table. Additionally, it specifies sections for a practical file, project, and viva assessment.

Uploaded by

gagan.batra
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views1 page

AISSCE Class 12 Computer Science Exam 2025

The document outlines the practical examination for Computer Science (Code 083) for Class XII for the academic year 2025-2026, with a total time of 3 hours and a maximum mark of 30. It includes various tasks such as writing Python functions to handle email extraction and sales record management, as well as SQL commands for data manipulation based on a CLUB table. Additionally, it specifies sections for a practical file, project, and viva assessment.

Uploaded by

gagan.batra
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

AISSCE PRACTICAL EXAMINATION

COMPUTER SCIENCE-083
2025-2026
CLASS-XII
SET-B
TIME-3 HRS M.M-30

LAB TEST(Use appropriate comments/documentation in Python Programming)

Q1. Write a Python function that displays all the words containing @cmail from a text file
"[Link]". 3
Q2. . Raj is the manager of a medical store. To keep track of sales records, he has created a CSV file
named [Link], which stores the details of each sale. The columns of the CSV file are:
Product_ID Product_Name , Quantity_Sold Price_Per_Unit.
Help him to efficiently maintain the data by creating the following user-defined functions:
I. Accept() – to accept a sales record from the user and add it to the file [Link].
II. CalculateTotalSales() – to calculate and return the total sales based on the Quantity_Sold
and Price_Per_Unit. 5
Q3. Write SQL commands for the following on the basis of table STUDENT: 4
Table: CLUB
MNO NAME FEE TYPE DOJ
1001 ARUNA ZAIDI 150000 LIFE 30/JAN/08
1010 AMIT 5000 MONTHLY 12/JUL/05
1015 SUMIT 30000 ANNUAL 23/MAR/15
1003 ADAM 5500 MONTHLY 14/APR/12
1002 JOHN 30000 ANNUAL 15/OCT/12
1012 SMITH 30000 ANNUAL 05/DEC/05
1009 AYUSH 120000 LIFE 01/JAN/05
1008 ADITI 1000 GUEST 16/SEP/16
1014 AABHARIKA 5000 MONTHLY 15/SEP/10

(A) (i) Based on table CLUB, write the SQL query will display earliest and latest DOJ under each
TYPE?
(ii) Based on table CLUB, Write down the SQL statement to display the total Fees under each
TYPE?
(iii) Based on table CLUB, Write down the SQL statement will delete the information of those
members, who are either ANNUAL members or those who are having DOJ on or after
"01-JAN-2010".
(B) On the basis of CLUB table, Give the output of following statements.
(i) SELECT NAME ,FEE FROM CLUB WHERE TYPE=’ANNUAL’ ;
(ii)SELECT AVG(FEE) FROM CLUB WHERE FEE >5000 ;
Q4. PRACTICAL FILE 7
Q5. PROJECT 8
Q6. VIVA 3

You might also like