क ीय िव ालय संगठन, जयपुर संभाग

Kendriya Vidyalaya Sangathan, Jaipur Region

थम ी-बोड परी ा 2023-24
First Pre-Board Exam 2023-24
क ा/Class: XII िवषय/Subject : Computer Science (083)
समय : 3 घंटे पूणाक/Max Marks: 70

सामा िनदश / General Instructions:

 Please check this question paper contains 35 questions.
 The paper is divided into 5 Sections- A, B, C, D and E.
 Section A, consists of 18 questions (1 to 18). Each question carries 1 Mark.
 Section B, consists of 7 questions (19 to 25). Each question carries 2 Marks.
 Section C, consists of 5 questions (26 to 30). Each question carries 3 Marks.
 Section D, consists of 2 questions (31 to 32). Each question carries 4 Marks.
 Section E, consists of 3 questions (33 to 35). Each question carries 5 Marks.
 All programming questions are to be answered using Python Language only.

खंड / SECTION-A
सं / Question अंक /
Q. No. Marks
1 State True or False: 1
“Lexical unit is the smallest unit of any programming language”

2 Fill in the blank: 1

command is used to remove the tuple from the table in SQL.
(a) update (b) remove
(c) alter (d) delete

3 What will be the output of the following statement: 1

print ((30.0 // 4 + (8 + 3.0))
a. 14.75 b. 18.0
c. -18.0 d. Error

4 Select the correct output of the code: 1

>>> Str= "BHASHA SANGAM @ 75"
>>> S=Str.partition(" ")
>>> print(S)
a. (@ 75' 'BHASHA', ' ', 'SANGAM,)
b. ('BHASHA', ' @', 'SANGAM , 75')
c. ('', ' ', 'BHASHA SANGAM @ 75')
d. ('BHASHA', ' ', 'SANGAM @ 75')

[1]
5 In MYSQL database, if a table, Emp has degree 10 and cardinality 5, and 1
another table, Dept has degree 5 and cardinality 10, what will be the degree
and cardinality of the Cartesian product of Emp and Dept ?
a. 50,15 b. 15,50
c. 50,50 d. 15,15

6 Ankur wants to transfer songs from his mobile phone to his laptop. He uses 1
Bluetooth Technology to connect two devices. Which type of network will be
formed in this case?
a. PAN b. LAN
c. MAN d. WAN
7 Give the output: 1
dic1={‘r’:’red’,’g’:’green’,’b’:’blue’}
for i in dic1:
print (i, end =’ ’)
a. r g b b. R G B
c. R B G d. red green blue
8 Consider the statements given below and then choose the correct output 1
from the given options:
MN="Bharat @G20"
print(MN[-2:2:-2])
Options:
a. rt@2 b. 2@tr

c. @G20 d. 02G@

9 Which of the following statement(s) would give an error after 1

executing the following code?

S="Welcome to KVS RO JAIPUR " # Statement 1

print(S) # Statement 2
S="Thank you" # Statement 3
S[0]= '$' # Statement 4
S=S+"Thank you" # Statement 5

(a) Statement 3
(b) Statement 4
(c) Statement 5
(d) Statement 4 and 5

[2]
10 What possible outputs(s) will be obtained when the following code is 1
executed?
import random
Signal=['Stop','Wait','Go']
for K in range (2,0,-1):
R=random.randrange(K)
print(Signal[R], end='#')
options:
a. Stop#Go#
b. Wait#Stop#
c. Go#Stop#
d. Go#Wait#

11 Fill in the blank: 1

…………….is a communication methodology designed to deliver emails over
Internet protocol.
a. VIOP
b. SMTP
c. PPP
d. HTTP
12 Consider the code given below and find correct output: 1

x=5
def function1():
global x
y=x+x*2
print(y,end=”,”)
x=7
function1()
print(x)

Output:

a. 21 , 7
b. 15 , 5
c. 21 , 5
d. 15, 7

[3]
13 State whether the following statement is True or False: 1
Exception handling can be done for both user-defined and built-in exceptions.

14 Which of the following statements is FALSE in reference to MySQL? 1

a. It is an RDBMS.
b. It is case sensitive.
c. It is an open source.
d. It is ideal for both small and large applications.

15 Fill in the blank: 1

In case of switching, each information or message to be

transmitted between sender and receiver is broken down into smaller pieces.

16 Which method is used to move the file pointer to a specified position.? 1

a.tellg()
b.tell()
c.seek()
d.seekg()

Q17 and 18 are ASSERTION AND REASONING based questions. Mark the
correct choice as
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True
17 1
Assertion(A): Access mode ‘a’ opens a file for appending.

Reasoning(R): The file pointer is at the end of the file if the file exists.

18 1
Assertion(A): A function is block of organized and reusable code that is used to
perform a single, related action.

Reasoning(R): Function provides better modularity for your application and a high

degree of code reusability.

[4]
 खंड / SECTION B

19 (i) Expand the following terms: 1+1=

2
SMTP, IMAP
(ii) Give one difference between Active Hub and Passive Hub.

OR
(i) Define the term Protocol with respect to networks.
(ii) How is Hub different from Switch?

20 Harsh has written a code to input a number and find a table of any number. His 2
code is having errors. Rewrite the correct code and underline the corrections
made.

def table():
n=int(("Enter number which table U need: ")
for i in (1,11):
print("Table of Enter no=”,i*i)
Table()

21 Write a function countMy(SUBJECT) in Python, that takes the dictionary, 2

SUBJECT as an argument and displays the names (in uppercase) of the
subjects whose names are longer than 5 characters. For example, Consider the
following dictionary
SUBJECT={1:"Hindi",2:"Physics",3:"Chemistry",4:"cs",5:"Math"}
The output should be:
HINDI
PHYSICS
CHEMISTRY
OR
Write a function, lenLines(STRING), that takes a string as an argument

and returns a tuple containing length of each word of a string.

For example, if the string is " let us learn Python", the
tuple will have ( 3, 2, 5, 6)

[5]
22 Predict the output of the following code: 2

tuple1 = (11,22,33,44,55,66)
list1 =list(tuple1)
new_list = []
for i in list1:
if i%2==0 :
new_list.append(i)
new_tuple = tuple(new_list)
print(new_tuple)

23 Write the Python statement for each of the following tasks using BUILT-IN 1+1=
functions/methods only: 2

(i) To insert an element 100 at the Second position, in the list L1.
(ii) To check whether all the characters in the string S1 are digits or not.
OR
How the pop( ) function is different from remove( ) function working with
list in python ? Explain with example.

24 Pooja wrote a query in SQL for student table but she is not getting desired result 2
select * from student where fee = NULL;
Rewrite the above query so that she gets desired result

OR

Categorize the following commands as DDL or DML:

INSERT, ALTER, DROP, DELETE, UPDATE, CREATE

25 Predict the output of the following code: 2

def Diff(N1,N2):
if N1<N2:
return N1-N2
else:
return N2*N1
NUM= [10,23,14,54,32]
for CNT in range (4,0,-1):
A=NUM[CNT]
B=NUM[CNT-1]
print(Diff(A,B),'#', end=' ')

[6]
 खंड / SECTION C

26 Predict the output of the Python code given below: 3

def my_city (L,N):

for i in range(0,N):
if len(L)>4:
L[i]=L[i]+L[i]
else:
L[i]=L[i]
sub=['Delhi','Jaipur','Agra','Surat','Mumbai','Bhopal']
my_city(sub,6)
print(sub)

27 Write the outputs of the SQL queries (a) to (c) based on the relation Furniture 1*3
=
No Itemname Type Dateofstock Price Discount 3
1 White lotus Double Bed 23/02/2002 30000 25
2 Pink feather Baby Cot 20/01/2002 7000 20
3 Dolphin Baby Cot 19/02/2002 9500 20
4 Decent Office 01/01/2002 25000 30
Table
5 Comfort Double Bed 12/01/2002 25000 25
Zone
6 Donald Baby Cot 24/02/2002 6500 15
7 Royal finish Office 20/02/2002 18000 30
Table
8 Royal tiger Sofa 22/02/2002 31000 30
9 Econo sitting Sofa 13/12/2001 9500 25
10 paradise Dining 19/02/2002 11500 25
Table
11 Wood Double Bed 23/03/2003 25000 25
Comfort
12 Old Fox Sofa 20/02/2003 17000 20
13 Micky Baby Cot 21/02/2003 7500 15

(a) SELECT Itemname FROM Furniture WHERE Type="Double Bed";

(b) SELECT Dateofstock FROM Furniture WHERE Type="Sofa" order by Dateofstock;
(c) SELECT Type,sum(Price) FROM Furniture group by Type;

28 Define a function SHOWWORD () in python to read lines from a text file 3

STORY.TXT, and display those words, whose length is less than 5.
OR
Write a user defined function in python that displays the number of lines starting
with 'H' in the file para.txt

[7]
29 Consider the table Emp given below: 1*3=
3
Table : EMP

E_ID Name Desig Salary Allowance

E01 Ramesh Manager 80000 5400

E02 Kailash Clerk NULL 2400

E03 Rudra Supervisor 48000 NULL

E04 Sakila Clerk 30000 2000

E05 Prachi Supervisor NULL 2800

Based on the given table, write SQL queries for the following:
(i) Increase the salary by 10% of employees whose allowance is known.
(ii) Display Name and Total Salary (sum of Salary and Allowance) of all
employees. The column heading ‘Total Salary’ should also be
displayed.
(iii) Delete the record of employess who have salary greater than 40000.

30. Mr.Abhishek has created a list of elements. Help him to write a program in 3
python with functions, PushEl (S,element) and PopEl (S) to add a new
element and delete an element from a List of element named ‘S’ considering
them to act as push and pop operations of the Stack data structure . Push the
element into the stack only when the element is divisible by 4.

For eg:if L=[2,5,6,8,24,32]

then stack content will be

32 <- Top

24

[8]
 खंड / SECTION D
31 Consider the doctor and patient table and write the output of (i) to (iv) 1*4=
4
Doctor
docid Dname Specialization Outdoor
D1 MANISH PHYSICIAN MONDAY
D2 PARESH EYE FRIDAY
D3 KUMAR ENT SATURDAY
D4 AKASH ENT TUESDAY

Patient
Pid Pname did Date_visit
P1 Lal singh D2 2022-04-25
P2 Arjun D1 2022-05-05
P3 Narender D4 2022-03-13
P4 Mehul D3 2022-07-20
P5 Naveen D2 2022-05-18
P6 Amit D1 2022-01-22

(I) select count(*) from patient where date_visit like ‘%2_’;

(II) select specialization ,count(*) from doctor group by specialization;
(III) select a.dname, b.pname from doctor a, patient b where a.docid=b.did;
(IV) select dname from doctor,patient where docid=did and pname=’Arjun’;
32 A csv file “ result.csv” contains record of student in following order 4
[rollno, name, sub1,sub2,sub3,total]

Initially student total field is empty string as example data is given below
['1', 'Anil', '40', '34', '90', '']
['2', 'Sohan', '78', '34', '90', '']
['3', 'Kamal', '40', '45', '9', '']

A another file “final.csv” is created which reads records of “result.csv” and copy all
records after calculating total of marks into final.csv. The contents of final.csv
should be
['1', 'Anil', '40', '34', '90', '164']
['2', 'Sohan', '78', '34', '90', '202']
['3', 'Kamal', '40', '45', '9', '94']

(a) Define a function createcsv() that will create the result.csv file with the
sample data given above.

(b) Define a function copycsv() that reads the result.csv and copy the same
data after calculating total field into final.csv file.

[9]
 खंड / SECTION E

33 M/s Computer Solutions is a professional consultancy company. The company is 1*5=

planning to set up their new offices in India with its hub at Hyderabad. As a 5
network adviser, you have to understand their requirement and suggest them the
best available solutions. Their queries are mentioned as (i) to (v) below.

Physical locations of the blocks of M/s Computer Solutions

HR BLOCK MEETING BLOCK

FINANCE BLOCK

Block to block distance (in m)

Block (From) Block (To) Distance
HR Block MEETING 110
HR Block Finance 40
MEETING Finance 80
Expected number of computers
Block Computers
HR 25
Finance 120
MEETING 90

(i) Which will be the most appropriate block, where M/s Computer
Solutions should plan to install their server?
(ii) Draw a block to block cable layout to connect all the buildings in the
most appropriate manner for efficient communication.
(iii) What will be the best possible connectivity out of the following, you will
suggest to connect the new set up of offices in Bengalore with its
London based office.
 Satellite Link
 Infrared
 Ethernet
(iv) Which of the following device will be suggested by you to connect each
computer in each of the buildings?
 Switch
 Modem
 Gateway
(v) Company is planning to connect its offices in Hyderabad which is less
than 1 km. Which type of network will be formed?

[10]
34 2+3=
5
(i) Differentiate between rb+ and wb+ file modes in Python.
(ii) Consider a binary file “employee.dat” containing details such as
(empno, ename, salary). Write a python function to
display details of those employees who are earning between 20000 and
30000 (both values inclusive).

OR
(i) Differentiate between dump and load functions in binary files?

(ii) Write a Python function in Python to search the details of the employees
[name, designation, salary] whose salary is greater than 5000. The
records are stored in the file “emp.dat”. consider each record in the file
emp.dat as a list containing name, designation and salary.

35 (i) How many candidate key and primary key a table can have in a Database? 1+4=
5
(ii) Manish wants to write a program in Python to create the following table
named “EMP” in MYSQL database, ORGANISATION:
Eno (Employee No )- integer , Ename (Employee Name) - string
Edept (Employee Department)-string, Sal (salary)-integer
Note the following to establish connectivity between Python and MySQL:
Username – root , Password – admin , Host - localhost
The values of fields eno, ename, edept and Sal has to be accepted from the
user. Help Manish to write the program in Python to insert record in the above
table..

OR
(i) Differentiate between degree & cardinality key in RDBMS?

(iii) Vihaan wants to write a program in Python to create the following table
named “EMP” in MYSQL database, ORGANISATION:
Eno (Employee No )- integer , Ename (Employee Name) - string
Edept (Employee Department)-string, Sal (salary)-integer
Note the following to establish connectivity between Python and MySQL:
Username – root , Password – admin , Host - localhost
Help Vihaan to write the program in Python to Alter the above table with new
column named Bonus (int).

[11]
 Class XII

Computer Science (083)

Marking Scheme

Time Allowed: 3 hours MM: 70

Ques Question and Answers Distribution Total

No of Marks Marks

SECTION A
1 True 1 mark for 1
correct
answer

2 Option d 1 mark for 1

correct
delete answer

3 Option b 1 mark for 1

correct
18 answer

4 Option d 1 mark for 1

(‘BHASA’, ‘ ‘, ‘SANGAM@75’) correct
answer

5 Option b 1 mark for 1

correct
15,50 answer

6 Option a 1 mark for 1

correct
PAN answer

7 Option a 1 mark for 1

correct
r g b answer

8 Option b 1 mark for 1

2@tr correct
answer

[1]
9 Option b 1 mark for 1
correct
Statement 4 answer

10 Option b 1 mark for 1

correct
Wait#Stop# answer

11 Option b 1 mark for 1

correct
SMTP answer

12 Option a 1 mark for 1

correct
21 answer
7
13 True 1 mark for 1
correct
answer

14 Option b 1 mark for 1

correct
It is case sensitive answer

15 Packet 1 mark for 1

correct
answer

16 Option c 1 mark for 1

correct
seek() answer

17 Option a 1 mark for 1

Both A and R are true but R is the correct explanation for A correct
answer

[2]
18 Option a 1 mark for 1
correct
Both A and R are true but R is the correct explanation for A answer

SECTION B
19 (i) ½ mark for 1+1=2
each correct
SMTP – Simple Mail Transfer Protocol expansion

IMAP – Internet Message Access Protocol

(ii)
1 mark for
Active hubs amplify the incoming electric signal, whereas passive hubs any one
do not amplify the electric signal. (Any other valid difference may be
correct
considered)
difference

OR
(i) A network protocol is an established set of rules that determine 1 mark for
how data is transmitted between different devices in the same correct
network.
definition
(ii) Hub is an electronic device that connects several nodes to form
a network and redirect the received information to all the nodes 1 mark for
in a broadcast mode. Whereas Switch is an intelligent device
any one
that connects several nodes to form a network and redirect the
received information only to the intended node(s). correct
difference
(Any other valid difference may be considered)

20 def table (): ½ mark for 2

n=int (input ("Enter number which table U need: "))
each
for i in range (1,11):
print ("able of Enter no=",i* n) correction
table () made

[3]
21 ½ mark for 2
correct
SUBJECT={1:"Hindi",2:"Physics",3:"Chemistry",4:"CS",5:"MATH"}
function
def countMy (SUBJECT): header
for S in SUBJECT.values():
½ mark for
if len(S)>5:
correct loop
print(S.upper())
½ mark for
countMy()
correct if
statement

½ mark for
displaying
the output

OR
½ mark for
correct
def lenLines (STRING):
function
t=()
header
L=STRING.split()
for line in L: ½ mark for
using split()
length=len(line)
½ mark for
t=t+(length,)
adding to
return t
tuple

½ mark for
return
statement

Note: Any other correct logic may be marked

22 1½ mark for 2
(22, 44, 66)
each correct
digit
½ mark for
parenthesis

[4]
23 (i) L1.insert(1,100) 1 mark for 1+1=2
each correct
(ii) S1.isdigit() statement

OR
pop() function removes the last value and returns the same.

>>>L=[10,20,30,20] 1 mark for

correct
>>> L.pop () difference
and 1 mark
20 for suitable
The remove() method removes the first matching value from the list. example

>>>L.remove (20)

[10, 30, 20]

24 SQL Command to add primary key: 2 mark for 2

correct
select * from student where fee IS NULL Command

OR
1 mark for
DDL : CREATE, ALTER DROP each correct
DDL & DML
DML: INSERT UPDATE DELETE Categorized
commands

25 ½ mark for 2
-22 # 756 # -9 # 230 #
each correct
number and ½
mark for each
correct #
symbol
SECTION C
26 ['DelhiDelhi', 'JaipurJaipur', 'AgraAgra', 'SuratSurat', 'MumbaiMumbai', ½ mark for 3
'BhopalBhopal'] each correct
output

[5]
 27 1*3=3
1 mark for
each
(a) (b) (c) correct
Item Name Dateofstock Type Sum(Price)
White lotus 13/12/2001 Double Bed 80000 output.
Comfort Zone 22/02/2002 Baby Cot 30500
Wood Comfort 20/02/2003 Office Table 43000
Sofa 57500
Dining Table 11500
28 def SHOWWORD () : (½ Mark for 3
c=0 opening the file)
file=open(‘STORY.TXT,'r') (½ Mark for
line = file.read() reading line
and/or splitting)
word = line.split()
(½ Mark for
for w in word: checking
if len(w)<5: condition)
print( w) (½ Mark for
file.close() printing word)

OR
def count H( ):
f = open (“para.txt” , “r” )
lines =0
L=f. readlines ()
for i in L:
if i [0]== ‘H’:
lines +=1
print (“No. of lines are: “ , lines)
29 (i) 1 mark for 1*3=3
each correct
UPDATE EMP
query
SET Salary=Salary + Salary*0.10
WHERE Allowance IS NOT NULL;

(ii) SELECT Name, Salary + Allowance AS

"Total Salary" FROM EMP;

(iii)
DELETE FROM EMP
WHERE Salary>40000;
[6]
30 N=[12, 13, 34, 56, 21, 79, 98, 22, 35, 38] 1½ marks for 3
def PUSHEl(S,N):
S.append(N)
each Push
def POPEl(S): and Pop
if S!=[]: operation
return S.pop()
else:
return None
ST=[]
for k in N:
if k%4==0:
PUSHEl(ST,k)
while True:
if ST!=[]:
print(POPEl(ST),end=" ")
else:
break

SECTION D
31 (i) 1 mark for 1*4=4
each correct
3
output

(ii)
1
1
2
(iii)
Dname Pname
PARESH Lal singh
MANISH Arjun
AKASH Narender
KUMAR Mehul
PARESH Naveen
MANISH Amit

(iv)
Manish

[7]
32 ½ mark for 4
import csv accepting
def createcsv(): data
f=open("result.csv","w", newline="")
correctly
w=csv.writer(f)
w.writerow([1,'Anil',40,34,90,""])
½ mark for
w.writerow([2,'Sohan',78,34,90,""])
w.writerow([3,'Kamal',40,45,9,""]) opening and
f.close() closing file

import csv ½ mark for

def copycsv(): writing
f=open("result.csv","r") headings
f1=open("final.csv","w",newline="")
w1=csv.writer(f1) ½ mark for
r=csv.reader(f)
for x in r: writing row
x[5]=int(x[2])+int(x[3])+int(x[4])
w1.writerow(x) ½ mark for
f.close() opening and
f1.close() closing file

½ mark for
reader object

½ mark for
print heading

½ mark for
printing data

SECTION E
33 (i) M/s Computer Solutions should install its server in finance block as it 1 Mark of 1*5=5
each correct
is having maximum number of computers. answer
(ii) Any suitable layout

(iii) Satellite Link.

(iv) Switch.

(v) LAN

[8]
34 (i) 1 mark for 2+3=5
rb+ Opens a file for both reading and writing in binary format. (+) the file each correct
pointer will be at the beginning of the file.
difference
wb+ Opens a file for both reading and writing in binary format. Overwrites ½ mark for
the existing file If the file exists. If the file does not exist, creates a new
file for reading or writing. correctly
opening and
(ii) def Readfile(): closing files
s=open( “Employee.dat” , “rb+”)
try:
while True:
r=pickle.load(s)
if r[2]>=20000 and r[2]<=30000:
print(r)
except: ½ mark for
print(“end of file”) correct loop

OR ½ mark for
correct split

1 mark for
correctly
(i) reading /
In pickle module, dump () method is used to convert (pickling) writing data
Python objects for writing data in a binary file
½ mark for
Whereas the load () function is used to read data from a binary printing
file or file object.
data
(ii)
import pickle as p
L=[]
with open(‘emp.dat’,’rb’) as f:
L=p.load(f)
for r in L:
if r[2]>5000:
print(“name=”,r[0])
print(“designation=”,r[1])
print(“salary=”,r[2])

Note: Any other correct logic may be marked

[9]
35 (i) A table can only have one primary key, but it can have multiple ½ mark for 1+4=5
candidate key in a database. (any suitable example) correct
definition

(ii) ½ mark for

import mysql.connector correct
mydb=mysql.connector.connect(host="localhost",user="root",passwd="admin",dat example
abase="SCHOOL")
mycursor=mydb.cursor()
while 1:
ch=int(input("enter -1 to exit / any other no to insert record into student table")) ½ mark for
if ch==-1: importing
break
correct
eno=int(input("Enter Employee no"))
ename=input("Enter Employee Name") module
edept=input("Enter dept name")
sal=int(input("Enter salary"))
mycursor.execute("insert into EMP values ('"+str(eno)+"','"+ ename+"','" +edept +
"','"+str(sal)+"')") 1 mark for
mydb.commit() correct
for x in mycursor:
print(x) connect()

OR ½ mark for
correctly
(i)
accepting the
Degree: The total number of attributes which in the relation is called the input
degree of the relation.
Cardinality: Total number of rows present in the Table. 1 ½ mark for
(any suitable example) correctly
displaying
(ii)
data

import mysql.connector
mydb=mysql.connector.connect(host="localhost",user="root",passwd="admin",databas
e="SCHOOL")
mycursor=mydb.cursor()
mycursor.execute("alter table emp add (bonus int(3))")
mycursor.execute("desc emp")

for x in mycursor:
print(x)

Note: Any other correct logic may be marked

[10]