Scribd
Upload
10 views2 pages

Practical Question Paper

The document outlines the practical examination for Grade XII in Computer Science at PAI Public School & Jr. College for the academic year 2023-24. It includes two sets of questions focusing on programming tasks related to file handling and SQL queries involving mobile and faculty databases. Each set consists of programming exercises and SQL table creation with specific queries to be solved.

Uploaded by

Useram Shaikh
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
10 views2 pages

Practical Question Paper

The document outlines the practical examination for Grade XII in Computer Science at PAI Public School & Jr. College for the academic year 2023-24. It includes two sets of questions focusing on programming tasks related to file handling and SQL queries involving mobile and faculty databases. Each set consists of programming exercises and SQL table creation with specific queries to be solved.

Uploaded by

Useram Shaikh
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

M.C.

E Society’s
PAI PUBLIC SCHOOL & Jr. College
Practical Examination 2023-24

Grade: XII Time Allotted: 3 hours


Subject: COMPUTER SCIENCE Marks: 30
Name: ________________________________________ Roll No.__________
Date: 16/01/2024
SET - A
Q.1) a) Program to read and display those lines from file that start with alphabet ‘T’.
b) Program to pass a list as function argument and modify it. (8)

Q.2) Create SQL Table and solve given queries of the table. (4)
Mobile Master

M_ID M_Company M_Name M_Price M_Mf_Date


MB001 Samsung Galaxy 4500 2013-02-12
MB003 Nokia N1100 2250 2011-04-15
MB004 Micromax Unite3 4500 2016-10-17
MB005 Sony XperiaM 7500 2017-11-20
MB006 Oppo SelfieEx 8500 2010-08-21

Mobile Stock

S_ID M_ID M_QTY M_SUPPLIER


S001 MB004 450 New Vision
S002 MB003 250 Praveen Gallery
S003 MB001 300 Classic Mobile Store
S004 MB006 150 A-ONE MOBILE
S005 MB003 150 The Mobile
S006 MB006 50 Mobile Centre

Queries:
i) Display the mobile company, mobile name & price in descending order of their
manufacturing date:
ii) List the details of mobile whose name starts with “S”.
iii) Display the mobile supplier & quantity of all mobiles except MB003.
iv) Display the m_company and m_name along with m_supplier.
M.C.E Society’s
PAI PUBLIC SCHOOL & Jr. College
Practical Examination 2023-24

Grade: XII Time Allotted: 3 hours


Subject: COMPUTER SCIENCE Marks: 30
Name: ________________________________________ Roll No.__________
Date: 16/01/2024
SET - B
Q.1) a) Program to write rollno, name and marks of a student in a data file Marks.dat.
b) Program to read and display those lines from file that end with alphabet ‘n ‘. (8)

Q.2) Create SQL Table and solve given queries of the table. (4)
Faculty

F_ID F_Name L_Name Hire_Date Salary


102 Amit Mishra 12-10-1998 12000
103 Nitin Vyas 24-12-1994 8000
104 Rakshit Soni 15-05-1994 14000
105 Rashmi Malhotra 11-9-2004 11000
106 Sulekha Srivastva 05-06-2006 10000

Courses

C_ID F_ID C_Name Fees


C21 102 Grid Computing 40000
C22 106 System Design 16000
C23 104 Computer Security 8000
C24 106 Human Biology 15000
C25 102 Computer Network 20000
C26 105 Visual Basic 6000

Queries:
i) To display details of those faculties whose salary is grater than 12000.
ii) To display details of courses whose fees is in the range of 15000 to 50000 (both values
included).
iii) To increase the fees of all courses by 500 of system design course.
iv) Display the f_name, c_name along with their fees.

You might also like