Anjeev Singh Academy

Anjeev Singh Academy

CBSE XII Computer Science 083 Practical Question Paper Set 5 – Download in Word

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

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

Are you looking for Answer Key? Please Scroll to the Down 👇

Answer Key of Set 5 Practical Examination Question Paper

Answer Key Set – 5

Q1. LAB TEST                                                                                                                       [8+4=12]

  A. 1) Write a function in Python that counts the number of words which does not have vowel character present in a text file “STORY.TXT”   


#Creating a Text File - story.txt
fout = open("story.txt", 'w')
fout.write("Hello Hw are You\n")
fout.write("I am fine\n")
fout.write("Thank y \n")

#Method – 1

# Solution of Que A. 1
#Method - 1
fin = open("story.txt", "r")
count = 0
text =
for word in text.split():
        found = True
        for ch in word:
            if ch in 'aeiouAEIOU':
                found = False
        if found == True:
            count += 1

print("Number of words not having vowel is/are : ", count)

#Method – 2

#Method - 2
fin = open("story.txt", "r")

line = ' '
count = 0
while line:
    line = fin.readline()
    for word in line.split():
        found = True
        for ch in word:
            if ch in 'aeiouAEIOU':
                found = False
        if found == True:
            count += 1
print("Number of words not having vowel is/are : ", count)


            Number of words not having vowel is/are :  2

2)   Write function AddDrug() to write the Records of Drug(DrugId, Name, Price) in a binary file name “drug.dat”, and Write a function Display() to show those records from a binary which price is less than 50.


#Que No A 2 - Binary File

import pickle

def AddDrug():
    fout = open("drug.dat", "wb")           # opening of file
    while True:
        rec = {}
        did = int(input("Enter Drug Id : "))
        name = input("Enter Drug Name : ")
        price = float(input("Enter Drug Price : "))

        rec['did'] = did
        rec['name'] = name
        rec['price'] = price

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

        choice = input("Want to add more y/n :")
        if choice.lower() != 'y':

def Display():
    fin = open("drug.dat", "rb")
        while True:    # loop is required to read all records
            rec = pickle.load(fin)# read only one record
                                  # at a time refered by fin file object
            if rec['price'] < 50:

#Always call function after writing all functions



Enter Drug Id : 101

Enter Drug Name : Paracetamol 500mg

Enter Drug Price : 25.00

Want to add more y/n :y

Enter Drug Id : 102

Enter Drug Name : Becosule

Enter Drug Price : 12.00

Want to add more y/n :y

Enter Drug Id : 103

Enter Drug Name : Amoxyceline

Enter Drug Price : 150.00

Want to add more y/n :y

Enter Drug Id : 104

Enter Drug Name : Betonovat

Enter Drug Price : 65.00

Want to add more y/n :y

Enter Drug Id : 105

Enter Drug Name : SavlonSticker

Enter Drug Price : 35.00

Want to add more y/n :n

{‘did’: 101, ‘name’: ‘Paracetamol 500mg’, ‘price’: 25.0}

{‘did’: 102, ‘name’: ‘Becosule’, ‘price’: 12.0}

{‘did’: 105, ‘name’: ‘SavlonSticker’, ‘price’: 35.0}


A list contains following record of a student: [StudentName, Class, Section, MobileNumber]

Write the following user defined functions to perform given operations on the stack named XII_A:

(i)   pushElement() – To Push an object containing name and mobile number of students who belong to class xii and section ‘a’ to the stack

(ii)  popElement() – To Pop the objects from the stack and display them. Also, display “Stack Empty” when there are no elements in the stack.

If the lists of students details are:

[“Rajveer”, “99999999999”,”XI”, “B”]         [“Swatantra”, “8888888888”,”XII”, “A”]

[“Sajal”,”77777777777”,”VIII”,”A”]            [“Yash”, “1010101010”,”XII”,”A”]

The stack XII_A should contain

[“Swatantra”, “8888888888”  ]                       [“Yash”, “1010101010”]

The output should be:

[“Yash”, “1010101010”]      [“Swatantra”, “8888888888”]    Emtpy Stack


#Que No A 2 - OR (STACK)
students = [
        ["Rajveer", "99999999999","XI", "B"],
        ["Swatantra", "8888888888","XII", "A"],
        ["Yash", "1010101010","XII","A"] ]

XII_A = []
def pushElement():
        for st in students:
                if st[2] == 'XII' and st[3] == 'A':
                        rec = [st[0], st[1]]

def popElement():
        for i in range(len(XII_A)+1):
                if XII_A == []:
                        print("Empty Stack")
                        st = XII_A.pop()

#__ main block ___
print("PUSHING Students\n")

#to invoke pop for six times


PUSHING Students

POPPING Student of Class XII A

[‘Yash’, ‘1010101010’, ‘XII’, ‘A’]

[‘Swatantra’, ‘8888888888’, ‘XII’, ‘A’]

Empty Stack

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

import  mysql.connector as sqltor  		
mycon = sqltor.connect( ___________________ ) 	#Statement 1
cursor = mycon.cursor( )
cursor.execute(______________________ )  			#Statement 2
data = _________________  						                        #Statement 3
for rec in data:
     print ( rec )
      _____________________						                    #Statement 4
 mycon.close( )


a. Complete the Statement 1 to write appropriate missing parameter and values. [ User Id is root and Password is Root123]
b. Write the Statement 2, to fetch drugName, and price from table Drug in descending order of price. c. Complete the Statement 3, to fetch only three records from the resultset.
d. What statement you will write in place of statement #2 to insert one more record in table Drug, as well as in statement #4, to make your changes permanent in the table Drug.


import  mysql.connector as sqltor                  

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

 (b) cursor.execute(SELECT drugName, Price FROM STUDENT ORDER BY Price DESC)                                                                           # Statement 2

(c)  data = cursor.fetchmany(3)          # Statement 3

(d) #Statement 2

cursor.execute(“INSERT INTO DRUG VALUES (105, “Becosule”, 25.00, “A K Pharma”, “New Delhi” ) ”)

# Statement 4 mycon.commit()                      

Sorry! You cannot copy content of this page. Please contact, in case you want this content.

Scroll to Top