Downloaded from https://www.tutorialaicsip.
com
Senior School Certificate Examination - 2023
Practical Question Paper for 2022-23
Subject: Computer Science(083) Class 12
Time: 3:00 Hours Max. Marks: 30
Q – 1 a) Write a menu drive program to perform following operations into a
binary file shoes.dat. 8
1. Add record
2. Display records
3. Search record
4. Exit
The structure of file content is: [s_id, name, brand, type, price]
b) Observe the following code and fill in the given blanks as directed: 4
import mysql.connector as mycon
cn=mycon.connect(_______________________________________) # Statement 1
cr=cn.___________ # Statemen 2
cust_id=int(input(“Enter ID:”))
cust_name=input(“Enter Customer Name:”)
city=input(“Enter City:”)
ba=float(input(“Enter Bill Amount:”))
mno=input(“Enter Mobile No.:”)
cr.execute(__________________________________________) # Statement 3
cn._____________ # Statement 4
The partial code is given for inserting a record in customer table created in Rajwadi
Store. The customer table is given as following:
CustomerID CustomerName City BillAmt MobileNo
111 Abhishek Ahmedabad 1500 9999999999
i. Write the parameters and values required to fill statement 1. The parameters
values are as follows:
Database Server User Pasword Database
main_rajwadi rajwadi_admin Rajwadi@2023 rajwadi
ii.Write function name to create cursor and fill in the gap for statement 2.
iii. Write a query to fill statement 3 with desired values.
iv. Write a query to fill statement 4 to save the records into table.
Q – 2 Practical Report File 7
Q – 3 Project 8
Q – 4 Viva Voce 3
Page 1 of 2
Downloaded from https://www.tutorialaicsip.com
Follow this link to see the solution of given questions.
Solution Computer Science Practical Paper 2023
Page 2 of 2
