# CBSE XII Computer Science 083 Practical Question Paper Set 2 – Download

AISSCE XII Computer Science 083 – Practical Question Paper Set #2 – Download Word File

All India Senior Secondary Certificate Examination
XII Computer Science 083 – Practical Question Paper Set #2

### Answer Key of Set – 2 Practical Examination Question Paper

ANSWER KEY – SET 2

Q1. LAB TEST                                                                                            [8+4=12]

A. 1) Write a Python Program read a text file line by line and display line started with ‘T’.                       (4)

#Que No – #A 1

#Creating Story.txt file

fout = open(“story.txt”, ‘w’)

fout.write(“Hello How are You\n”)

fout.write(“I am fine\n”)

fout.write(“Thankyou\n”)

fout.write(“This is too much\n”)

fout.write(“What happend\n”)

fout.close()

#Reading line by line and checking

fin = open(“story.txt”, “r”)

line = ‘ ‘

while line:

if line != None and line[0] == ‘T’:

print(line)

fin.close()

Output:

Thankyou
This is too much

### OR

Write a function to WriteRec() to write the 5 Employee Records (id, name, salary) in a binary file name “Emp.dat” and ReadRec() function to read the all records from a binary file “Emp.dat” and display  them.

# Solution of Que A. 1 (OR)

#———————————–

# Binary file

import pickle

def WriteRec():

fout = open(“Emp.dat”, “wb”)           # opening of file

for i in range(5):

rec = []

id = int(input(“Enter Admission Number : “))

name = input(“Enter Name : “)

salary = float(input(“Enter Fee : “))

rec = [id, name, salary]

pickle.dump(rec, fout)        #write one record in a file refered by fout

fout.close()

fin = open(“Emp.dat”, “rb”)

try:

while True:                       # loop is required to read all records

rec = pickle.load(fin)     # read only one record

# at a time referred by fin file object

print(rec[0], rec[1], rec[2])

except:

fin.close()

#Always call function after writing all functions

WriteRec()

Output:

Enter Admission Number : 1

Enter Name : a

Enter Fee : 2500

Enter Admission Number : 2

Enter Name : b

Enter Fee : 1500

Enter Admission Number : 3

Enter Name : c

Enter Fee : 2560

Enter Admission Number : 4

Enter Name : d

Enter Fee : 3500

Enter Admission Number : 5

Enter Name : e

Enter Fee : 5000

1 a 2500.0

2 b 1500.0

3 c 2560.0

4 d 3500.0

5 e 5000.0

2) Write a python program to create a stack of student’s record which contains [admo, name].             (4)

• Write function PUSH to add record in to the stack and
• Write function DISPLAY to display those students whose name is started with ‘A’

# STACK

student = []   #global variable

def PUSH():

name = input(“Enter Name : “)

rec = [admno, name]

student.append(rec)

def DISPLAY():

if student == []:

print(“Empty Stack”)

else:

for st in student:

if st[1][0] == ‘A’:

print(st[0], st[1])

#to invoke push for five times

print(“PUSHING”)

for a in range(5):

PUSH()

print(“DISPLAYING RECORDS”)

DISPLAY()

Output:

PUSHING

Enter Admission No :1

Enter Name : Amit Sharma

Enter Admission No :2

Enter Name : Rajesh Singh

Enter Admission No :3

Enter Name : Anil Thakur

Enter Admission No :4

Enter Name : Yashashvi

Enter Admission No :5

Enter Name : Anju

DISPLAYING RECORDS

1 Amit Sharma

3 Anil Thakur

5 Anju

B.  A table Student is created in the database School. The details of table are given below.                   (4)

import  mysql.connector as sqltor

mycon = sqltor.connect( _______,  user = “root”, _________, database = ___________ )        #1

cursor = mycon.cursor( )

cursor.execute(______________________ )                                                                            #2

data = _________________                                                                                                   #3

for rec in data:

print ( rec )

_____________________                                                                                                      #4

mycon.close( )

a. Complete the statement #1 to write appropriate missing parameter and values.

b. Write the statement #2, to fetch Name, Class, Grade from table Student who have scored less than 400.

c. Complete the statement #3, to fetch all records from the result set.

d. What statement you will write in place of statement #2 to insert one more record in table Student, as well as in statement #4, to make your changes permanent in the table Student.

import  mysql.connector as sqltor

mycon = sqltor.connect( host = “localhost”,  user = “root”, passwd = “root”, database = “School” )    # Statement 1

cursor = mycon.cursor( )

cursor.execute(“SELECT NAME, CLASS, GRADE FROM STUDENT WHERE TOTAL < 400”)                                                                           # Statement 2

data = cursor.fetchall()                                             # Statement 3

for rec in data:

print ( rec )

mycon.close( )

(d) #Statement 2

cursor.execute(“INSERT INTO STUDENT VALUES (“ST/15”, “AMRIT”, “12 D”, 496, “A+”)”)

# Statement 4mycon.commit()