Class 12 Cs All Region Papers

SAMPLE QUESTION PAPER (THEORY)
CLASS: XII SESSION: 2024-25

COMPUTER SCIENCE (083)
Time allowed: 3 Hours Maximum Marks: 70
General Instructions:
● This question paper contains 37 questions.
● All questions are compulsory. However, internal choices have been provided in some
questions. Attempt only one of the choices in such questions
● The paper is divided into 5 Sections- A, B, C, D and E.
● Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
● Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
● Section C consists of 3 questions (29 to 31). Each question carries 3 Marks.
● Section D consists of 4 questions (32 to 35). Each question carries 4 Marks.
● Section E consists of 2 questions (36 to 37). Each question carries 5 Marks.
● All programming questions are to be answered using Python Language only.
● In case of MCQ, text of the correct answer should also be written.
Q No. Section-A (21 x 1 = 21 Marks) Marks
1. State True or False:

(1)
The Python interpreter handles logical errors during code execution.
2. Identify the output of the following code snippet:

text = "PYTHONPROGRAM"
text=text.replace('PY','#')
print(text)
(1)
(A) #THONPROGRAM
(B) ##THON#ROGRAM
(C) #THON#ROGRAM
(D) #YTHON#ROGRAM
3. Which of the following expressions evaluates to False?

(A) not(True) and False
(B) True or False (1)
(C) not(False and True)
(D) True and not(False)
4. What is the output of the expression?

country='International'
print(country.split("n"))
(A) ('I', 'ter', 'atio', 'al') (1)
(B) ['I', 'ter', 'atio', 'al']
(C) ['I', 'n', 'ter', 'n', 'atio', 'n', 'al']
(D) Error
Page: 1/11
5. What will be the output of the following code snippet?
message= "World Peace" (1)
print(message[-2::-2])
6. What will be the output of the following code?

tuple1 = (1, 2, 3)
tuple2 = tuple1
tuple1 += (4,)
print(tuple1 == tuple2) (1)
(A) True
(B) False
(C) tuple1
(D) Error
7. If my_dict is a dictionary as defined below, then which of the following

statements will raise an exception?
my_dict = {'apple': 10, 'banana': 20, 'orange': 30}
(A) my_dict.get('orange') (1)
(B) print(my_dict['apple', 'banana'])
(C) my_dict['apple']=20
(D) print(str(my_dict))
8. What does the list.remove(x) method do in Python?

(A) Removes the element at index x from the list
(B) Removes the first occurrence of value x from the list (1)
(C) Removes all occurrences of value x from the list
(D) Removes the last occurrence of value x from the list
9. If a table which has one Primary key and two alternate keys. How many
Candidate keys will this table have?
(A) 1
(1)
(B) 2
(C) 3
(D) 4
10. Write the missing statement to complete the following code:

file = open("example.txt", "r")
data = file.read(100)
____________________ #Move the file pointer to the (1)
beginning of the file
next_data = file.read(50)
file.close()
11. State whether the following statement is True or False:

The finally block in Python is executed only if no exception occurs
(1)
in the try block.
Page: 2/11
12. What will be the output of the following code?
c = 10
def add():
global c
c = c + 2
print(c,end='#')
add() (1)
c=15
print(c,end='%')
(A) 12%15#
(B) 15#12%
(C) 12#15%
(D) 12%15#
13. Which SQL command can change the degree of an existing relation? (1)
14. What will be the output of the query?

SELECT * FROM products WHERE product_name LIKE
'App%';
(A) Details of all products whose names start with 'App' (1)
(B) Details of all products whose names end with 'App'
(C) Names of all products whose names start with 'App'
(D) Names of all products whose names end with 'App'
15. In which datatype the value stored is padded with spaces to fit the specified
length.
(A) DATE
(1)
(B) VARCHAR
(C) FLOAT
(D) CHAR
16. Which aggregate function can be used to find the cardinality of a table?
(A) sum()
(B) count() (1)
(C) avg()
(D) max()
17. Which protocol is used to transfer files over the Internet?

(A) HTTP
(B) FTP
(C) PPP
(D) HTTPS (1)
Page: 3/11
18. Which network device is used to connect two networks that use different
protocols?
(A) Modem
(1)
(B) Gateway
(C) Switch
(D) Repeater
19. Which switching technique breaks data into smaller packets for
transmission, allowing multiple packets to share the same network (1)
resources.
Q20 and Q21 are Assertion(A) and Reason(R) 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
20. Assertion (A): Positional arguments in Python functions must be passed in

the exact order in which they are defined in the function
signature. (1)
Reasoning (R): This is because Python functions automatically assign
default values to positional arguments.
21. Assertion (A): A SELECT command in SQL can have both WHERE and
HAVING clauses.
Reasoning (R): WHERE and HAVING clauses are used to check (1)
conditions, therefore, these can be used interchangeably.
Q No Section-B ( 7 x 2=14 Marks) Marks
22. How is a mutable object different from an immutable object in Python?

Identify one mutable object and one immutable object from the following: (2)
(1,2), [1,2], {1:1,2:2}, ‘123’
23. Give two examples of each of the following:

(2)
(I) Arithmetic operators (II) Relational operators
24. If L1=[1,2,3,2,1,2,4,2, . . . ], and L2=[10,20,30, . . .], then

(Answer using builtin functions only)
(I)
A) Write a statement to count the occurrences of 4 in L1. (2)
OR
B) Write a statement to sort the elements of list L1 in ascending
order.
Page: 4/11
(II)
A) Write a statement to insert all the elements of L2 at the end of L1.
OR
B) Write a statement to reverse the elements of list L2.
25. Identify the correct output(s) of the following code. Also write the minimum
and the maximum possible values of the variable b.
import random
a="Wisdom"
b=random.randint(1,6)
(2)
for i in range(0,b,2):
print(a[i],end='#')
(A) W# (B) W#i#
(C) W#s# (D) W#i#s#
26. The code provided below is intended to swap the first and last elements of
a given tuple. However, there are syntax and logical errors in the code.
Rewrite it after removing all errors. Underline all the corrections made.
def swap_first_last(tup)
if len(tup) < 2:
return tup (2)
new_tup = (tup[-1],) + tup[1:-1] + (tup[0])
return new_tup
result = swap_first_last((1, 2, 3, 4))

print("Swapped tuple: " result)
27. (I)
A) What constraint should be applied on a table column so that
duplicate values are not allowed in that column, but NULL is
allowed.
OR
B) What constraint should be applied on a table column so that (2)
NULL is not allowed in that column, but duplicate values are
allowed.
Page: 5/11
(II)
A) Write an SQL command to remove the Primary Key constraint
from a table, named MOBILE. M_ID is the primary key of the
table.
OR
B) Write an SQL command to make the column M_ID the Primary
Key of an already existing table, named MOBILE.
28. A) List one advantage and one disadvantage of star topology.

OR (2)
B) Expand the term SMTP. What is the use of SMTP?
Q No. Section-C ( 3 x 3 = 9 Marks) Marks
29. A) Write a Python function that displays all the words containing @cmail
from a text file "Emails.txt".
OR (3)
B) Write a Python function that finds and displays all the words longer than
5 characters from a text file "Words.txt".
30. A) You have a stack named BooksStack that contains records of books.
Each book record is represented as a list containing book_title,
author_name, and publication_year.
Write the following user-defined functions in Python to perform the
specified operations on the stack BooksStack:
(I) push_book(BooksStack, new_book): This function takes the stack
BooksStack and a new book record new_book as arguments and
pushes the new book record onto the stack.
(II) pop_book(BooksStack): This function pops the topmost book record
from the stack and returns it. If the stack is already empty, the
function should display "Underflow".
(III) peep(BookStack): This function displays the topmost element of (3)
the stack without deleting it. If the stack is empty, the function
should display 'None'.
OR
(B) Write the definition of a user-defined function `push_even(N)` which
accepts a list of integers in a parameter `N` and pushes all those integers
which are even from the list `N` into a Stack named `EvenNumbers`.
Write function pop_even() to pop the topmost number from the stack and
returns it. If the stack is already empty, the function should display "Empty".
Write function Disp_even() to display all element of the stack without
deleting them. If the stack is empty, the function should display 'None'.
Page: 6/11
For example:
If the integers input into the list `VALUES` are:
[10, 5, 8, 3, 12]
Then the stack `EvenNumbers` should store:

[10, 8, 12]
31. Predict the output of the following code:

d = {"apple": 15, "banana": 7, "cherry": 9}
str1 = ""
for key in d:
str1 = str1 + str(d[key]) + "@" + “\n”
str2 = str1[:-1]
print(str2)
(3)
OR
Predict the output of the following code:

line=[4,9,12,6,20]
for I in line:
for j in range(1,I%5):
print(j,’#’,end=””)
print()
Q No. Section-D ( 4 x 4 = 16 Marks) Marks
32. Consider the table ORDERS as given below
O_Id C_Name Product Quantity Price

1001 Jitendra Laptop 1 12000
1002 Mustafa Smartphone 2 10000
1003 Dhwani Headphone 1 1500
Note: The table contains many more records than shown here.
(4)
A) Write the following queries:
(I) To display the total Quantity for each Product, excluding

Products with total Quantity less than 5.
(II) To display the orders table sorted by total price in descending
order.
(III) To display the distinct customer names from the Orders table.
Page: 7/11
(IV) Display the sum of Price of all the orders for which the quantity
is null.
OR
B) Write the output
(I) Select c_name, sum(quantity) as total_quantity
from orders group by c_name;
(II) Select * from orders where product like
'%phone%';
(III) Select o_id, c_name, product, quantity, price
from orders where price between 1500 and 12000;
(IV) Select max(price) from orders;
33. A csv file "Happiness.csv" contains the data of a survey. Each record of the
file contains the following data:
● Name of a country
● Population of the country
● Sample Size (Number of persons who participated in the survey in
that country)
● Happy (Number of persons who accepted that they were Happy)
(4)
For example, a sample record of the file may be:
[‘Signiland’, 5673000, 5000, 3426]
Write the following Python functions to perform the specified operations on
this file:
(I) Read all the data from the file in the form of a list and display all
those records for which the population is more than 5000000.
(II) Count the number of records in the file.
34. Saman has been entrusted with the management of Law University
Database. He needs to access some information from FACULTY and
COURSES tables for a survey analysis. Help him extract the following
information by writing the desired SQL queries as mentioned below.
Table: FACULTY
F_ID FName LName Hire_Date Salary
102 Amit Mishra 12-10-1998 12000
103 Nitin Vyas 24-12-1994 8000 (4)
104 Rakshit Soni 18-5-2001 14000
105 Rashmi Malhotra 11-9-2004 11000
106 Sulekha Srivastava 5-6-2006 10000
Table: COURSES
C_ID F_ID CName Fees
C21 102 Grid Computing 40000
C22 106 System Design 16000
Page: 8/11
C23 104 Computer Security 8000
C24 106 Human Biology 15000
C25 102 Computer Network 20000
C26 105 Visual Basic 6000
(I) To display complete details (from both the tables) of those Faculties
whose salary is less than 12000.
(II) To display the details of courses whose fees is in the range of 20000
to 50000 (both values included).
(III) To increase the fees of all courses by 500 which have "Computer"
in their Course names.
(IV) (A) To display names (FName and LName) of faculty taking System
Design.
OR
(B) To display the Cartesian Product of these two tables.
35. A table, named STATIONERY, in ITEMDB database, has the following

structure:
Field Type
itemNo int(11)
itemName varchar(15)
price float
qty int(11)
(4)
Write the following Python function to perform the specified operation:
AddAndDisplay(): To input details of an item and store it in the table
STATIONERY. The function should then retrieve and display all records
from the STATIONERY table where the Price is greater than 120.
Assume the following for Python-Database connectivity:

Host: localhost, User: root, Password: Pencil
Q.No. SECTION E (2 X 5 = 10 Marks) Marks
36. Surya is a manager working in a recruitment agency. He needs to manage

the records of various candidates. For this, he wants the following
information of each candidate to be stored:
- Candidate_ID – integer
- Candidate_Name – string
- Designation – string
- Experience – float (5)
You, as a programmer of the company, have been assigned to do this job

for Surya.
(I) Write a function to input the data of a candidate and append it in a

binary file.
Page: 9/11
(II) Write a function to update the data of candidates whose experience
is more than 10 years and change their designation to "Senior
Manager".
(III) Write a function to read the data from the binary file and display the
data of all those candidates who are not "Senior Manager".
37. Event Horizon Enterprises is an event planning organization. It is planning

to set up its India campus in Mumbai with its head office in Delhi. The
Mumbai campus will have four blocks/buildings - ADMIN, FOOD, MEDIA,
DECORATORS. You, as a network expert, need to suggest the best
network-related solutions for them to resolve the issues/problems
mentioned in points (I) to (V), keeping in mind the distances between
various blocks/buildings and other given parameters.
Block to Block distances (in Mtrs.)

From To Distance
ADMIN FOOD 42 m (5)
ADMIN MEDIA 96 m
ADMIN DECORATORS 48 m
FOOD MEDIA 58 m
FOOD DECORATORS 46 m
MEDIA DECORATORS 42 m
Distance of Delhi Head Office from Mumbai Campus = 1500 km
Number of computers in each of the blocks/Center is as follows:
ADMIN 30
FOOD 18
MEDIA 25
DECORATORS 20
DELHI HEAD
OFFICE 18
Page: 10/11
(I) Suggest the most appropriate location of the server inside the
MUMBAI campus. Justify your choice.
(II) Which hardware device will you suggest to connect all the
computers within each building?
(III) Draw the cable layout to efficiently connect various buildings
within the MUMBAI campus. Which cable would you suggest for
the most efficient data transfer over the network?
(IV) Is there a requirement of a repeater in the given cable layout?
Why/ Why not?
(V) A) What would be your recommendation for enabling live visual
communication between the Admin Office at the Mumbai campus
and the DELHI Head Office from the following options:
a) Video Conferencing
b) Email
c) Telephony
d) Instant Messaging
OR
B) What type of network (PAN, LAN, MAN, or WAN) will be set up
among the computers connected in the MUMBAI campus?
Page: 11/11
MARKING SCHEME
Class: XII Session: 2024-25
Computer Science (083)

Q No. SECTION A (21X1=21) Marks
1. False (1)
(1 mark for correct answer)
2. (A) #THONPROGRAM
(1)
3. (A) not (True) and False
(1)
4. (B) ['I', 'ter', 'atio', 'al']
(1)
5. ce lo
(1)
6. (B) False
(1)
7. (B) print(my_dict['apple', 'banana'])
(1)
8. (B) Removes the first occurrence of value x from the list
(1)
9. (C) 3
(1)
10. file.seek(0) ( OR file.seek(0,0) )
(1)
11. False
(1)
12. (C) 12#15%
(1)
13. Alter (or Alter Table) (1)
Page: 1/11
14. (A) Details of all products whose names start with 'App'
(1)
15. (D) CHAR
(1)
16. (B) count()
(1)
17. (B) FTP
(1)
18. (B) Gateway
(1)
19. (B) Packet Switching
(1)
20. (C) A is True but R is False.
(1)
21. (C) A is True but R is False.
(1)
Q No. SECTION B (7 X 2 =14) Marks

22. A mutable object can be updated whereas an immutable object cannot be
updated.
Mutable object: [1,2] or {1:1,2:2} (Any one)
(2)
Immutable object: (1,2) or ‘123’ (Any one)
(1 mark for correct difference)
(½ x 2 = 1 Mark for selecting correct objects)
23. (I) Arithmetic operators: +,-
(II) Relational operators: >, >= (2)
(½ x 4 = 2 Marks for each correct operator)

24. (I)
A) L1.count(4)
OR
B) L1.sort() (2)
Page: 2/11
(II)
A) L1.extend(L2)
OR
B) L2.reverse()
25. (A), (C)
(½ x 2 = 1 Mark)
(2)
Minimum and maximum possible values of the variable b: 1,6
(½ x 2 = 1 Mark)
26. def swap_first_last(tup):
if len(tup) < 2:
return tup
new_tup = (tup[-1],) + tup[1:-1] + (tup[0],)
return new_tup
(2)
result = swap_first_last((1, 2, 3, 4))

print("Swapped tuple:", result)
(½ mark each for correcting 4 mistakes)

27. (I)
A) UNIQUE
OR
B) NOT NULL
(2)
(II)
A) ALTER TABLE MOBILE DROP PRIMARY KEY;
OR
B) ALTER TABLE MOBILE ADD PRIMARY KEY (M_ID);
28. A) Advantage: Network extension is easy.
Disadvantage: Failure of switch/hub results in failure of the network.

(1 mark for correct Advantage)
(2)
(1 mark for correct Disadvantage)
OR
Page: 3/11
B) SMTP: Simple Mail Transfer Protocol.
SMTP is used for sending e-mails from client to server.

(1 mark for correct expansion)
(1 mark for correct usage)
Q No. SECTION C (3 X 3 = 9) Marks

29. (A)
def show():
f=open("Email.txt",'r')
data=f.read()
words=data.split()
for word in words:
if '@cmail' in word:
print(word,end=' ')
f.close()
(½ mark for correct function header)
(½ mark for correctly opening the file)
(½ mark for correctly reading from the file)
(½ mark for splitting the text into words)
(1 mark for correctly displaying the desired words) (3)
OR
(B)
def display_long_words():
with open("Words.txt", 'r') as file:
data=file.read()
words=data.split()
for word in words:
if len(word)>5:
print(word,end=' ')
(½ mark for correct function header)
(½ mark for correctly opening the file)
(½ mark for correctly reading from the file)
( ½ mark for splitting the text into words)
(1 mark for correctly displaying the desired words)
Page: 4/11
30. (A)
(I)
def push_book(BooksStack, new_book):
BooksStack.append(new_book)
(II)
def pop_book(BooksStack):
if not BooksStack:
print("Underflow")
else:
return(BookStack.pop())
(III)
def peep(BooksStack):
if not BooksStack:
print("None")
else:
print(BookStack[-1])
(3x1 mark for correct function body; No marks for any function header as it
was a part of the question)
OR
(B)
def push_even(N):
(3)
EvenNumbers = []
for num in N:
if num % 2 == 0:
EvenNumbers.append(num)
return EvenNumbers
VALUES = []
for i in range(5):
VALUES.append(int(input("Enter an integer: ")))
EvenNumbers = push_even(VALUES)
def pop_even():
if not EvenNumbers:
print("Underflow")
else:
print(EvenNumbers.pop())
pop_even()
Page: 5/11
def Disp_even():
if not EvenNumbers:
print("None")
else:
print(EvenNumbers[-1])
Disp_even()
(1/2 for identifying even numbers)
(1/2 mark for correctly adding data to stack)
(1/2 mark for correctly poping data on the stack and 1/2 mark for checking
condition)
(1/2 mark for correctly displaying the data with none)
(1/2 mark for function call statements)
31. (A) 15@
7@
9
OR
(3)
(B) 1 #2 #3#
1 #2 #3 #
1#
(1 mark for each correct line of output)

(deduct ½ mark for not printing @/#)
Q No. SECTION D (4 X 4 = 16) Marks

32. (A)
(I) select Product, sum(Quantity) from orders group by product
having sum(Quantity)>=5;
(II) select * from orders order by Price desc;
(III) select distinct C_Name from orders;
(IV) select sum(price) as total_price from orders where Quantity IS
NULL;
(4 x 1 mark for each correct query)

(4)
OR
(B)
(I)
C_Name | Total_Quantity
--------- |---------------
Jitendra |1
Mustafa |2
Dhwani |1
Page: 6/11
(II)
O_Id | C_Name | Product | Quantity | Price

----- |-------- |------------ |---------- |-------
1002 | Mustafa | Smartphone | 2 | 10000
1003 | Dhwani | Headphone | 1 | 1500
(III) O_Id | C_Name | Product | Quantity | Price

----- |---------- |------------ |---------- |-------
1001 | Jitendra | Laptop |1 | 12000
1002 | Mustafa | Smartphone | 2 | 10000
1003 | Dhwani | Headphone | 1 | 1500
(IV)
MAX(Price)
-----------
12000
(4 x 1 mark for each correct output)

33. (I)
def show():
import csv
f=open("happiness.csv",'r')
records=csv.reader(f)
next(records, None) #To skip the Header row
for i in records:
if int(i[1])>5000000:
print(i)
f.close()
(½ mark for opening in the file in right mode)
(½ mark for correctly creating the reader object)
(½ mark for correctly checking the condition)
(½ mark for correctly displaying the records) (4)
(II)
def Count_records():
import csv
f=open("happiness.csv",'r')
records=csv.reader(f)
next(records, None) #To skip the Header row
count=0
for i in records:
count+=1
print(count)
f.close()
Page: 7/11
(½ mark for opening in the file in right mode)
(½ mark for correctly creating the reader object)
(½ mark for correct use of counter)
(½ mark for correctly displaying the counter)
Note (for both parts (I) and (II)):
(i) Ignore import csv as it may be considered the part of the
complete program, and there is no need to import it in individual
functions.
(ii) Ignore next(records, None) as the file may or may not have the
Header Row.
34. (I) Select * from FACULTY natural join COURSES where Salary<12000;
Or
Select * from FACULTY, COURSES where Salary<12000 and
facuty.f_id=courses.f_id;
(II) Select * from courses where fees between 20000 and 50000;
(III) Update courses set fees=fees+500 where CName like
'%Computer%';
(IV)
(A) Select FName, LName from faculty natural join courses where
Came="System Design"; (4)
Or
Select FName, LName from faculty, courses where Came="System
Design" and facuty.f_id=courses.f_id;
OR
(B) Select * from FACULTY, COURSES;
(4x1 mark for each correct query)

35. def AddAndDisplay():
import mysql.connector as mycon
mydb=mycon.connect(host="localhost",user="root",
passwd="Pencil",database="ITEMDB")
mycur=mydb.cursor()
no=int(input("Enter Item Number: "))
nm=input("Enter Item Name: ")
pr=float(input("Enter price: "))
qty=int(input("Enter qty: "))
query="INSERT INTO stationery VALUES ({},'{}',{},{})" (4)
query=query.format(no,nm,pr,qty)
mycur.execute(query)
mydb.commit()
mycur.execute("select * from stationery where price>120")
for rec in mycur:
print(rec)
Page: 8/11
(½ mark for correctly importing the connector object)
(½ mark for correctly creating the connection object)
(½ mark for correctly creating the cursor object)
(½ mark for correctly inputting the data)
(½ mark for correct creation of first query)
(½ mark for correctly executing the first query with commit)
(½ mark for correctly executing the second query)
(½ mark for correctly displaying the data)
Q No. SECTION E (2 X 5 = 10) Marks

36. (I) (5)
import pickle
def input_candidates():
candidates = []
n = int(input("Enter the number of candidates you want to add: "))
for i in range(n):
candidate_id = int(input("Enter Candidate ID: "))
candidate_name = input("Enter Candidate Name: ")
designation = input("Enter Designation: ")
experience = float(input("Enter Experience (in years): "))
candidates.append([candidate_id, candidate_name, designation,
experience])
return candidates
candidates_list = input_candidates()
def append_candidate_data(candidates):
with open('candidates.bin', 'ab') as file:
for candidate in candidates:
pickle.dump(candidate, file)
print("Candidate data appended successfully.")
append_candidate_data(candidates_list)
(II)
import pickle
def update_senior_manager():
updated_candidates = []
try:
with open('candidates.bin', 'rb') as file:
while True:
try:
candidate = pickle.load(file)
if candidate[3] > 10: # If experience > 10 years
candidate[2] = 'Senior Manager'
updated_candidates.append(candidate)
except EOFError:
Page: 9/11
break # End of file reached
except FileNotFoundError:
print("No candidate data found. Please add candidates first.")
return
with open('candidates.bin', 'wb') as file:

for candidate in updated_candidates:
pickle.dump(candidate, file)
print("Candidates updated to Senior Manager where applicable.")

update_senior_manager()
(III)
import pickle
def display_non_senior_managers():
try:
with open('candidates.bin', 'rb') as file:
while True:
try:
candidate = pickle.load(file)
if candidate[2] != 'Senior Manager': # Check if not Senior
Manager
print(f"Candidate ID: {candidate[0]}")
print(f"Candidate Name: {candidate[1]}")
print(f"Designation: {candidate[2]}")
print(f"Experience: {candidate[3]}")
print("--------------------")
except EOFError:
break # End of file reached
except FileNotFoundError:
print("No candidate data found. Please add candidates first.")
display_non_senior_managers()
(1/2 mark of import pickle)

(1/2 mark for input)
(1/2 mark for opening file in append mode and 1/2 mark for using dump)
(1/2 mark for opening file in read mode and 1/2 mark for using load)
(1 mark for checking the condition and updating the value)
(1 mark for checking the condition and displaying data correctly)
37. (I) ADMIN Block as it has maximum number of computers. (5)
(II) Switch
(III)
Page: 10/11
(or Any other correct layout)
Cable: Coaxial cable
(½ mark for correct layout + ½ mark for correct table type)
(IV) There is no requirement of the Repeat as the optical fibre cable used for
the network can carry the data to much longer distances than within the
campus.
(V) (A) a) Video Conferencing

OR
(B) LAN
Page: 11/11
KENDRIYA VIDYALAYA SANGATHAN AGRA REGION
FIRST PRE BOARD EXAMINATION (2023-24)
CLASS : XII TIME : 03 HOURS
SUBJECT : COMPUTER SCIENCE (083) MAXIMUM MARKS : 70
[ANSWER KEY / MARKING SCHEME]
SECTION A
(No marks for partially correct answers)
Q1 b) 1026 1
Q2 c) True 1
Q3 a) iai pa 1
Q4 a) list 1
Q5 c) d.clear( ) 1
Q6 d) None 1
Q7 c) t[3] = 300 1
Q8 d) $ 1
Q9 b) Optic Fiber 1
Q10 b) RJ45 1
Q11 a) select gender, count(*) form students having age >15; 1
Q12 b) UPDATE 1
Q13 c) 8, 24 1
Q14 b) bps 1
Q15 d) except 1
Q16 a) F = open(‘story.txt’, ‘read’) 1
d) Open(F) = ‘story.txt’
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
Q17 c) A is True but R is False 1
Page 1 of 7
Q18 a) Both A and R are true and R is the correct explanation for A 1
SECTION B
Q19 a) 2
i) Voice over Internet Protocol ii) eXtensible Markup Language ( ½ + ½ )

b) Telnet / SSH (1)
OR
½ Mark for each factor of comparison
Q20 L = [1,2,1,1,2,1,2,3,5,4,1,2,5,4,4,5] 2
D = {}
for x in L:
if x in D:
D[x]+=1
else:
D[x]=1
(½ Mark for each correction)
Q21 1 Mark for correct iterations 2
1 Mark for correct modifications
OR
1 Mark for taking input and returning True or False
1 Mark for comparing the string with its reverse
Q22 B#1 2
H#0
A#5
R#2
T#4
Q23 i. L[3].insert(2, 55) (1 mark) 2
ii. L.pop(3) or L.pop(-3) or L.remove([40,50,55,60]) (1 mark)
Q24 (i) ALTER TABLE Students ADD Phone INT; (1 mark) 1x2
(ii) ALTER TABLE Students ADD PRIMARY KEY (RollNo); (1 mark) =2
OR
(i) ALTER TABLE Books MODIFY rating DECIMAL(2,1); (1 mark)
(ii) ALTER TABLE Books DROP [COLUMN] pages; (1 mark)
Q25 3$3 2
3#3
6$4
Page 2 of 7
SECTION C
Q26 @@@NNew@MMen 3
Q27 i. 1x3
Name Salary =3
PV Sindhu Badminton
Saina Nehwal Badminton
Pankaj Advani Snooker
V Anand Hockey
ii.
sum(Salary)
22500
iii.
count(distinct Game)
5
Q28 def countFailedAttempts( ): 3

f = open(‘log_report.txt’)
lines = f.readlines()
c=0
for line in lines:
if ‘failed’ in line: #if line.split()[2] == ‘failed’
c+=1
f.close()
return c #print(c)
OR
def countWords( ):
f = open(‘russel.txt’)
words = f.read().split()
c=0
for word in words:
if word.startswith(‘th’) or word.startswith(‘Th’): #if word[0:2] == ‘th’ or word[0:2] – ‘Th’
c+=1
Page 3 of 7
f.close()
return c #print(c)
Q29 i. UPDATE Employees SET salary = salary + salry*0.1 WHERE gender = ‘F’; 3
ii. SELECT name, gender from Employees WHERE salary is NULL;
iii. DELETE from Employees WHERE dob<’1995-01-01’;
Q30 def Push_item(Inventory): 3

for item in Inventory:
if item[3]>100:
items.append(item)
def Pop_items():
try:
item = items.pop()
print(item)
except:
print(“Stack Empty”)
(or any other valid implementation)

SECTION D
Q31 i. SELECT gender, avg(Salary) from Employees group by gender; 4
ii. SELECT name, dept_name from Employees E and Departments D WHERE E.dept_id
= D.dept_id ORDER BY Salary DESC;
iii. SELECT max(Salary) FROM Employees WHERE dob>’1995-12-31’;
iv. SELECT dept_id, count(*) from Employees GROUP BY dept_id HAVING
count(*)>1;
Q32 def addPlayer(name, matches, goals): 4

player_data = [name, matches, goals]
with open('FOOTBALL.CSV', 'a', newline='') as csvfile:
writer = csv.writer(csvfile)
writer.writerow(player_data)
def highestAverage():
Page 4 of 7
max_average = 0
best_player = ''
with open('FOOTBALL.CSV', 'r') as csvfile:
reader = csv.reader(csvfile)
next(reader) # Skip the header row if it exists
for row in reader:
name, matches, goals = row[0], int(row[1]), int(row[2])
if matches > 0:
average = goals / matches
if average > max_average:
max_average = average
best_player = name
if best_player:
print(best_player)
else:
print("No player data found in the CSV file.")
SECTION E
Q33 a) Tagore, as it has maximum number of computers. Housing the server here will reduce 1x5
the external traffic. =5
b) Firewall S
c) Ethernet Cable T R
25 m
90 m
A
75 m
d) Wi-Fi Router / Access Points

e) Switch, as hub will create the broadcast traffic.
Page 5 of 7
Q34 (i) 1 Mark for 1 difference point 2+3
=5
(ii)
import pickle
def search(app):
f = open(‘PASSWORDS.DAT’, ‘rb’)
while True:
try:
obj = pickle.load(f)
if obj[0] == app:
print(obj)
break
except:
break
f.close()
OR
(i) rb, rb+ will give error, while ab and wb+ modes will create the file (1/2 mark each)
(ii)
import pickle
def filterStudents(clas, sec):
fin = open('STUDENTS.DAT', 'rb')
fout = open('FILTERED.DAT', 'wb')
while True:
try:
stu = pickle.load(fin)
if stu[2] == clas and stu[3] == sec:
pickle.dump(stu, fout)
except:
break
Page 6 of 7
Q35 (i) ½ + ½ 1+4
=5
import mysql.connector as ms
conn = ms.connect(host="localhost",
user="heerakh",
passwd='happy',
db='sports')
cur = conn.cursor()
pid = int(input("Enter player ID : "))
pname = input("Enter name : ")
inn = int(input("Enter innings : "))
runs = int(input("Runs Scored : "))
wickets = int(input("Wickets : "))
query = f"insert into cricket values({pid}, '{pname}', {innings}, {runs}, {wickets})"
try:
cur.execute(query)
print("Row inserted")
except:
print("SQL Error")
conn.close()
OR
(i) ½ + ½
(ii)
import mysql.connector as ms
conn = ms.connect(host="localhost",
user="keshav",
passwd='karma',
db='sports')
cur = conn.cursor()
query = "select pname from cricket where innings>100"
cur.execute(query)
for row in cur.fetchall():
print(row[0])
conn.close()
o——| End of Paper |——o
Page 7 of 7
PB23CS01
KENDRIYA VIDYALAYA SANGATHAN ERNAKULAM REGION

PRE-BOARD EXAMINATION 2023-24
 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.
Q.NO QUESTION MARKS
SECTION - A
1 Which of the following is a keyword in Python?
a) true b) For c) pre-board d) False 1
2 What will be the output for the following Python statement?

print(20//3*2+(35//7.0))
1
a) 17.0 b) 17 c) 8.5 d) 8
3 In MYSQL database, if a table, BOOK has degree 8 and cardinality 7, and

another table, SALE has degree 4 and cardinality 7, what will be the degree and
1
cardinality of the Cartesian product of BOOK and SALE ?
a) 32 , 49 b) 12, 49 c) 12 ,14 d) 32,14
4 What is “ C “ stands in TCP/IP ?
1
a) Common b) Centre c)Control d) Coordinate
5 What is printed by the following statements?
ANIMAL={"dog":10,"tiger":5,"elephant":15,"Cow":3}
1
print("Tiger" not in ANIMAL)
a) True b)False c)Error d) None
6 Consider the following statements and choose the correct output from the given
options :
EXAM="COMPUTER SCIENCE" 1
print(EXAM[:12:-2])
a) EN b) CI c)SCIENCE d) ENCE
7 What will be the output of the following code ?
1
Tuple1=(10,)
1
Tuple2=Tuple1*2
print(Tuple2)
a) 20 b) (20,) c) (10,10) d) Error
8 Fill in the blanks:
The SQL keyword ---------------- is used in SQL expression to select records 1
based on patterns
9 What possible outcome will be produced when the following code is executed?
import random
value=random.randint(0,3)
fruit=["APPLE","ORANGE","MANGO","GRAPE"]
for i in range(value):
print(fruit[i],end='##')
print()
a) APPLE##
1
b) APPLE#
ORANGE##
c) APPLE## ORANGE##
d) ORANGE##
MANGO##
APPLE##
10 Select the network device from the following, which connects, networks with
different protocols 1
a) Bridge b)Gateway c)Hub d) Router
11 State whether the following statement is TRUE or FALSE :
1
The value of the expression 4/3*(2-1) and 4/(3*(2-1)) is the same
12 In the relational models , cardinality actually refers to --------------
a) Number of tuples b) Number of attributes 1
c) Number of tables d) Number of constraints
13 Data structure STACK is also known as ----------- list
a)First In First Out b) First In Last Out 1
c)Last In First Out d) Last In Last Out
14 Which function is used to write a list of strings in a file?
1
a) writeline( ) b) writelines( ) c) write() d) writeall( )
15 Which of the following is NOT a guided communication medium?
a) Twisted pair cable b) Microwave 1
c) Coaxial cable d) Optical fibre
16 Which of the following function header is correct?
a) def fun(a=1,b):
b) def fun(a=1,b,c=2): 1
c) def fun(a=1,b=1,c=2):
d) def fun(a=1,b=1,c=2,d):
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
2
(d) A is false but R is True
17 Assertion ( A): In SQL, the aggregate function avg() calculates the average
value on a set of values and produces a single result.
Reason ( R): The aggregate functions are used to perform some fundamental 1
arithmetic tasks such as min(), max(), sum() etc
18 Assertion(A): Python overwrites an existing file or creates a non-

existing file when we open a file with ‘w’ mode.
1
Reason(R): a+ mode is used only for writing operations
SECTION - B
19 i) Expand the following :
a) SMTP b) VoIP
ii) Give one disadvantage of Star topology
1+1=2
OR
i) What is a web browser ?
ii) Define the term MAC Address
20 Rewrite the following code in Python after removing all syntax error(s) and
underline each correction done in the code .
30 = num
for k in range(0,num)
2
IF k%4==0 :
print(k*4)
Else:
print(k+3)
21 Write a function letter_count(lst) that takes a list of string and returns a
dictionary where the keys are the letters from lst and the values are the number
of times that letter appears in the lst.
For example: if the passed list, lst is :
lst=list(“apple”)
2
Then it should return a dictionary as {‘a’:1,’p’:2,’l’:1,’e’:1}
OR
Write a function max_length( ) ,that takes a list of string as argument and
display the longest string from the list.
22 Predict the output of the following code:
lst=[2,4,6,8,10]
for i in range(1,5):
2
lst[i-1]=lst[i]
print(lst[i],end=' ')
23 Consider the following list of elements and write Python statement to print the
output of each question.
elements=['apple',200,300,'red','blue','grapes'] 2
i) print(elements[3:5])
ii) print(elements[::-1])
3
OR
Consider the following list exam and write Python statement for the following
questions:
exam=[‘english’,’physics’,’chemistry’,’cs’,’biology’]
i) To insert subject “maths” as last element
ii) To display the list in reverse alphabetical order
24 Satheesh has created a database “school” and table “student”. Now he wants to
view all the databases present in his laptop. Help him to write SQL command
for that , also to view the structure of the table he created.
OR
2
Meera got confused with DDL and DML commands. Help her to select only
DML command from the given list of command.
UPDATE , DROP TABLE, SELECT , CREATE TABLE , INSERT INTO,
DELETE , USE
25 Predict the output for the following Python snippet
def calc(p,q=3):
ans=1
for x in range(q):
ans=ans*p 2
return ans
power=calc(3)
print(power,'9')
power=calc(3,2)
print(power,'27')
SECTION C
26 Predict the output of the Python code given below:
def calculate(str):
text=''
x=range(len(str)-1)
for i in x:
if str[i].isupper():
text+=str[i]
elif str[i].islower(): 3
text+=str[i+1]
else:
text+='@'
return text
start='Pre-board Exam'
final=calculate(start)
print(final)
4
27 Consider the following table DOCTOR given below and write the output of the
SQL Queries that follows :
D_ID D_NAME D_DEPT GENDER EXPERIENCE

101 JOSEPH ENT MALE 10
104 GUPTA MEDICINE MALE 12
106 SUMAN ORTHO FEMALE 7
111 HANEEF ENT MALE 12 3
123 DEEPTI CARDIOLOGY FEMALE 6
132 VEENA SKIN FEMALE 12
i) SELECT D_NAME FROM DOCTOR WHERE GENDER=MALE
AND EXPERIENCE=12 ;
ii) SELECT DISTINCT(D_DEPT) FROM DOCTOR ;
iii) SELECT D_NAME , EXPERIENCE FROM DOCTOR ORDER BY
EXPERIENCE ;
28 Write a function in Python to count the number of lines in a text fie ‘EXAM.txt’
which start with an alphabet ‘T’ .
OR 3
Write a function in Python that count the number of “can” words present in a
text file “DETAILS.txt” .
29 Consider the following Table “TEACHER”
T_ID NAME AGE SEX DEPT D_O_JOIN SALARY

902 SANDEEP 45 M COMPUTER 10/10/2002 56000
813 SANGEETA 34 F HISTORY 24/9/2010 50000
771 JOEL 48 M ENGLISH 4/5/2001 67900
703 MANVITH 36 M MATHS 27/09/2012 48000
606 NEENA 32 F ENGLISH 23/5/2013 40000
537 ABHILASH 42 M MATHS 6/2/2006 47000
420 MUHSIN 49 M ENGLISH 8/3/2003 70450 3
412 SUBESH 52 M HINDI 10/11/1999 60500
345 RENJINI 36 F COMPUTER 27/4/2010 45000
218 DEEPTI 28 F HINDI 2/2/2016 40000
160 SHUBHAM 39 M SCIENCE 19/9/2011 45000
Based on the above table, Write SQL command for the following :
i) To show all information about the teacher of maths department
ii) To list name and department whose name starts with letter ‘M’
iii) To display all details of female teacher whose salary in between
35000 and 50000
5
30 Thushar received a message(string) that has upper case and lower-case alphabet.
He want to extract all the upper case letters separately .Help him to do his task
by performing the following user defined function in Python:
a) Push the upper case alphabets in the string into a STACK
3
b) Pop and display the content of the stack.
For example:
If the message is “All the Best for your Pre-board Examination”
The output should be : E P B A
SECTION D
31 Consider the table PRODUCT and CLIENT given below:
PRODUCT
PR_ID PR_NAME MANUFACTURER PRICE QTY
BS101 BATH SOAP PEARSE 45.00 25
SP210 SHAMPOO SUN SILK 320.00 10
SP235 SHAMPOO DOVE 455.00 15
BS120 BATH SOAP SANTOOR 36.00 10
TOOTH
TB310 COLGATE 48.00 15
BRUSH
FW422 FACE WASH DETOL 66.00 10
BS145 BATH SOAP DOVE 38.00 20
4
CLIENT
C_ID C_NAME CITY PR_ID
01 DREAM MART COCHIN BS101
02 SHOPRIX DELHI TB310
03 BIG BAZAR DELHI SP235
04 LIVE LIFE CHENNAI FW422
Write SQL Queries for the following:
i) Display the details of those clients whose city is DELHI
ii) Increase the Price of all Bath soap by 10
iii) Display the details of Products having the highest price
iv) Display the product name, price, client name and city with their
corresponding matching product Id.
32 Gupta is writing a program to create a csv file “employee.csv” which will
contain user name and password for department entries. He has written the
following code . As a programmer, help him to successfully execute the given
task.
import ---------------- #statement 1
def add_emp(username,password):
4
f=open(‘employee.csv’, ’----------‘) # statement 2
content=csv.writer(f)
content.writerow([username,password])
f.close()
def read_emp( ):
with open (‘employee.csv’,’r’) as file:
6
content_reader=csv.-------------------(file) # statement 3
for row in content_reader:
print(row[0],row[1])
file.close( )
add_emp(‘mohan’,’emp123#’)
add_emp(‘ravi’,’emp456#’)
read_emp() #statement 4
i) Name the module he should import in statement 1
ii) In which mode , Gupta should open the file to add record in to the
file ? (statement 2)
iii) Fill in the blank in statement 3 to read the record from a csv file
iv) What output will he obtain while executing statement 4 ?
SECTION E
33 Oxford college, in Delhi is starting up the network between its different wings.
There are four Buildings named as SENIOR, JUNIOR, ADMIN and HOSTEL
as shown below:
JUNIOR SENIOR ADMIN HOSTEL

The distance between various building is as follows:
ADMIN TO SENIOR 200 m
ADMIN TO JUNIOR 150 m
ADMIN TO HOSTEL 50 m
SENIOR TO JUNIOR 250 m
SENIOR TO HOSTEL 350 m
JUNIOR TO HOSTEL 350 m
Number of computer in each building is :
5
SENIOR 130
JUNIOR 80
ADMIN 160
HOSTEL 50
i) Suggest the cable layout of connections between the buildings.

ii) Suggest the most suitable place (i.e., building) to house the server of
this college, provide a suitable reason.
iii) Is there a requirement of a repeater in the given cable layout? Why/
Why not?
iv) Suggest the placement of hub/switch with justification.
v) The organisation also has inquiry office in another city about 50-60
km away in hilly region. Suggest the suitable transmission media to
interconnect to college and inquiry office out of the following:
a. Fiber optic cable
b. Microwave
c. Radiowave
7
34 i) What is Pickling or Serialization?
ii) A binary file “salary.DAT” has structure [employee id, employee
name, salary]. Write a function countrec() in Python that would read
contents of the file “salary.DAT” and display the details of those
employee whose salary is above 20000.
OR 2+3=5
i) What is the difference between ‘r’ and ‘rb’ mode in Python file ?
ii) A binary file “STUDENT.DAT” has structure [admission_number,
Name, Percentage]. Write a function countrec() in Python that would
read contents of the file “STUDENT.DAT” and display the details of
those students whose percentage is above 90. Also display number
of students scoring above 90%
35 i) What do you mean by a Primary key in RDBMS ?
ii) Complete the following database connectivity program by writing
the missing statements and performing the given query
import ------------------- as mysql # statement 1
con=mysql. ---------(host=’localhost’,user=’root’,passwd=’123’ ,
database=’student’) # statement 2
cursor=con.cursor( )
cursor.execute(--------------------------------) # statement 3
data=cursor. ----------------------------------- # statement 4
for rec in data:
print(rec)
con.close( )
a) Complete the statement 1 by writing the name of package need to be
imported for database connectivity .
b) Complete the statement 2 by writing the name of method require to
create connection between Python and mysql.
c) Complete the statement 3 by writing the query to display those
students record whose mark is between 50 and 90 from table 1+4=5
“student”
d) Complete the statement 4 to retrieve all records from the result set.
OR
i) What is the difference between UNIQUE and PRIMARY KEY
constraints ?
ii) Maya has created a table named BOOK in MYSQL database,
LIBRARY
BNO(Book number )- integer
B_name(Name of the book) - string
Price (Price of one book) –integer
Note the following to establish connectivity between Python and

MySQL: Username – root, Password – writer,Host – localhost.
Maya, now wants to display the records of books whose price is

more than 250. Help Maya to write the program in Python
************************************
8
PB23CS01
KENDRIYA VIDYALAYA SANGATHAN

ERNAKULAM REGION
1st PRE BOARD EXAMINATION 2023 – 24

Class: XII
MARKING SCHEME
Q.NO QUESTION MARKS
SECTION - A
1 Which of the following is a keyword in Python ?
a) true b) For c) pre-board d) False 1
2 What will be the output for the following Python statement ?
print(20//3*2+(35//7.0))
1
a) 17.0 b) 17 c) 8.5 d) 8
3 In MYSQL database, if a table, BOOK has degree 8 and cardinality 7, and

another table, SALE has degree 4 and cardinality 7, what will be the degree and
1
cardinality of the Cartesian product of BOOK and SALE ?
b) 32 , 49 b) 12, 49 c) 12 ,14 d) 32,14
4 What is “ C “ stands in TCP/IP ?
1
a) Common b) Centre c)Control d) Coordinate
5 What is printed by the following statements ?
ANIMAL={"dog":10,"tiger":5,"elephant":15,"Cow":3}
1
print("Tiger" not in ANIMAL)
a) True b)False c)Error d) None
6 Consider the following statements and choose the correct output from the given
options :
EXAM="COMPUTER SCIENCE" 1
print(EXAM[:12:-2])
a) EN b) CI c)SCIENCE d) ENCE
7 What will be the output of the following code ?
Tuple1=(10,)
1
Tuple2=Tuple1*2
print(Tuple2)
1
a) 20 b) (20,) c) (10,10) d) Error
8 Fill in the blanks :
The SQL keyword ---------------- is used in SQL expression to select records
1
based on patterns
LIKE
9 What possible outcome will be produced when the following code is executed ?
import random
value=random.randint(0,3)
fruit=["APPLE","ORANGE","MANGO","GRAPE"]
for i in range(value):
print(fruit[i],end='##')
print()
a) APPLE## 1
b) APPLE#
ORANGE##
c) APPLE## ORANGE##
d) ORANGE##
MANGO##
APPLE##
10 Select the network device from the following ,which connects , networks with
different protocols 1
a) Bridge b)Gateway c)Hub d) Router
11 State whether the following statement is TRUE or FALSE :
The value of the expression 4/3*(2-1) and 4/(3*(2-1)) is the same 1
TRUE
12 In the relational models , cardinality actually refers to --------------
a) Number of tuples b) Number of attributes 1
c) Number of tables d) Number of constraints
13 Data structure STACK is also known as ----------- list
a)First In First Out b) First In Last Out 1
c)Last In First Out d) Last In Last Out
14 Which function is used to write a list of strings in a file ?
1
a) Writeline( ) b) writelines( ) c) write() d) writeall( )
15 Which of the following is NOT a guided communication medium ?
a) Twisted pair cable b) Microwave 1
c)Coaxial cable d) Optical fibre
16 Which of the following function headers is correct ?
a) def fun(a=1,b):
b) def fun(a=1,b,c=2): 1
c) def fun(a=1,b=1,c=2):
d) def fun(a=1,b=1,c=2,d):
correct choice as
2
17 Assertion ( A): In SQL, the aggregate function avg() calculates the average
value on a set of values and produces a single result.
Reason ( R): The aggregate functions are used to perform some fundamental
1
arithmetic tasks such as min(), max(), sum() etc
18 Assertion(A): Python overwrites an existing file or creates a non-
existing file when we open a file with ‘w’ mode.
Reason(R): a+ mode is used only for writing operations
1
SECTION - B
19 i) Expand the following :
a) SMTP : Simple Mail Transfer Protocol
b) VoIP : Voice Over Internet Protocol
ii) Give one disadvantage of Star topology
Star topology has a single point of failure. If the central hub or switch fails,
the entire network will be down. This can be a major problem for networks
that require high availability. Or any other dis advantage.
OR
i) What is a web browser ?
A software application used to access information on the World Wide Web is 1+1=2
called a Web Browser. When a user requests some information, the web browser
fetches the data from a web server and then displays the webpage on the user's
screen.
ii) Define the term MAC Address
A MAC address (media access control address) is a 12-digit hexadecimal

number assigned to each device connected to the network. Primarily specified as
a unique identifier during device manufacturing, the MAC address is often
found on a device's network interface card (NIC).
20 Rewrite the following code in Python after removing all syntax error(s) and
underline each correction done in the code .
num=30
for k in range(0,num): ½ mark
if k%4==0 : each
print(k*4)
else:
print(k+3)
21 Write a function letter_count( lst) that takes a list of string and returns a
dictionary where the keys are the letters from lst and the values are the number
2
of times that letter appears in the lst.
For example: if the passed list is :
3
Lst=list(“apple”)
Then it should return a dictionary as {‘a’:1,’p’:2,’l’:1,’e’:1}
OR
Write a function max_length( ) ,that takes a list of string as argument and
display the longest string from the list.
Correct Program : 2 Marks
22 Predict the output of the following code:
lst=[2,4,6,8,10]
lst[i-1]=lst[i] 2
print(lst[i],end=' ')
output:
4 6 8 10 10
23 Consider the following list of elements and write Python statement to print the
output of each questions.
elements=['apple',200,300,'red','blue','grapes']
i) print(elements[3:5])
['red', 'blue']
ii) print(elements[::-1])
['grapes', 'blue', 'red', 300, 200, 'apple'] 2
OR
Consider the following list exam and write Python statement for the following
questions:
i) To insert subject “maths” as last element
exam.append(‘maths’)
ii) To display the list in reverse alphabetical order
exam.sort(reverse=True)
24 Satheesh has created a database “school” and table “student”. Now he wants to
view all the databases present in his laptop. Help him to write SQL command
for that , also to view the structure of the table he created.
SHOW DATABASES
2
DESCRIBE/DESC student
OR
Meera got confused with DDL and DML commands. Help her to select only
DML command from the given list of command.
4
UPDATE , DROP TABLE, SELECT , CREATE TABLE , INSERT INTO,
DELETE , USE
DML: UPDATE,SELECT,INSERT INTO,DELETE

25 Predict the out put for the following Python snippet
def calc(p,q=3):
ans=1
for x in range(q):
ans=ans*p
return ans
power=calc(3) 2
print(power,'9')
power=calc(3,2)
print(power,'27')
OUTPUT:
27 9
9 27
SECTION C
26 Predict the output of the Python code given below:
def calculate(str):
text=''
x=range(len(str)-1)
for i in x:
if str[i].isupper():
text+=str[i]
elif str[i].islower():
text+=str[i+1]
3
else:
text+='@'
return text
start='Pre-board Exam'
final=calculate(start)
print(final)
OUTPUT:
Pe-@oard @Eam
5
27 Consider the following table DOCTOR given below and write the out put of the
SQL Queries that follows :
D_ID D_NAME D_DEPT GENDER EXPERIENCE

101 JOSEPH ENT MALE 10
104 GUPTA MEDICINE MALE 12
106 SUMAN ORTHO FEMALE 7
111 HANEEF ENT MALE 12
123 DEEPTI CARDIOLOGY FEMALE 6
132 VEENA SKIN FEMALE 12
i) SELECT D_NAME FROM DOCTOR WHERE GENDER=MALE
AND EXPERIENCE=12 ;
GUPTA
HANEEF 3
ii) SELECT DISTINCT(D_DEPT) FROM DOCTOR ;
DISTINCT(D_DEPT)
ENT
MEDICINE
ORTHO
CARDIOLOGY
SKIN
iii) SELECT D_NAME , EXPERIENCE FROM DOCTOR ORDER BY
EXPERIENCE;
D_NAME EXPERIENCE
DEEPTI 6
SUMAN 7
JOSEPH 10
GUPTA 12
HANEEF 12
VEENA 12
28 Write a function in Python to count the number of lines in a text fie ‘EXAM.txt’
which start with an alphabet ‘T’ .
Correct function prototype ½ mark

Correct opening text file statement ½ mark
Correct logic 1 and ½ marks
Closing the file ½ mark 3
OR
Write a function in Python that count the number of “can” words present in a
text file “DETAILS.txt” .
def count_word():
count=0
6
f=open("textfiles.txt","r")
contents=f.read()
word=contents.split()
for i in word:
if i==’can’:
count+=1
print("Number of words in the File is :",count )
f.close()
count_word()
Correct function prototype ½ mark

Correct opening text file statement ½ mark
Correct logic 1 and ½ marks
Closing the file ½ mark
29 Consider the following Table “TEACHER”
T_ID NAME AGE SEX DEPT D_O_JOIN SALARY

902 SANDEEP 45 M COMPUTER 10/10/2002 56000
813 SANGEETA 34 F HISTORY 24/9/2010 50000
771 JOEL 48 M ENGLISH 4/5/2001 67900
703 MANVITH 36 M MATHS 27/09/2012 48000
606 NEENA 32 F ENGLISH 23/5/2013 40000
537 ABHILASH 42 M MATHS 6/2/2006 47000
420 MUHSIN 49 M ENGLISH 8/3/2003 70450
412 SUBESH 52 M HINDI 10/11/1999 60500
1MARK
345 RENJINI 36 F COMPUTER 27/4/2010 45000
EACH
218 DEEPTI 28 F HINDI 2/2/2016 40000
160 SHUBHAM 39 M SCIENCE 19/9/2011 45000
Based on the above table , Write SQL command for the following :
i) To show all information about the teacher of maths department
SELECT * FROM TEACHER WHERE DEPT=’MATHS’;
ii) To list name and department whose name starts with letter ‘M’
SELECT NAME,DEPT FROM TEACHER WHERE NAME LIKE ‘M%’;
iii) To display all details of female teacher whose salary in between
35000 and 50000
SELECT * FROM TEACHER WHERE SEX=’F’ AND SALARY BETWEEN
35000 AND 50000 ;
30 Thushar received a message(string) that has upper case and lower case 1 mark
alphabet.He want to extract all the upper case letters separately .Help him to do for push
his task by performing the following user defined function in Python: (), 1 mark
7
a) Push the upper case alphabets in the string into a STACK for pop()
b) Pop and display the content of the stack. and 1
For example: mark for
If the message is “All the Best for your Pre-board Examination” displaying
The output should be: E P B A
Ans:
def push(s,ch):
s.append(ch)
def pop(s):
if s!=[]:
return s.pop()
else:
return None
string=“All the Best for your Pre-board Examination”
st=[]
for ch in string:
if ch.isupper():
push(st,ch)
while True:
item=pop(st)
if item!=None:
print(item,end= ‘ ‘)
else:
break
SECTION D
31 Consider the table PRODUCT and CLIENT given below:
PR_ID PR_NAME MANUFACTURER PRICE QTY

BS101 BATH SOAP PEARSE 45.00 25
SP210 SHAMPOO SUN SILK 320.00 10
SP235 SHAMPOO DOVE 455.00 15
BS120 BATH SOAP SANTOOR 36.00 10
TOOTH
TB310 COLGATE 48.00 15
BRUSH 1 mark
FW422 FACE WASH DETOL 66.00 10 each
BS145 BATH SOAP DOVE 38.00 20
PRODUCT
C_ID C_NAME CITY PR_ID
01 DREAM MART COCHIN BS101
02 SHOPRIX DELHI TB310
03 BIG BAZAR DELHI SP235
04 LIVE LIFE CHENNAI FW422
8
Write SQL Queries for the following :
i) Display the details of those clients whose city is DELHI
SELECT * FROM CLIENT WHERE CITY=’DELHI’;
ii) Increase the Price of all Bath soap by 10
UPDATE PRODUCT SET PRICE=PRICE+10 WHERE PR_NAME=’BATH
SOAP’;
iii) Display the details of Products having the highest price
SELECT * FROM PRODUCT WHERE PRICE=(SELECT MAX(PRICE)
FROM PRODUCT) ;
iv) Display the product name , price, client name and city with their
corresponding matching product Id .
SELECT PR_NAME , PRICE ,C_ID, CITY FROM PRODUCT , CLIENT
WHERE PRODUCT.PR_ID=CLIENT.PR_ID ;
32 Gupta is writing a program to create a csv file “employee.csv” which will

contain user name and password for department entries. He has written the
following code. As a programmer, help him to successfully execute the given
task.
import ---------------- #statement 1

def add_emp(username,password):
f=open(‘employee.csv’, ’----------‘) # statement 2
content=csv.writer(f)
content.writerow([username,password])
f.close()
def read_emp( ):
with open (‘employee.csv’,’r’) as file:
content_reader=csv.-------------------(file) # statement 3
for row in content_reader:
print(row[0],row[1]) 4
file.close( )
add_emp(‘mohan’,’emp123#’)
add_emp(‘ravi’,’emp456#’)
read_emp() #statement 4
i) Name the module he should import in statement 1

import csv
ii) In which mode , Gupta should open the file to add record in to the
file ? (statement 2)
Mode a
iii) Fill in the blank in statement 3 to read the record from a csv file
reader
iv) What output will he obtain while executing statement 4 ?
mohan emp123#
ravi emp456#
9
SECTION E
33 Oxford college, in Delhi is starting up the network between its different wings.
There are four Buildings named as SENIOR, JUNIOR, ADMIN and HOSTEL
as shown below:
JUNIOR SENIOR ADMIN HOSTEL
The distance between various building is as follows:
ADMIN TO SENIOR 200 m

ADMIN TO JUNIOR 150 m
ADMIN TO HOSTEL 50 m
SENIOR TO JUNIOR 250 m
SENIOR TO HOSTEL 350 m
JUNIOR TO HOSTEL 350 m
Number of computer in each building is :
SENIOR 130
1 mark
JUNIOR 80 each
ADMIN 160
HOSTEL 50
i) Suggest the cable layout of connections between the buildings.
ADMIN
SENIOR
JUNIOR HOSTEL
ii) Suggest the most suitable place (i.e., building) to house the server of
this college , provide a suitable reason.
ADMIN, as number of computers are more in ADMIN building
10
iii) Is there a requirement of a repeater in the given cable layout? Why/
Why not?
Yes, between ADMIN TO JUNIOR and ADMIN TO SENIOR distance is more

than 100 m.
iv) Suggest the placement of hub/switch with justification.
In all building as it is required to connect all computers in to a network.
v) The organisation also has inquiry office in another city about 50-60
km away in hilly region. Suggest the suitable transmission media to
interconnect to college and inquiry office out of the following :
a. Fiber optic cable
b. Microwave
c. Radiowave
Radio wave
34 i) What is Pickling or Serialization?
The process of converting Python object hierarchy into byte stream so that it can
be written into a file.
ii) A binary file “salary.DAT” has structure [employee id, employee
name, salary]. Write a function countrec() in Python that would read
contents of the file “salary.DAT” and display the details of those
employee whose salary is above 20000.
def countrec():
num=0
fobj=open(“salary.dat”,’rb’)
try:
while True:
rec=pickle.load(fobj)
if rec[2]> 20000:
print(rec[0],rec[1],rec[2])
2+3=5
except:
fobj.close()
OR
i) What is the difference between ‘r’ and ‘rb’ mode in Python file ?
r is used to read text files and rb is used to read binary files
ii) A binary file “STUDENT.DAT” has structure [admission_number,
Name, Percentage]. Write a function countrec() in Python that would
read contents of the file “STUDENT.DAT” and display the details of
those students whose percentage is above 90. Also display number of
students scoring above 90%
import pickle
def countrec():
fobj=open(‘student.dat’,’rb’)
num=0
try:
11
while True:
rec=pickle.load(fobj)
if rec[2]>90:
num=num+1
print(re[0],rec[1],rec[2])
except:
fobj.close()
return num
35
i) What do you mean by a Primary key in RDBMS ?
In the relational model of databases, a primary key is a specific choice of a
minimal set of attributes that uniquely specify a tuple in a relation.
ii) Complete the following database connectivity program by writing
the missing statements and performing the given query
import ------------------- as mysql # statement 1
con=mysql. ---------(host=’localhost’,user=’root’,passwd=’123’ ,
database=’student’) # statement 2
cursor=con.cursor( )
cursor.execute(--------------------------------) # statement 3
data=cursor. ----------------------------------- # statement 4
for rec in data:
print(rec)
con.close( )
i) Complete the statement 1 by writing the name of package
need to be imported for database connectivity .
mysql.connector
ii) Complete the statement 2 by writing the name of method
require to create connection between Python and mysql. 1+4=5
connect()
iii) Complete the statement 3 by writing the query to display
those students record whose mark is between 50 and 90
from table “student”
select * from student where mark between 50 and 90
iv) Complete the statement 4 to retrieve all records from the
result set.
cursor.fetchall()
OR
i) What is the difference between UNIQUE and PRIMARY KEY

constraints ?
The difference between a UNIQUE constraint and a Primary Key is
that per table may only have one Primary Key but may define more
than one UNIQUE constraints
12
ii) Maya has created a table named BOOKt in MYSQL database,
LIBRARY
BNO(Book number )- integer
B_name(Name of the book) - string
Price (Price of one book) –integer
MySQL:
Username - root
Password - writer
Host – localhost
Maya, now wants to display the records of books whose price is

more than 250. Help Maya to write the program in Python
1 mark each for creating connection object,

Creating cursor,
Writing sql command
13
क ीय िव ालय संगठन, जयपुर संभाग
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:

1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A has 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35
against part c only.
खंड / SECTION-A
सं / Question अंक /
Q. No. Marks
1. State True or False 1
“break keyword skips remaining part of an iteration in a loop and compiler goes to
starting of the loop and executes again”
2. Find the valid keyword from the following? 1
a) Student-Name b) False c) 3rdName d) P_no
3. What will be the output for the following Python statement? 1
X={‘Sunil’:190, ‘Raju’:10, ‘Karambir’:72, ‘Jeevan’:115}
print(‘Jeevan’ in X, 190 in X, sep=”#”)
(a)True#False (b) True#True
(c) False#True (d) False#False
4. Consider the given expression: 1
True and False or not True
Which of the following will be correct output if the given expression is evaluated?
(a) True (b) False
(b) (c) NONE (d) NULL
5. Select the correct output of the code: 1
a = "Python! is amazing!"
a = a.split('!')
b = a[0] + "." + a[1] + "." + a[2]
print (b)
(a) Python!. is amazing!. (b) Python. is amazing.
(c) Python. ! is amazing.! (d) will show error
6. Which of the following mode in file opening statement overwrite the existing 1
content?
(a) a+ (b) r+
(c) w+ (d) None of the above
7. The attribute which have properties to be as referential key is known as. 1
(a) foreign key (b)alternate key
(c) candidate key (d) Both (a) and (c)
8. Which command is used to change some values in existing rows? 1
(a) CHANGE (b) MODIFY
(b) (c) ALTER (d) UPDATE
9. Which of the following statement(s) would give an error after executing the 1
following code?
Q="Humanity is the best quality" # Statement1
print(Q) # Statement2
Q="Indeed.” # Statement3
Q[0]= '#' # Statement4
Q=Q+"It is." # Statement5
(a) Statement 3 (b) Statement 4 (c)Statement 5 (d)Statement 4 and 5
10. p=150 1
def fn(q):
______________ #missing statement
p=p+q
fn(50)
print(p)
Which of the following statements should be given in the blank for #missing
statement if the output produced is 200
(a) global p=150 (b) global p
(c) p=150 (d) global q
11. Which function is used to split a line of string in list of words? 1
(a)split( ) (b) splt( )
(c) split_line( ) (d) all of these
12. What possible output(s) will be obtained when the following code is executed 1
import random
k=random.randint(1,3)
fruits=[‘mango’, ‘banana’, ‘grapes’, ‘water melon’, ‘papaya’]
for j in range(k):
print(j, end=“*”)
(a) mango*banana*grapes (b) banana*grapes
(c) banana*grapes*watermelon (d) mango*grapes*papaya
13. Fill in the blank: 1
is a communication protocol responsible for sending emails.
(a) TCP (b) SMTP (c) PPP (d)HTTP
14. What will be the ouput when following expression be evaluated in Python? 1
print(21.5 // 4 + (8 + 3.0))
(a) 16 (b)14.0 (c) 15 (d) 15.5
15. Which of the following functions other than close() writes the buffer data to file 1
(a) push() (b) write() (c) writeBuffer() (d) flush()
16. To get counting of the returned rows, you may use……………. 1
(a) cursor.rowcount (b) cursor.count
(c) cursor.countrecords() (d) cursor.manyrecords()
(b) Both A and R are true and R is not the correct explanation for A
17. Assertion (A):- If the arguments in function call statement are provided in the format 1
parameter=argument, it is called keyword arguments.
Reasoning (R):- During a function call, the argument list first contain keyword
argument(s) followed by positional argument(s).
18. Assertion (A): CSV (Comma Separated Values) is a file format for data storage with one 1
record on each line and each field is separated by comma.
Reason (R): The format is used to share data between cross platform as text editors are
available on all platforms.
खंड / SECTION-B
19. Rewrite the following code in python after removing all syntax error(s). Underline each 2
correction done in the code.
Num=int(rawinput("Number greater than 10 :"))
sum=0
for i in range(10,Num,3)
sum+=1
if i%2=0:
print(i*2)
else:
print(i*3)
print(sum)
20. Write one advantage and one disadvantage of packet switching 2
OR
Which language is the most suitable language to create web pages?
21. (a)Given is a Python string : 1
X=”Kendriya Vidyalaya sangathan”
Write the output of: print(X[4:9]*2)
(b) Write the output of the python program code given below:
1
hello = {empname: "Ishan", address: ”New Delhi”, salary: 10000}
hello[salary] = 15000
hello[address] = "Delhi"
print(hello.keys())
22. Explain the use of GROUP BY clause in a Relational Database Management 2
System. Give example to support your answer.
23. (a) Write the full forms of the following: 2
(i)POP3 (ii) VoIP
(b) Define RJ-45?
24. Predict the output of the Python code given below: 2
OR
Predict the output of the Python code given below:
a=tuple()
a=a + tuple(‘Python’)
print(a)
print(len(a))
b=(10,20,30)
print(len(b))
25. Differentiate Where and Having clause in SQL with example. 2
OR
Define aggregate function and give example.
खंड / SECTION-C
26. (a) Consider the following tables – Employee and Office: 1+2
Table: Emp
Emp_Id Name Salary
E01 Lakshya 54000
E02 Ravi NULL
E03 Neeraj 32000
E04 Brijesh 42000
Table: dept
Emp_Id Dept DOJ
E01 Computer 05-SEP-2007
E02 Physics 05-JAN-2008
E03 Sports 30-DEC-2000
E04 English 05-SEP-2012
What will be the output of the following statement?

SELECT Name, Dept FROM Emp E, dept d WHERE E.Emp_Id=d.Emp_Id;
(b) Consider the following tables SCHOOL and ADMIN. Give the output the following SQL
queries:
i. SELECT Designation, COUNT (*) FROM Admin GROUP BY Designation HAVING

COUNT (*) <2;
ii. SELECT TEACHER FROM SCHOOL WHERE EXPERIENCE >12 ORDER BY
TEACHER DESC;
27. Write a method beginA() in Python to read lines from a text file Notebook.TXT, and 3
display those lines, which are starting with ‘A’.
For example If the file content is as follows:
An apple a day keeps the doctor away.
We all pray for everyone’s safety.
A marked difference will come in our country.
The beginA() function should display the output as:
An apple a day keeps the doctor away.
A marked difference will come in our country.
OR
A text file “PYTHON.TXT” contains alphanumeric text. Write a program that reads this
text file and writes to another file “PYTHON1.TXT” entire file except the numbers or
digits in the file.
28. (a) Write the outputs of the SQL queries (i) to (iv) based on the relations CLUB and 3
STUDENT given below:
Table : CLUB
COACHID CNAME AGE SPORTS DATEOFAPP PAY GENDER
1 KUKREJA 35 KARATE 27/03/1996 1000 M
2 RAVINA 34 KARATE 20/01/1998 1200 F
3 KARAN 34 SQUASH 19/02/1998 2000 M
4 TARUN 33 BASKETBALL 01/01/1998 1500 M
5 ZUBIN 36 SWIMMING 12/01/1998 750 M
6 KATAKI 36 SWIMMING 24/02/1998 800 F
7 ANKITA 39 SQUASH 20/02/1998 2200 F
8 ZAREEN 37 KARATE 22/02/1998 1100 F
9 KUSH 41 SWIMMING 13/01/1998 900 M
10 SHAILYA 37 BASKETBALL 19/02/1998 1700 M
Table : STUDENT
COACHID SNAME STIPEND STREAM MARKS GRADE CLASS
1 KARAN 400.00 MEDICAL 78.5 B 12B
12 VINNET 450.00 COMMERCE 89.2 A 11C
13 VIVEK 300.00 COMMERCE 68.6 C 12C
4 DHRUV 350.00 HUMANITIES 73.1 B 12C
15 MOHIT 500.00 NONMEDICAL 90.6 A 11A
6 ANUJ 400.00 MEDICAL 75.4 B 12B
17 ABHAY 250.00 HUMANITIES 64.4 C 11A
18 PAYAL 450.00 NONMEDICAL 88.5 A 12A
19 DIKSHA 500.00 NONMEDICAL 92.0 A 12A
10 RISHIKA 300.00 COMMERCE 67.5 C 12C
i) SELECT SPORTS, MIN(PAY) FROM Club Group by SPORTS ;

ii) SELECT MAX(DATEOFAPP), MIN(DATEOFAPP) FROM CLUB;
iii) SELECT CNAME, PAY, C.COACHID, SPORTS FROM CLUB C, STUDENT S WHERE
C.COACHID =S.COACHID AND PAY>=1500;
iv) SELECT SName, CNAME FROM Student S, CLUB C
WHERE Gender =’F’ AND C.COACHID=S.COACHID;
(b) Write SQL command to list all databases.
29. Write a function shiftn(L,n), where L is a list of integers and n is an integer. The function 3
should return a list after shifting n number of elements to the left.
Example: If the list initially contains [2, 15, 3, 14, 7, 9, 19, 6, 1, 10] and n=2
then function should return [3, 14, 7, 9, 19, 6, 1, 10, 2, 15]
If the list initially contains [2, 15, 3, 14, 7, 9, 19, 6, 1, 10] and n=4
then function should return [7, 9, 19, 6, 1, 10, 2, 15, 3, 14]
30. A nested list contains the data of visitors in a museum. Each of the inner lists contains 3
the following data of a visitor:
[V_no (int), Date (string), Name (string), Gender (String M/F), Age (int)]
Write the following user defined functions to perform given operations on the stack
named "status":
(i) Push_element(Visitors) - To Push an object containing Gender of visitor who
are in the age range of 15 to 20.
(ii) Pop_element() - To Pop the objects from the stack and count and display the
number of Male and Female entries in the stack. Also, display “Done” when
there are no elements in the stack.
For example: If the list of Visitors contains:
[['305', "10/11/2022", “Geeta”,"F”, 35],
['306', "10/11/2022", “Arham”,"M”, 15],
['307', "11/11/2022", “David”,"M”, 18],
['308', "11/11/2022", “Madhuri”,"F”, 17],
['309', "11/11/2022", “Sikandar”,"M”, 13]]
The stack should contain
F
M
M
The output should be:
Female: 1
Male: 2
Done
OR
Write a function in Python, Push(EventDetails) where , EventDetails is a dictionary
containing the number of persons attending the events– {EventName :
NumberOfPersons}. The function should push the names of those events in the stack
named ‘BigEvents’ which have number of persons greater than 200. Also display the
count of elements pushed on to the stack.
For example:
If the dictionary contains the following data:
EventDetails ={"Marriage":300, "Graduation Party":1500, "Birthday Party":80,
"Get together" :150}
The stack should contain:

Marriage
Graduation Party

The count of elements in the stack is 2
खंड / SECTION-D
31. Ripunjay is planning to connect its Delhi Campus with its head office at Goregaon. Its 5*1
Delhi Campus is spread across an area of approx. 1 square kilometers consisting of 3
blocks. HR, Acad and Adm. You as a network expert have to suggest answers to the five
queries (i) to (v) raised by them.
Goregaon Delhi Campus

Office Finance
HR
Adm Acad
Shortest distances between various blocks

HR to Adm 120m
HR to Acad 75m
Acad to Adm 130m
HR to Finance 70m
Finance to Adm 90m
Goregaon to Delhi Campus 50 km
Number of computers installed at various blocks
Block Number of Computers
HR 250
Adm 30
Acad 70
Finance 20
Goregaon 20
(i) Suggest the most suitable block in the Delhi Campus to host the server. Give a
suitable reason with your suggestion.
(ii) Suggest the cable layout among the various blocks within the Delhi Campus
for connecting the blocks.
(iii) Suggest the placement of the following devices with appropriate reasons:
a. Switch / Hub
b. Repeater
(iv) Suggest a protocol that shall be needed to provide Video Conferencing solution
between Goregaon Office and Delhi campus.
(v) Suggest the type of network to connect Goregaon Office and Delhi campus.
32. (a) Write the output of the code given below: 2+3
a=5
def add(b=2):
global a
a=a+b
print(a,'#',b)
return a
b=add(a)
print(a,'#',b)
b=add(b)
print(a,'#',b)
(b) The code given below inserts the following record in the table Employee:
EmpNo – integer Name – string
Department – string Salary – integer
Note the following to establish connectivity between Python and MYSQL:
 Username is root
 Password is brick
 The table exists in a MYSQL database named organization.
 The details (EmpNo, Name, Department and Salary) are to be accepted
from the user.
Write the following missing statements to complete the code:

Statement 1 – to form the cursor object
Statement 2 – to execute the command that inserts the record in the table Student.
Statement 3- to add the record permanently in the database
import mysql.connector as mysqldef

sql_data():
con=mysql.connect(host="localhost",user="root",password="brick",
database="organization")
mycursor=_______________________ #Statement 1
eno=int(input("Enter Employee number :: "))
name=input("Enter Name :: ")
dept=input("Enter Department name :: ")
sal=int(input("Enter Salary :: "))
query="insert into student values({},'{}',{},{})".format(eno,name,dept,sal)
_______________________ #Statement 2
_______________________ # Statement 3
print("Data Added successfully")
OR
(a) Predict the output of the code given below:
a="Give me a glass of water!"
n =len(a)
b=” ”
for i in range(0, n):
if a[i] >= 'a' and a[i] <= 'k':
b = b + a[i].upper()
elif (a[i] >= 'l' and a[i] <= 'z'):
b = b + a[i-1]
elif a[i].isupper():
b = b + a[i].lower()
else:
b = b + '#'
print(b)
(a) The code given below reads the following record from the table named items and
displays only those records who have price greater than 100:
ItemNo –integer
Name – string
Price – integer

 Username is root
 Password is epic
 The table exists in a MYSQL database named store.

Statement 2 – to execute the query that extracts records of items with price greater
than 100.
Statement 3 - to read the complete result of the query (records whose marks are
greater than 75) into the object named data, from thetable studentin the
database.
import mysql.connector as mysqlcon

def sql_data():
con=mysqlcon.connect(host="localhost",user="root",password="epic",
database="store")
mycursor= #Statement1
print("Items with price greater than 100 are :")
________________________ #Statement2
data= _#Statement3
for i in data:
print(i)
33. a. What is the advantage of using a csv file for permanent storage? 2+3
b. Write a python program to create a csv file dvd.csv and write 10 records in it Dvdid,
dvd_name, qty, price. Display those dvd details whose dvd price is more than 25.
OR
a. Write difference between a binary file and a csv file.
b. Write a Program in Python that defines and calls the following user defined
functions:
(i) add() – To accept and add data of an employee to a CSV file ‘empdata.csv’. Each
record consists of a list with fieldelements as eid, ename and salary to
store empid, emp name and emp salary respectively.
(ii) search()- To display the records of the emp whose salary is more than 10000.
खंड / SECTION-E
34. Mubarak creates a table Items with a set of records to maintain the details of items. 1+1+
After creation of the table, he has entered data of 5 items in the table. 2
Table: items
ItemNo Item Scode Qty Rate LastBuy
2005 Sharpener 23 60 8 31-JUN-09
Classic
2003 Balls 22 50 25 01-FEB-10
2002 Gel Pen Premium 21 150 12 24-FEB-10
2006 Gel Pen Classic 21 250 20 11-MAR-09
2001 Eraser Small 22 220 6 19-JAN-09
Based on the data given above answer the following questions:
(i) Identify the most appropriate column, which can be considered as Primary
key.
(ii) If 3 columns are added and 2 rows are deleted from the table , what will be the
new degree and cardinality of the above table?
(iii) Write the statements to:
a. Insert the following record into the table as (2024, Point Pen, 20, 11, 350,
15-NOV-2022).
b. Increase the rate of the items by 2% whose name ends with ‘c’.
OR (Option for part iii only)
a. Delete the record of items having rate greater than equal to 10.
b. Add a column REMARKS in the table with datatype as varchar with 50
characters
35. Anamika is a Python programmer. She has written a code and created a binary file
data.dat with sid, sname and marks. The file contains 10 records.
She now has to update a record based on the sid entered by the user and update the
marks. The updated record is then to be written in the file extra.dat. The records which
are not to be updated also have to be written to the file extra.dat. If the sid is not found,
an appropriate message should to be displayed.
As a Python expert, help him to complete the following code based on requirement given
above:
import ……………. #Statement 1
def update_data():
rec={}
fin=open("data.dat","rb")
fout=open("______________________") #Statement 2
found=False
eid=int(input("Enter student id to update their marks :: "))
while True:
try:
rec= #Statement 3
if rec["student id"]==sid:
found=True
rec["marks"]=int(input("Enter new marks:: "))
pickle. #Statement 4
except:
break
if found==True:
print("The marks of student id ",sid," has been updated.")
else:
print("No student with such id is not found")
fin.close()
fout.close()
(i) Which module should be imported in the program? (Statement1)
(ii) Write the correct statement required to open a temporary file named
extra.dat. (Statement 2)
(iii) Which statement should Anamika fill in Statement 3 to read the data from the
binary file, data.dat and in Statement 4 towrite the updated data in the file,
extra.dat?
KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION
I-Pre Board Examination 2023-24
Class-12 Subject: Computer Science (083)
Answer Key
SECTION-A
QN. Answer of Question
1. False 1
2. False 1
3. True#False 1
4. False 1
5. (b)Python. is amazing. 1
6. (c) w+ 1
7. (a) foreign key 1
8. (d) UPDATE 1
9. (b) Statement 4 1
10 (b) global p 1
.
11 (a) split() 1
.
12 (a) mango*banana*grapes 1
13 (b) SMTP 1
14 Ans. (a) 16 1
15 (d) flush() 1
16 (a) cursor.rowcount 1
17 Ans. (c) A is True but R is False 1
18 Ans: (a) Both A and R are true and R is the correct explanation for A 1
SECTION-B
19. Num=int(input("Number greater than 10 :")) 2
sum=0
for i in range(10,Num,3):
Sum+=1
if i%2==0:
print(i*2)
else:
__print(i*3)
print(Sum)
20. 1 mark for any correct advantage and disadvantage each 2
OR
Hyper Text Markup Language. Yes it has pre defined tags.
21. (a) Ans: riya riya 1
(b) dict_keys(['empname', 'address', 'salary'])
1
22. Ans. GROUP BY clause is used to get the summary data based on one or more 2
groups. The groups can be formed on one or more columns. For example, the
GROUP BY query will be used to count the number of employees in each
department, or to get the department wise total salaries.
SELECT COUNT(ENAME), SUM(SALARY), DEPT
FROM EMPLOYEES
GROUP BY DEPT;
23. (i) Post office Protocol 3 2
(ii) Voice over Internet Protocol
(b) Ans: Registered Jack-45 is used as connector to connect ethernet cable
to ethernet Port in the CPU
24. Ans: 2
20000 # 100.0
100.0 $ 200
2000 # 200.0
100.0 $ 200.0
1000.0 # 100.0
100.0 $ 200.0
OR
Ans:
(‘Python’)
6
3
25. Ans. Where” clause is used to filter the records from a table 2
that is based on a specified condition, then the “Having” clause
is used to filter the record from the groups based on the
specified condition. OR
Ans. Aggregate function are group functions which works on group of

rows. Examples are sum(), min(), max(), avg(), count() etc.
SECTION-C
26. a) 1+2
Name Dept
Lakshya Computer
Ravi Physics
Neeraj Sports
Brijesh English
b)
(i) Vice principal 1
(ii) YASHRAJ
UMESH
27. Ans: 3
def beginA():
f=open(‘Notebook.TXT’)
l=f.readlines()
for i in l:
if i[0]==’A’ or i[0]= =’a’:
#or if i[0] in [“A”,”a’]
print(i)
f.close()
OR
fr=open(“PYTHON.TXT”)
fw=open(“PYTHON1.TXT”, ‘w’)
d=fr.read()
for i in d:
if not i.isdigit():
fw.write(i)
fr.close()
fw.close()
½ marks each for correct piece of code
28. Ans. (a) 3
i) Give 1 mark each correct output
SPORTS MIN(PAY)
Karate 1000
Squash 2000
Basketball 1500
Swimming 750
ii) Give 1 mark each correct output
MAX(DATEOFAPP), MIN(DATEOFAPP)
24/02/1998 27/03/1996
iii) Give 1 mark each correct output

CNAME PAY C.COACHID SPORTS
TARUN 1500 4 BASKETBALL
SHAILYA 1700 10 BASKETBALL
iv) Give 1 mark each correct output

SNAME CNAME
ANUJ KATAKI
b) Show databases;
29. def shiftn(L,n): 3
return L[n:]+L[:n]
30. visitors=[['305', '10/11/2022', 'Geeta','F', 15],['306', '10/11/2022', 'Arham','M', 3
15],\['307', "11/11/2022", 'David','M', 18],['308', "11/11/2022", 'Madhuri','F',
17]]
status=[]
def Push_Element(visitors):
global status
for i in visitors:
if i[4]>=15 and i[4]<=20:
status.append(i[3])
def Pop_Element():
global status
m,f=0,0
if status!=[]:
r=status.pop()
if r== ‘F’:
f+=1
else:
m+=1
else:
print(“Female :”,f)
print(“Male :”,m)
print("Done")
OR
def Push(EventDetails):
BigEvents=[]
count=0
for i in EventDetails:
if EventDetails[i]>200:
BigEvents.append(i)
count+=1
print(“The count of elements in the stack is”,count)
SECTION-D
31. Ans. (i) HR because it has maximum number of computers 5*1
(ii) Star topology with HR at centre (any appropriate block diagram)
(iii) Switch need to be installed in each of the block repeater where distance is
greater than 100m
(iv) VoIP
(v) WAN
32. Ans. (a) 2+3
10 # 5
10 # 10
20 # 10
20 # 20
Ans: (b)
Statement 1:
con.cursor()
Statement 2:
mycursor.execute(query)
Statement 3:
con.commit()
OR
Ans. (a) gIiE# E#A#GgAas# F# AaEe#

Ans. (b)
Statement 1: con.cursor()
Statement 2: mycursor.execute(“select Name from items where price>100”)
Statement 3: mycursor.fetchall()
33. (a) Advantage of a csv file: 2+3
It is human readable – can be opened in Excel and Notepad applications
It is just like text file
(b) ½ marks for each correct piece of code.
OR
Ans: Difference between binary file and csv file: (Any one difference may be
given) Binary file:
Binary csv
Extension is .dat Extension is .csv
Not human readable Human readable
Stores data in the form of 0s and 1s Stores data like a text file
CSV file
Program:
import csv
def add():
fout=open("empdata.csv","a",newline='\n')
wr=csv.writer(fout)
fid=int(input("Enter Emp Id :: "))
fname=input("Enter Emp name :: ")
fprice=int(input("Enter psalary :: "))
FD=[eid,ename,salary]
wr.writerow(FD)
fout.close()
def search():
fin=open("furdata.csv","r",newline='\n')
data=csv.reader(fin)
found=False
print("The Details are")
for i in data:
if int(i[2])>10000:
found=True
print(i[0],i[1],i[2])
if found==False:
print("Record not found")
fin.close()
add()
print("Now displaying")
search()
SECTION-E
34. Ans. (i) ItemNo 1+1
(ii) Cardinality=3 and Degree=9 +2
(iii)
a) Insert into items values (2024, ‘point pen’, 20, 11, 350, ‘2022-NOV-15’);
b) Update items
Set rate=rate+(rate*0.02)
Where Item like ‘%c’;
OR
iii) Delete From items where rate>=10;
b) Alter table items Add column (Remarks Varchar(50));
35. (i) pickle 1

(ii) fout=open(‘extra.dat’, ‘wb’) 1
(iii) pickle.load(fin) 1
(iv) pickle.dump(rec,fout) 1

3. Section A has 18 questions (1 to 18) carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions (19 to 25) carrying 02 marks each.
5. Section C has 05 Short Answer type questions (26 to 30) carrying 03 marks each.
6. Section D has 02 Long Answer type questions (31 to 32) carrying 04 marks each.
7. Section E has 03 questions (33 to 35) carrying 05 marks each.
8. All programming questions are to be answered using Python Language only.
Q. No. Marks
“ continue keyword is not a jump statement in a loop.”
command is used to remove a column from a table in SQL.
(a)update (b)remove (c) alter (d)drop
3. Given the following dictionaries 1
dict_stud = {"rno" : "53", "name" : ‘Rajveer Singh’}
dict_mark = {"Accts" : 87, "English" : 65}
Which statement will merge the contents of both dictionaries in dict_stud?
(a) dict_stud + dict_mark (b) dict_stud.add(dict_mark)
(c) dict_stud.merge(dict_mark) (d) dict_stud.update(dict_mark)
4. 1
print(True or not True and False)
Choose one option from the following that will be the correct output after executing
the above python expression.
a) False b) True c) or d) not
5. Which of the following commands will delete the rows of table? 1
(a) DROP command (b) DELETE Command
(c) REMOVE Command (d) ALTER Command
______is the first page that normally view at a website.
(a) First Page (b) Master Page (c) Home Page (d) Login Page
7. When a Python function does not have return statement then what it returns? 1
(a) int (b) float (c) None (d)Give Error
>>> a= "Year 2022 at All the best"
>>> a = a.split('2')
>>> a = a[0] + ". " + a[1] + ". " + a[3]
1|Page
>>> print (a)
(a) Year . 0. at All the best (b) Year 0. at All the best
(c) Year . 022. at All the best (d) Year . 0. at all the best
9. Which of the following statement(s) would give an error after executing the 1
following code?
S="Welcome to class XII" # 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
10. What will the following expression be evaluated to in Python? 1
print(2**3**2)
a) 64 b) 256 c) 512 d) 32
11. Which is the smallest network? 1
a) WAN (b) LAN
c) MAN (d) PAN
12. Write the possible outputs(s) when this code is executed? 1
import random
n=random.randint(0,3)
color=[“Y”,”W”,”B”,”R”]
for i in range (1,n):
print(color[i], end=”*”)
print( )
a) R * b) W*
W* B*
B*
c) W* W* d) Y*
B* B* W* W*
B* B* B*
13. Which Python approach is used for object serialization in handling of Binary File? 1
(a) Pickling (b) Un-pickling
(c) Merging (d) None of these
_______Keyword is used to obtain Non-duplicated values in a SELECT query.
(a) ALL (b) DISTINCT (c) SET (d) HAVING
_______ is the way of connecting the networking devices.
16. Which of the following is not valid cursor function while performing database 1
operations using python. Here Mycur is the cursor object?
(a) Mycur.fetch() (b) Mycur.fetchone()
(c) Mycur.fetchmany(n) (d) Mycur.fetchall()
17. Assertion (A): A variable declared as global inside a function is visible with 1
changes made to it outside the function.
2|Page
Reasoning (R): All variables declared outside are not visible inside a function
till they are redeclared with global keyword.
18. Assertion (A): A binary file in python is used to store collection objects like lists and 1
dictionaries that can be later retrieved in their original form using pickle module.
Reasoning (R): A binary files are just like normal text files and can be read
using a text editor like notepad.
खंड / SECTION-B
19. (i) Write the full forms of the following: (a) IP (b) URL 1+1=
(ii) What is the use of VoIP? 2
OR
(i) Mention one advantage of Star Topology.
(ii) Mention one difference between a Hub and switch in networking.
20. Observe the following Python code very carefully and rewrite it after removing all 2
syntactical errors with each correction underlined.
Define reverse(num):
rev = 0
While num > 0:
rem == num %10
rev = rev*10 + rem
num = num//10
return rev
print(reverse(1234))
21. Write a function INDEX_LIST(L), where L is the list of elements passed as argument to 2
the function. The function returns another list named ‘indexList’ that stores the
indices of all Non-Zero Elements of L.
For example:
If L contains: [2, 0, 5, 0, 1, 0, 0]
The indexList will have: [0,2,4]

OR
Write definition of a function Count_How_Many(Data, item) to count and display number
of times the value of item is present in the list Data. (Note: don’t use the count() function)
For example :
If the Data contains [101,102,107,105,102,103,104,102] and item contains 102
The function should display 102 found 3 Times.
def foo(s1,s2):
l1=[ ]
l2=[ ]
for x in s1:
l1.append(x)
for x in s2:
l2.append(x)
return l1,l2
a,b=foo( "HAPPY",'BIRTHDAY')
print(a,b)
23. Write the Python statement for each of the following tasks: 1+1=2
(i) str="PYTHON@LANGUAGE"
To print the above string from index 2 onwards using a single statement.
(ii) To initialize an empty dictionary named as d using BUILT_IN
fuctions/ methods only.
OR
Write the Python statement for each of the following tasks using BUILT_IN fuctions/
methods only:
3|Page
(i) s=”LANGUAGE"
To convert the above string into list.
(ii) To initialize an empty tuple named as t.
24. A MySQL table, sales have 10 rows with many columns, one column name is 2
DISCOUNT. Following queries were executed on sales table.
SELECT COUNT(*) FROM sales;
COUNT(*)
10
SELECT COUNT(DISCOUNT) FROM sales;
COUNT( DISCOUNT )
6
Write a statement to explain as to why there is a difference in result of both queries.
OR
Write commands to open database ‘KVS’ and show all tables in this database. And
display design/schema/structure of the table EMPLOYEE which is inside this
database. And display all the records of table EMPLOYEE.
data = [20,19,19,17,20,19,17,20]
d = {}
for x in data:
if x in d:
d[x]=d[x]+1
else:
d[x]=1
print(d)
खंड / SECTION-C
26. Write the output of the code given below: 3
def change(Line):
alpha=str()
digi=str()
for ch in Line:
if(ch.isalpha()):
if(ch.islower()):
alpha=alpha+ch.upper()
elif(ch.isupper()):
alpha=alpha+ch.lower()
elif(ch.isdigit()):
alpha=alpha+ch+ch
print(Line)
print(alpha)
change("Vande 0 Bharat 9 Train 1")
27. Write the output of queries (i) to (iii) based on the table Sportsclub given below: 1*3=
Table: Sportsclub 3
playerid pname sports country rating salary
10001 PELE SOCCER BRAZIL A 50000
10002 FEDERER TENNIS SWEDEN A 20000
10003 VIRAT CRICKET INDIA A 15000
10004 SANIA TENNIS INDIA B 5000
10005 NEERAJ ATHLETICS INDIA A 12000
10006 BOLT ATHLETICS JAMAICA A 8000
10007 PAUL SNOOKER USA B 10000
(i) SELECT DISTINCT sports FROM Sportsclub;
(ii) SELECT sports, MAX(salary) FROM Sportsclub GROUP BY sports
4|Page
HAVING sports<>'SNOOKER';
(iii) SELECT pname, sports, salary FROM Sportsclub WHERE
country='INDIA' ORDER BY salary DESC;
28. A pre-existing text file data.txt has some words written in it. Write a python function 3
displaywords( ) that will print all the words that are having length greater than 3.
If the contents of file is :
A man always wants to strive higher in his life
He wants to be perfect.
The output should be: always wants strive higher life wants perfect.
OR
Write a method count_lines( ) in Python to read lines from text file ‘student.txt’ and
display the total number of line in file and lines which are ending with ‘y’ alphabet and
not ending with ‘y’ separately.
Example: If the file content is as follows:

An apple in a day keeps the doctor away.
We should aware for everyone’s safety and security.
India is one of the biggest country in word.
The count_lines( ) function should display the output as:
The number of lines in file are: 3
The number of lines ending with alphabet ‘y’ are: 2
The number of lines not ending with alphabet ‘y’ are: 1
29. Monika is a senior clerk in a MNC. She created a table ‘Salary’ with a set of records to 1*3=
keep ready for tax calculation. After creation of the table, she has entered data of 5 3
employees in the table.
Based on the table given above write the SQL Queries:

(i) Display the Emp_Name and Gross salary of each employee. (Gross=
basic+da+hra+nps)
(ii) Increase the DA by 3% of respective basic salary of all employees.
(iii) Delete the Attribute emp_desig from the table.
30. A list of numbers is used to populate the contents of a stack using a function push(stack, 3
data) where stack is an empty list and data is the list of numbers.The function should
push all the numbers that are even to the stack.
Also write the function pop(stack) that removes and returns the top element of the
stack on its each call.
Also write the function calls.
5|Page
खंड / SECTION-D
31. Write the SQL queries (i) to (iv) based on the relations SCHOOL and ADMIN given below: 1*4=4
Write SQL queries for the following:

i) Display total periods subjectwise.
ii) Display minimum experience and maximum code from relation SCHOOL.
iii)Display teachername, gender by joining both tables on the basis of CODE attribute for
the designation “COORDINATOR.
iv) Display the total number of different subjects in school relation.
32. Write a Program in Python that defines and calls the following user defined functions: 4
Add_New():
To accept record of Player and add to ‘playerdata.csv’ file. The record of player
consists P_id, P_name and P_runs in form of python list.
Display_Record():
To read the records of Player from ‘playerdata.csv’ file and display the record of
player whose runs are more than 5000.
खंड / SECTION-E
33 Hitech Info Limited wants to set up their computer network in Bangalore based 1*5=5
. campus having four buildings. Each block has a number of computers that are required
to be connected for ease of communication, resource sharing and data security.
You as a network expert have to suggest answers to these parts (a) to (e) raised by them.
DEVELOPMENT HUMANRESOURCE
PMENT
KVS
LOGISTICS ADM
RO
Shortest distances between various blocks

Block DEVELOPMENT to Block HUMANRESOURCE -- 50 m
Block DEVELOPMENT to Block ADM-- 75 m
6|Page
Block DEVELOPMENT to Block LOGISTICS-- 80 m
Block HUMANRESOURCE to Block ADM-- 110 m
Block ADM to Block LOGISTICS 140 m
Number of computers installed at various blocks

Block Number of Computers
DEVELOPMENT -- 105
HUMANRESOURCE-- 130
ADM-- 190
LOGISTICS-- 55
a) Suggest the most suitable block to host the server. Justify your answer.
b) Suggest the wired medium and Draw the cable layout (Block to Block) to
economically connect various blocks.
c)Suggest the placement of the following devices with justification:
(i) Hub/Switch (ii)Repeater
d)Suggest the device that should be placed in the Server building so that they can
connect to Internet Service Provider to avail Internet Services.
e) Suggest the high-speed wired communication medium between Bangalore Campus
and Mysore campus to establish a data network.
34 (i) What is CSV means? Which packages/modules are imported for using Binary Files 2+3= 5
. and CSV files in Python?
(ii) Abhay have a binary file called library.dat containing book information- B_id, B_name
and B_price of each book.
[[B_id, B_name, B_price],[B_id, B_name, B_price],…]
Write the user defined function Trace_Book() to show the records of books having the
price less than 1000. In case there is no book having price <1000 the function displays
message “Such Record not found”.
OR
(i) Write any two difference between text file and binary file.
(ii)Mayur is a student, who have a binary file called STUDENT.DAT containing employee
information- sid, name and age of each student.
[sid, name , age]
Write the user defined function Get_Stud() to display the name and age of those student
who have a age greater than 18 year. In case there is no student having age >18 the
function displays message “There is no student who is greater than 18 year”.
35 (i) What is the difference between a Candidate Key and an Alternate Key. 1+4=5
.
(ii) Virat has created a table named TRAVELS in MySQL:
Tour_ID – string
Destination – String
Geo_Cond– String
Distance – integer (In KM)

 Password is bharat
 The table TRAVELS exists in a MYSQL database named TOUR.
 The details Tour_ID, Destination, Geo_Cond and Distance are to be accepted from the
user.
Virat wants to display All Records of TRAVELS relation whose Geographical condition
7|Page
is hilly area and distance less than 1000 KM. Help Virat to write program in python.
OR
(i) Write one point of difference between PRIMARY KEY and UNIQUE KEY in SQL.
(ii) Aarya has created a table named Emp in MySQL:

EmpNo – integer
EmpName – string
Age– integer
Salary – integer
 Username - root
 Password - tiger
 Host - localhost
 The Emp table exists in a MYSQL database named company.
 The details of Emp table (EmpNo, EmpName, Age and Salary)
Aarya wants to display All Records of Emp relation whose age is greater than 55. Help
Aarya to write program in python.
----------------*------------*------------------
8|Page
KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION
PreBoard-I Examination 2023-24
Class-XII
Subject: Computer Science (083)
Answer Key
SECTION-A
QN. Answer of Question
1. Ans. False 1
2. Ans. (d) Drop 1
3. Ans: (d) dict_student.update(dict_marks) 1
4. Ans. (b) True 1
5. Ans. (b) DELETE Command 1
6. Ans: (c) HomePage 1
7. Ans. (c) None 1
8. Ans. (a) Year . 0. at All the best 1
9. Ans. (b) Statement 4 1
10. Ans. (c) 512 1
11. Ans: (d) PAN 1
12. Ans. (b) W* 1
B*
13. Ans. (a) Pickling 1
14. Ans. (b) DISTNICT 1
15. Ans. Topology 1
16. Ans. (a) Mycur.fetch() 1
17. Ans. (c) A is True but R is False 1
18. Ans. (c) A is True but R is False 1
SECTION-B
19. (i) (a) IP-Internet Protocol 2
(b) URL- Uniform Resource Locator (1/2 mark for each)
(ii)VoIP is used to transfer audio (voice) and video over internet(1 mark)
OR
(i) Advantage: The network remains operational even if one of the nodes
stopsworking. (1 mark for any ONE advantage)
(ii)
Hub Switch
Hub is a passive Device Switch is an active device
Hub broadcasts messages to all Switch sends the messages to
nodes intended node.
Or any other valid difference between the two.
(1 mark for ANY ONE difference)
20. def reverse(num): 1+1
rev = 0 =2
while num > 0:
rem == num %10
rev = rev*10 + rem
num = num//10
return rev
print(reverse(1234))
(½ Mark for each correction up to any 4 corrections)
1|Page
21. 1+1=
2
OR
def Count_How_Many(Data, item):
count=0
for n in Data:
if(n==item):
count+=1
print(item, " found ", count, "times")
d=[101,102,107,105,102,103,104,102]
i=102
Count_How_Many(d,i)
or any other correct logic
22. ['H', 'A', 'P', 'P', 'Y'] ['B', 'I', 'R', 'T', 'H', 'D', 'A', 'Y'] 2
23. (i) str="PYTHON@LANGUAGE" 2
print(str[2: : ])
(ii) d=dict( )
OR
(i) s=”LANGUAGE"
l=list(s)
(ii) t=tuple( )
24. COUNT(*) returns the count of all rows in the table, whereas COUNT 2
(COLUMN_NAME) is used with Column_Name passed as argument and
counts the number of non-NULL values in a column that is given as
argument. Here discount column is having 4 rows with NULLvalues.
OR
Use KVS; (1/2 mark)
Show Tables; (1/2 mark)
Desc EMPLOYEE;
(1/2 MARK)
Select * from EMPLOYEE; (1/2 MARK)
25. {20: 3, 19: 3, 17: 2} 2

SECTION-C
26. Vande 0 Bharat 9 Train 1 3
vANDE00bHARAT99tRAIN11
(3 marks for correct answer. Partial marks may be given for partially
correct answer.)
27. (1 mark for each correct output) 1*3
=3
2|Page
(i)
sports
SOCCER
TENNIS
CRICKET
ATHLETICS
SNOOKER
ii)
Sports MAX(salary)
SOCCER 50000
TENNIS 20000
CRICKET 15000
ATHLETICS 12000
iii)
pname sports salary
VIRAT CRICKET 15000
NEERAJ ATHLETICS 12000
SANIA TENNIS 5000
28. def displaywords (): 3
file = open('data.txt','r')
st=file.read()
lst=st.split()
for k in lst:
if len[k] >3:
print(k, end=” “)
file.close()
displaywords ()# Call the displaywords
(½ mark for function header, 1 mark for opening file,
1 mark for correct for loop and condition,½ mark for closing file)
OR
def count_lines():
f=open("student.txt",'r')
rows=f.readlines()
end_y=not_y=0
for rec in rows:

if(rec[-1]=='y'):
end_y+=1
else:
not_y+=1
print("The number of lines in file are", len(rows))
print("The number of lines ending with alphabet ‘y’ are:",end_y)
print("The number of lines not ending with alphabet ‘y’ are:",not_y)
count_lines()
#call the function
(½ mark for function header, 1 mark for opening file,
1 mark for correct for loop and condition,½ mark for closing file)
29. (i) SELECT EMP_NAME, BASIC+DA+HRA+NPS AS “GROSS SALARY” FROM 1*3
SALARY; =3
(ii)UPDATE SALARY SET DA=DA+0.03*BASIC;
(iii)ALTER TABLE SALARY DROP COLUMN EMP_DESIG;
3|Page
30. data = [1,2,3,4,5,6,7,8] 3
stack = []
def push(stack, data):
for x in data:
if x % 2 == 0:
stack.append(x)
def pop(stack):
if len(stack)==0:
return "stack empty"
else:
return stack.pop()
push(stack, data)
print(pop(stack))
(½ mark should be deducted for all incorrect syntax. Full marks to beawarded
for any other logic that produces the correct result.)
SECTION-D
31. i)SELECT SUM (PERIODS), SUBJECT FROM SCHOOL GROUP BY SUBJECT ; 1*4
ii) SELECT MIN(EXPERIENCE), MAX(CODE) FROM SCHOOL; =4
iii)SELECT TEACHERNAME, GENDER FROM SCHOOL, ADMIN WHERE
DESIGNATION = ‘COORDINATOR’ AND SCHOOL.CODE=ADMIN.CODE;
iv)SELECT COUNT(DISTINCT SUBJECT) FROM SCHOOL;
(1 mark for each correct query)
32. import csv 2+2=
def Add_New(): 4
fout=open("playerdata.csv ","a",newline='\n')
wr=csv.writer(fout)
P_id=int(input("Enter Player Id :: "))
P_name=input("Enter Player name :: ")
P_runs=int(input("Enter price :: "))
playerlist=[P-id,P_name,P_runs]
wr.writerow(playerlist)
fout.close()
def Display_Record():
fin=open("playerdata.csv ","r")
data=csv.reader(fin)
found=False
print("The Player Records are: ")
for Rec in data:
if int(rec[2])>5000:
found=True
if found==False:
print("Such Record not found")
Add_New():
Display_Record():
(½ mark for importing csv module)
(1 ½marks each for correct definition of Add_New() and
Display_Record ())
(½ mark for function call statements )
4|Page
SECTION-E
33. i) ADM Block 1*5=
Justification- It has maximum number of computers. Reduce traffic. 5
ii) wired medium is ethernet cables. Following bus (cable cost efficient) or star
with ADM as centre (network traffic efficient)
DEVELOPMENT HUMANRESOURCE
LOGISTICS ADM
iii) (a) Switches in all the blocks since the computers need to be connected to
the network.
(b) Repeaters between ADM and HUMANRESOURCE block& ADM and Logistics
block. The reason being the distance is morethan 100m.
iv) Modem should be placed in the Server building
v) Optical Fiber cable connection
34. (i) Full form of CSV is Coma Separated Value. 2+3=
pickle module is used for Binary files and csv module is used for 5
importing csv files. (1+ ½ +½)
ii)import pickle
def Trace_Book():
fopen=open("library.dat ","r")
data=pickle.load(fopen)
found=False
print("The Book Records are: ")
for Rec in data:
if (rec[2])<1000:
found=True
if found==False:
print("Such Record not found")
Trace_Book():
OR
(i) (1 mark for each difference between text file and binary file)
(ii)import pickle
def Get_Stud():
Total = 0
Count_rec = 0
Count_age = 0
with open(“ STUDENT.DAT”, “ rb”) as F:
while True:
try:
R=pickle.load(f)
Count_rec = Count_rec+1
Total = Total+R[2]
if R[2] > 18:
print (R[1],“is of Age :”,R[2])
Count_age + = 1
except:
break
if Count_age = =0 :
print(“There is no student who is greater than 18 year”)
5|Page
Get_Stud()
35. (i)Any one difference: 1+4=
CANDIDATE KEY ALTERNATE KEY 5
All attributes in a relation thathave potential to All the leftover candidate keys
become a Primary key after selecting the primary key
(ii)
import mysql.connector as BD
def Emp_Database():
con=BD.connect(host="localhost", user="root", password="bharat",
database="TOUR")
BDcursor=con.cursor()
print("Travels at Hilly Area and the distance more than 1000 KM.:")
BDcursor.execute("select * from TRAVELS WHERE Geo_Cond =’hilly area"
AND Distance<1000)
TravelRec= BDcursor.fetchall()
for rec in TravelRec:
print(rec)
OR
(i)Any one difference:
PRIMARY KEY UNIQUE KEY
There can be only one primary There can be more than one unique
key in a table keys in a table
The primary key cannot have null Unique can have null values
values
(ii)
import mysql.connector as cnt
def Emp_Database():
con=cnt.connect(host="localhost", user="root", password="tiger",
database="company")
mycursor= con.cursor()
print("Display Employee whose age is more than 55 years:")
mycursor.execute("select * from Emp where age>55”)
EmpRec= mycursor.fetchall()
for rec in EmpRec:
print(rec)
6|Page

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#

…………….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.
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()
correct choice as
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"}
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
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
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

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

correct
15,50 answer
6 Option a 1 mark for 1

correct
PAN answer

correct
r g b answer

2@tr correct
answer
[1]
correct
Statement 4 answer

correct
Wait#Stop# answer

correct
SMTP answer

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

correct
It is case sensitive answer
15 Packet 1 mark for 1

correct
answer
16 Option c 1 mark for 1

correct
seek() answer

Both A and R are true but R is the correct explanation for A correct
answer
[2]
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])
[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)
[10]
(SET 1)
PRE BOARD EXAMINATION 2023-24
Maximum Marks: 70 Time Allowed: 3 hours

3. Section A have 18 questions carrying 01 mark each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in
Q35 against part c only.
SECTION A
“Dictionaries in python are mutable.”
2. Which of the following is an invalid identifier 1
a)myname b)p9tv c)def d)_new
3. Which one of the following is the function to get list of keys from a dictionary 1
dict in python?
a. dict.getkeys()
b. dict.getvalues()
c. dict.keys()
d. None Of These

True OR NOT False AND True
Which of the following will be correct output if the given expression is
evaluated?
(a) True
(b) False
(c) NONE
(d) NULL

Str=”I will Succeed”
1
lis=str.split(“ “)
print(lis[-1])
(a) I
(b) will
(c) Succeed
(d) ”I will Succeed”
6. Which of the following methods will give the current position of the file 1
pointer?
(a)seek() (b)tell() (c)getloc() (d) None of the above
Command is used to change the structure of the table in SQL.
(a)update (b)remove (c)alter (d)drop
8. Which of the following commands will delete the row of the table from 1
MYSQL database?
(a) DELETE
(b) DROPTABLE
(c) REMOVETABLE
(d) ALTERTABLE
9. Which of the following statement(s) would give an error after 1

T=(8,9,7,6) # Statement 1
print(T) # Statement2
T=(7,9,7,6) # Statement3
T[1]=8 # Statement4
T=T+(1,2,3) # Statement5
(a) Statement3
(b) Statement4
(c) Statement5
(d) Statement 4 and5
is an attribute or set of attributes eligible to become primary

key.
(a) PrimaryKey
(b) ForeignKey
(c) CandidateKey
2
(d) Alternate Key
11. The default mode of opening a file in pyhton 1

(a) append
(b) read
(c) write
(d) both b and c
12. Which of the following can be used as command to get the structure of a table in 1
mysql
(a) DESCRIBE
(b) UNIQUE
(c) DISTINCT
(d) NULL
Is the protocol used for server to server mail transfer?
(a)VoIP (b)SMTP (c)PPP (d)HTTP

print(2**3**2//8)
(a)64.0 (b)64 (c)8 (d)None Of These
15. Which clause is used to apply conditions with GROUP BY 1

(a) WHERE
(b) HAVING
(c) LIKE
(d) None Of These
16. Which function is used to establish connection between python and SQL 1
database?
(a) connection
(b) connect
(c) getconnection
(d) getconnect
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct
choice as
3
17. Assertion (A):-Functions in a program increases the modularity and readability 1
of the program
Reasoning (R):-Usage of Functions increases the execution speed of the
program
18. Assertion (A): If a file is opened in binary mode its contents are viewed as a 1
sequence of bytes.
Reason (R): A text file also can be opened in binary mode
SECTION B
19. Rahul has written a code to input a number and return its reverse. His code is 2
having errors. Rewrite the correct code and underline the corrections made.
def reverse()
n=int(input("Enter number :: ")
rev=0
while(num>0):
r=num%10
rev=rev*10+r
num=num//10
return rev
20. What do you mean by protocol? Give two examples 2
OR
What is a MODEM? Explain its use?
21. (a) Given is a Python string declaration: 1

Mystr=”I will win”
Write the output of: print(Mystr[2:6])
(b) Write the output of the code given below:

dictcount={“age1”:26,”age2”:32,”age3”:40} 1
sum=0
for key in dictcount:
sum=sum+dictcount[key]
print(sum)
22. Explain the use of ‘Primary Key’ in a Relational Database Management 2

23. (a) Write the full forms of the following: 2

(i) FTP (ii)TCP
4
(b) What is the use of POP3?

def product(L1,L2):
p=0
for i in L1:
for j in L2:
p=p+i*j
return p
LIST=[1,2,3,4,5,6]
l1=[]
l2=[]
for i in LIST:
if(i%2==0):
l1.append(i)
else:
l2.append(i)
print(product(l1,l2))
OR

tuple1 = (33, 24, 44, 42, 54 ,65)
list1 =list(tuple1)
new_list = []
for i in list1:
if i>40:
new_list.append(i)
print(new_tuple)
25. Explain the use of DISTINCT keyword in python with appropriate example 2
OR
What is called DDL commands in mysql?Give examples?
SECTION C
26. a)Consider the following tables -Product and Supplier: 1+2

Table:Product
Pid pname sid
P1 pen S1
P2 ball S2
P3 pencil S3
Table:Supplier
Sid sname
S1 Anmol
S2 Aradhya
S3 Sunil
S4 Vishal
5
SELECT * FROM product NATURAL JOIN SUPPLIER;
b)Write the outputof the queries (i) to (iv) based on the table EMPLOYEE given
below
Empid Empname Salary Deptid
E1 Prabhath 12000 D1
E2 Nikhil 14000 D1
E3 Devansh 10000 D2
E4 Debraj 15000 D3
E5 Aron 18000 D1
(i)SELECT DISTINCT deptid from Employee;

(ii)SELECT deptid,count(*),min(salary) from employee GROUP BY deptid
HAVING count(deptid)>2;
(iii)SELECT empname FROM employee WHERE salary>14000 ORDER BY
empname;
(iv)SELECT SUM(SALARY) FROM Employee WHERE SALARY
BETWEEN 15000 AND 18000;
27. Write a method COUNTLINES() in python to read lines from text file 3
MYSTORY.TXT and display the count of lines which are starting with letter T
Example:if the file content is as follows:
Trees are the precious
We should protect trees
This way we can serve nature
The COUNTLINES() function should display output as:

The number of lines starting with letter T :2
OR
Write a function COUNTOWEL() IN PYTHON which should read each

character of a text file CHARACTER.TXT and display the count of vowels
Example:
If the file content is as follows:

Exam is going on well
The COUNTOWEL() function should display the output as:

7
28. (a) Write the outputs of the SQL queries (i) to (iv) based on the 3
relations Teacher and Placement given below:
6
BOOK
Book_id Book_name Price Qty Author_id

1001 My first C++ 323 12 204
1002 SQL basics 462 6 202
1003 Thunderbolts 248 10 203
1004 The tears 518 3 204
AUTHOR
Author_id Author_name Country

201 William Hopkins Australia
202 Anita India
203 Anna Roberts USA
204 Brain Brooke Italy
(i) SELECT Author_id, avg(price) from BOOK GROUP BY

Author_id;
ii) SELECT MAX(price),MIN(price) from BOOK;
ii) SELECT Book_name,Author_name,country from BOOK B,
AUTHOR A WHERE B.Author_id = A.Author_id AND price>300;
iv) SELECT Author_name from AUTHOR WHERE Author_name LIKE
“A%”;
29. Write a function EVEN_LIST(L), where L is the list of elements passed 3
as argument to the function. The function returns another list named ‘even list’
that stores even numbers in the list.
For example:
If L contains [1,2,3,4,5,6,7,8]
The even list will have - [2,4,6,8]
30. A list contains following record of a student: 3

[student_name, age, hostel]
Write the following user defined functions to perform given operations on the
stack named ‘stud_details’:
(i) Push_element() - To Push an object containing name and age of
students who live in hostel “Ganga” to the stack
(ii) Pop_element() - To Pop the objects from the stack and display
them. Also, display “Stack Empty” when there are no elements in the
stack.
For example:
If the lists of customer details are:
[“Barsat”,17,”Ganga”]
[“Ruben”, 16,”Kaveri”]
[“Rupesh”,19,”Yamuna”]
7
Stack Empty
OR
A list named as Record contains following format of for students:

[student_name, class, city].
stack named ‘Record’:
(i) Push_record(Record) – To pass the list Record = [ ['Rahul', 12,'Delhi'],
[‘Kohli',11,'Mumbai'], ['Rohit',12,'Delhi'] ] and then Push an object containing
Student name, Class and City of student belongs to ‘Delhi’ to the stack Record
and display and return the contents of stack
(ii) Pop_record(Record) – To pass following Record [[“Rohit”,”12”,”Delhi”]
[“Rahul”, 12,”Delhi”] ] and then to Pop all the objects from the stack and at last
display “Stack Empty” when there is no student record in the stack. Thus the
output should be: -
[“Rohit”,”12”,”Delhi”]
[“Rahul”, 12,”Delhi”]
Stack Empty
SECTION D
31
Hi-tech Training center, a Mumbai based organization is planning to
expand their training institute to Chennai. At Chennai compound,
they are planning to have three different blocks for admin, training
and accounts related activities. As a network consultant you have to
suggest some network related solutions to the organization
Shortest distance between the blocks Number of computers installed

are given below: in each block are as follows:
Admin  Accounts 300 meters Training 150
Block
Accounts 150 meters Accounts 30
training block
8
I Admin  Training 200 meters Admin Block 20
Mumbai  1300 KM
Chennai office
i) Suggest the most suitable block to house the server at Chennai block for 1
best and effective connectivity.
Suggest the type of network for the new training institute and draw
ii) 1
the cable layout for the Chennai office
Suggest a hardware/software that would provide the data security for entire network of Chennai
1
iii) region.
Suggest a device that shall be needed to provide wireless internet access to all smart
1
iv) phones/laptop users in Chennai office.
Suggest the protocol used for video conferencing between Chennai
1
v) office and Mumbai office
val=4
def findval(m,n=10):
val=0
val=val+m*n
a=10
b=20
findval(a,b)
print(val,end="-")
findval(a)
print(val,end="-")
(b) The code given below inserts the following record in the table
Employee:
Empid – integer Name – string salary-float

Note the following to establish connectivity
between Python and MYSQL:
Username is root
Password is tiger
The table exists in a MYSQL database named Empolyee.
The details (Empid, Name, salary) are to be accepted from
the user.
Write the following missing statements to
complete the code:
Statement 2 – to execute the command that
inserts the record in the table Employee.
Statement 3- to add the record permanently in
the database
9
from mysql.connector import Error
connection = mysql.connector.connect(host='localhost',
database='Employee',
user='root',
password='tiger')
cursor=_______________________#STATEMENT1
empid=int(input("enter Empid"))
name=input("enter name")
salary=float(input("ENTER SALARY"))
result = __________________________#STATEMENT2
___________________________________#STATEMENT3
OR
(a) Predict the output of the code givenbelow:

s="PREboardCS*2022!"
j=2
for i in s.split('*'):
k=i[:j]
if k.isupper():
j=j+1
elif k.isdigit():
j=j+2
else:
j=j+3
print(s [ j : : j ] )
(b) The code given below reads the following record from the table
named Employee and displays only those records who have Salary
greater than 25000:

MYSQL:
 Password is tiger
 The table exists in a MYSQL database named Employee.
Write the following missing statements to complete the code: Statement 1 – to

form the cursor object
Statement 2 – to execute the query that extracts records of those
Employees who have salary greater than 25000.
Statement 3- to read the complete result of the query (records whose
salary greater than 25000) into the object named records, from the table
Employee in the database.
10
user='root',
password='tiger')
cursor=________________________#STATEMENT1
_________________________________________#STATEMENT2
records = _____________________________#STATEMENT3
for row in records:
print("Empid",row[0],end=" ")
print("name",row[1],end=" ")
print("salary",row[2],end=" ")
print()
33. What is a csv file? 5

Write a Program in Python that defines and calls the following user defined
functions:
(i) INSERT() – To accept and add data of a student to a CSV file

‘student.csv’. Each record consists of a list with field elements as sid,
name and marksto store student id, name and marks respectively.
(i) COUNTSTUDENTS() – To count the number of records present in
theCSV file named‘student.csv’.
OR
What is the purpose of delimiter?

functions:
(i) add() – To accept and add data of a product to a CSV file

‘product.csv’. Each record consists of a list with elements as
pid, pnameand priceto storeproduct id, product name and
pricerespectively.
(i) search()- To display the records of the products whose price is
more than5000.
SECTION E
34. Rahul created following table TRAVEL to store the travel details 1+1+2
11
(i) Identify the most appropriate column, which can be considered as

Primary key.
(ii) If 3 columns are added and 1rows are deleted from the table TRAVEL,
what will be the new degree and cardinality of the above table?
a. Insert the following record into the table
110 BIMAL 28-11-2022 200 VOLVO BUS 40
b. Increase KM travelled by 10 if the VTYPE is VOLVO.


a. Delete the record of travel of traveler NANDA.
b. Add a column MILEAGE in the table with data type as integer
35. Biplab is a Python programmer. He has written a code and created a binary file
STUDENT.DAT which has structure (admission_number, Name, Percentage).
He has written an incomplete function countrec() in Python that would read
contents of the file “STUDENT.DAT” and display the details of those students
whose percentage is above 75. Also display number of students scoring above
75%.As a Python expert, help him to complete the following code based on the
requirement given above:
import __________#statement1
def countrec():
_____________________#Statement2
records=_______________#Statement3
count=0
for record in records:
if(_______________):#Statement4
count=count+1
12
print("ID",record[0])
print("NAME",record[1])
print("PERCENTAGE",record[2])
print("No of students with perentage above 75",count)
(i) Which module should be imported in the program? (Statement1) 1

(ii) Write the correct statement required to open a file named
STUDENT.DAT in binary mode (Statement2) 1
(iii) Which statement should Biplab fill in Statement 3 to read the
data from the binary file, STUDENT.DATand in Statement 4 to check the
percentage?
OR 2
Explain various functions used in writing rows in csv file.
13
(SET 1)

PRE BOARD EXAMINATION
MARKING SCHEME
Maximum Marks:70 Time Allowed: 3 hours
7. Section E has 02 questions carrying 04 marks each. One internal choice is given
in Q34 against part only.
SECTION
A
“Dictionaries in python are mutable.”
Ans:True
2. Which of the following is an invalid identifier 1
a)myname b)p9tv c)def d)_new
Ans:c def
3. Which one of the following is the function to get list of keys from a dictionary 1
dict in python?
a. dict.getkeys()
b. dict.getvalues()
c. dict.keys()
d. None Of These
Ans: c dict.keys()
True OR NOT False AND True
Which of the following will be correct output if the given expression is
evaluated?
(a) True
(b) False
(c) NONE
(d) NULL
Ans:A True
Str=”I will Succeed”
1
lis=str.split(““)
print(lis[-1])
(a) I
(b) will
(c) Succeed
(d) ”I will Succeed”
ANS:c Succeed
6. Which of the following methods will give the current position of the file 1
pointer?
(a)seek() (b)tell() (c)getloc() (d) None of the above
ANS:b tell()
command is used to change the structure of the table in SQL.
(a)update (b)remove (c)alter (d)drop
ANS: c alter
8. Which of the following commands will delete the contents of the table from 1
MYSQL database?
(a) DELETE
(b) DROPTABLE
(c) REMOVETABLE
(d) ALTERTABLE
ANS:a DELETE
9. Which of the following statement(s) would give an error after 1
T=(8,9,7,6) # Statement 1
print(T) # Statement2
T=(7,9,7,6) # Statement3
T[1]=8 # Statement4
T=T+(1,2,3) # Statement5
(a) Statement3
(b) Statement4
(c) Statement5
(d) Statement 4 and5
ANS:b statement 4
2
is an attribute or set of attributes eligible to become primary

key.
(a) PrimaryKey
(b) ForeignKey
(c) CandidateKey
(d) Alternate Key
ANS:c candidate key
11. The default mode of opening a file in pyhton 1
(a) append
(b) read
(c) write
(d) both b and c
ANS:b read
12. Which of the following can be used as command to get the structure of a table in 1
mySQL
(a) DESCRIBE
(b) UNIQUE
(c) DISTINCT
(d) NULL
ANS:a DESCRIBE
Is the protocol used for server to server mail transfer?
(a)VoIP (b)SMTP (c)PPP (d)HTTP
ANS:b SMTP

print(2**3**2//8)
(a)64.0 (b)64 (c)8 (d)None Of These
ANS: b 64
15. Which clause is used to apply conditions with GROUP BY 1

(a) WHERE
(b) HAVING
(c) LIKE
(d) None Of These
ANS:b HAVING
3
16. Which function is used to establish connection between python and SQL 1
database?
(a) connection
(b) connect
(c) getconnection
(d) getconnect
ANS:b connect
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct
choice as
17. Assertion (A):-Functions in a program increases the modularity and readability 1
of the program
Reasoning (R):-Usage of Functions increases the execution speed of the
program
ANS: c A is True but R is False
18. Assertion (A): If a file is opened in binary mode its contents are viewed as a 1
sequence of bytes.
Reason (R): A text file also can be opened in binary mode
ANS: b Both A and R are true and R is not the correct explanation for A
SECTION
B
19. Rahul has written a code to input a number and return its reverse. His code is 2
having errors. Rewrite the correct code and underline the corrections made.
def reverse()
rev=0
while(num>0):
r=num%10
rev=rev*10+r
num=num//10
return rev
ANS:
def reverse():
rev=0
while(num>0):
r=num%10
rev=rev*10+r
num=num//10
return rev
½ marks for each correction

4
20. What do you mean by protocol? Give two examples 2
ANS:1 mark for the definition and 1 mark for the example
OR
What is a MODEM? Explain its use?
ANS:MODULATOR DEMODULATOR
2marks for correct explanation.
21. (a) Given is a Python stringdeclaration: 1

Mystr=”I will win”
Write the output of: print(Mystr[2:6])

ANS:will 1
(b) Write the output of the code givenbelow:

dictcount={“age1”:26,”age2”:32,”age3”:40}
sum=0
for key in dictcount:
sum=sum+dictcount[key]
print(sum)
ANS:98
22. Explain the use of ‘Primary Key’ in a Relational Database Management 2

1 mark for example and 1 mark for explanation
23. (a) Write the full forms of thefollowing: 2

(i) FTP (ii)TCP
(b) What is the use of POP3?
ANS:FTP-FILE TRANSFER PROTOCOL ½ MARKS

TCP-TRANSMISSION CONTROL PROTOCOL ½ MARKS
1 MARK FOR THE EXPLANATION OF POP3
def product(L1,L2):
p=0
for i in L1:
for j in L2:
p=p+i*j
return p
LIST=[1,2,3,4,5,6]
l1=[]
l2=[]
for i in LIST:
if(i%2==0):
l1.append(i)
else:
l2.append(i)
print(product(l1,l2))
5
ANS:108
OR

tuple1 = (33, 24, 44, 42, 54 ,65)
list1 =list(tuple1)
new_list = []
for i in list1:
if i>40:
new_list.append(i)
print(new_tuple)
ANS: (44, 42, 54, 65)
25. Explain the use of DISTINCT keyword in python with appropriate example 2
ANS:DISTINCT keyword discards duplicate vales
1 mark for explanation and 1 mark for example
OR
What is called DDL commands in mySQL?Give examples?

DDL-DATA DEFENITION LANGUAGE
EXAMPLE:CREATE ,DROP,ALTER
SECTION C
26. a)Consider the following tables -Product and Supplier: 1+2

Table:Product
Pid pname sid
P1 pen S1
P2 ball S2
P3 pencil S3
Table:Supplier
Sid sname
S1 Anmol
S2 Aradhya
S3 Sunil
S4 Vishal

SELECT * FROM product NATURAL JOIN SUPPLIER;
ANS:
Pid pname sid Sname
P1 Pen S1 Anmol
P2 Ball S2 Aradhya
P3 Pencil S3 Sunil
b)Write the outputof the queries (i) to (iv) based on the table EMPLOYEE given
below
Empid Empname Salary Deptid
6
E1 Prabhath 12000 D1
E2 Nikhil 14000 D1
E3 Devansh 10000 D2
E4 Debraj 15000 D3
E5 Aron 18000 D1
(i)SELECT DISTINCT deptid from Employee;

(ii)SELECT deptid,count(*),min(salary) from employee GROUP BY deptid
HAVING count(deptid)>2;
(iii)SELECT empname FROM employee WHERE salary>14000 ORDER BY
empname;
(iv)SELECT SUM(SALARY) FROM Employee WHERE SALARY
BETWEEN 15000 AND 18000;
ANS:(i)
Deptid
D1
D2
D3
1/2 marks
(ii)
Deptid count(*) min(salary)
D1 3 12000
1/2 marks
(iii)
Empname
Aron
Debraj
1/2 marks
(iv)
Sum(Salary)
33000
1/2 marks
27. Write a method COUNTLINES() in python to read lines from text file 3
MYSTORY.TXT and display the count of lines which are starting with letter T
Example:if the file content is as follows:
Trees are the precious
We should protect trees
This way we can serve nature
The COUNTLINES() function should display output as:

The number of lines starting with letter T :2
ANS:
def COUNTLINES():
fp=open("MYSTORY.TXT","r")
7
count=0
lines=fp.readlines()
for line in lines:
if(line[0]=="T"):
count=count+1
print("The number of lines starting with letter T :",count)
OR
Write a function COUNTOWEL() IN PYTHON which should read each

character of a text file CHARACTER.TXT and display the count of vowels
Example:
If the file content is as follows:

Exam is going on well
The COUNTOWEL() function should display the output as:

7
ANS:
def COUNTVOWELS():
fp=open("CHARACTER.TXT","r")
count=0
characters=fp.read()
characters=characters.lower()
for character in characters:
if(chatacter in ['a','e','i','o','u']):
count=count+1
print(count)
28. (a) Write the outputs of the SQL queries (i) to (iv) based on the 3
relations Teacher and Placement given below:
BOOK
Book_id Book_name Price Qty Author_id
1001 My first C++ 323 12 204
1002 SQL basics 462 6 202
1003 Thunderbolts 248 10 203
1004 The tears 518 3 204
AUTHOR
Author_id Author_name Country
201 William Hopkins Australia
202 Anita India
203 Anna Roberts USA
204 Brain&Brooke Italy
(i) SELECT Author_id, avg(price) FROMBOOK GROUP

BYAuthor_id;
8
ii) SELECT MAX(price),MIN(price) FROM BOOK;
ii) SELECTBook_name,Author_name,countryFROM BOOK B,
AUTHOR A WHERE B.Author_id = A.Author_idANDprice>300;
iv) SELECT Author_name FROM AUTHOR WHERE Author_nameLIKE
“A%”;
ANS:
(i)
Author_id Avg(price)
204 420.5
202 462
203 248
(ii)
MAX(price) MIN(price)
518 248
(iii)
Book_name Author_nam Country
e
My First Brain&Broo Italy
C++ ke
SQL Basics Anita India
The Tears Brain&Broo Italy
ke
(iv)
Author_name
Anita
Anna Roberts
29. Write a function EVEN_LIST(L), where L is the list of elements passed 3
as argument to the function. The function returns another list named ‘evenlist’
that stores even numbers in the list.
For example:
If L contains [1,2,3,4,5,6,7,8]
The evenlist will have - [2,4,6,8]

ANS:
def EVEN_LIST(L):
evenlist=[]
for i in L:
if(i%2==0):
evenlist.append(i)
9
return evenlist
30. A list contains following record of a student: 3

[student_name, age, hostel]
stack named ‘stud_details’:
(i) Push_element() - To Push an object containing nameand
age of students who live in hostel “Ganga” to the stack
(ii) Pop_element() - To Pop the objects from the stack and display
them. Also, display “Stack Empty” when there are no elements in
thestack.
For example:
If the lists of customer detailsare:
[“Ruben”, 16,”Kaveri”]
[“Rupesh”,19,”Yamuna”]
Stack Empty
ANS:
stud_details=[]
def push_element(lis):
if(lis[2]=="Ganga"):
stud_details.append([lis[0],lis[1]])
def pop_element():
while(len(stud_details)>0):
print(stud_details.pop())
print("Stack Empty")
OR
def Push_record(): # (1½ mark for correct push element)

for i in List:
if i[2]=="Delhi":
Record.append(i)
print(Record)
def Pop_record(): # (1½ mark for correct push element)
while True:
if len(Record)==0:
print('Empty Stack')
break
10
else:
print(Record.pop())
Push(Dict_Product)
(1 mark for correct function header
1 mark for correct loop
½ mark for correct If statement
½ mark for correct display of count)
SECTION D
31
HiTech Training center, a Mumbai based organization is planning to
expand their training institute to Chennai. At Chennai compound,
they are planning to have three different blocks for admin, training
and accounts related activities. As a network consultant you have to
suggest some network related solutions to the organization
Shortest distance between the blocks Number of computers installed

are given below: in each block are as follows:
Admin  Accounts 300 meters Training 150
Block
Accounts 150 meters Accounts 30
training block
I Admin  Training 200 meters Admin Block 20
Mumbai  1300 KM
Chennai office
i) 1
Suggest the most suitable block to house the server at Chennai block for 1
ii) best and effective connectivity.
Suggest the type of network for the new training institute and draw 1
iii) the cable layout for the Chennai office
Suggest a hardware/software that would provide the data security 1
iv) for entire network of Chennai region.
Suggest a device that shall be needed to provide wireless 1
v) internet access to all smart phones/laptop users in Chennai office.
Suggest the protocol used for video conferencing between Chennai
11
office and Mumbai office
ANS:
i)Training Block
ii)LAN
iii)FIREWALL
iv)ACCESS POINT
v)H.323 or SIP
val=4
def findval(m,n=10):
val=0
val=val+m*n
a=10
b=20
findval(a,b)
print(val,end="-")
findval(a)
print(val,end="-")
ANS:4-4-
(b) The code given below inserts the following record in the table
Employee:
Empid – integer Name – string salary-float

Note the following to establish connectivity
between Python and MYSQL:
Username is root
Password is tiger
The table exists in a MYSQL database named Empolyee.
The details (Empid, Name, salary) are to be accepted from
the user.
Write the following missing statements to
complete the code:
Statement 2 – to execute the command that
inserts the record in the table Employee.
Statement 3- to add the record permanently in
the database
from mysql.connector import Error
user='root',
password='tiger')
cursor=_______________________#STATEMENT1
empid=int(input("enter Empid")) 12
name=input("enter name")
salary=float(input("ENTER SALARY"))
result = __________________________#STATEMENT2
___________________________________#STATEMENT3
ANS:
STATEMENT1:connection.cursor()
STATEMENT2:cursor.execute("insert into employee
values(%s,%s,%s)",(empid,name,salary))
STATEMENT3:connection.commit()
OR
(a) Predict the output of the code givenbelow:

s="PREboardCS*2022!"
j=2
for i in s.split('*'):
k=i[:j]
if k.isupper():
j=j+1
elif k.isdigit():
j=j+2
else:
j=j+3
print(s [ j : : j ] )
ANS:
brS0!
(b) The code given below reads the following record from thetable
named Employeeand displays only those records who have Salary
greater than 25000:

MYSQL:
 Username isroot
 Password istiger
 The table exists in a MYSQL database namedEmployee.
Write the following missing statements to complete the code: Statement 1 – to

form the cursor object
Statement 2 – to execute the query that extracts records of those
Employees who have salary greater than 25000.
Statement 3- to read the complete result of the query (records whose
salary greater than 25000) into the object named records, from the table
Employeein the database.
user='root',
password='tiger')
cursor=________________________#STATEMENT1
_________________________________________#STATEMENT2
13
records = _____________________________#STATEMENT3
for row in records:
print("Empid",row[0],end=" ")
print("name",row[1],end=" ")
print("salary",row[2],end=" ")
print()
ANS:
Statement 1 :connection.cursor()
Statement 2 :cursor.execute("select * from employee where salary>25000")
Statement 3:cursor.fetchall()
33. What is a csv file? 5
functions:
(i) INSERT() – To accept and add data of a student to a CSV file

‘student.csv’. Each record consists of a list with field elements as sid,
name and marksto store student id, name and marks respectively.
(i) COUNTSTUDENTS() – To count the number of records present in
theCSV file named‘student.csv’.
ANS:
import csv
def INSERT():
studlist=[]
while(choice=="y"):
sid=int(input("Enter Student id"))
name=input("Enter name")
marks=input("Enter Marks")
choice=input("Enter y to continue or press any to exit")
student=[sid,name,marks]
studlist.append(student)
file=open("student.csv","w")
writer=csv.writer(file)
writer.writerows(studlist)
def COUNTSTUDENTS():
file=open("student.csv","r")
reader=csv.reader(file)
print("No of students",len(reader))
OR
What is the purpose of delimiter?

functions:
(i) add() – To accept and add data of a product to a CSV file

‘product.csv’. Each record consists of a list with elements as
pid, pnameand priceto storeproduct id, product name and
pricerespectively.
(i) search()- To display the records of the products whose price is
more than5000.
14
ANS:
import csv
def add():
prodist=[]
while(choice=="y"):
pid=int(input("Enter product id"))
pname=input("Enter name")
price=input("Enter price")
choice=input("Enter y to continue or press any to exit")
product=[pid,pname,price]
prodlist.append(product)
file=open("product.csv","w")
writer=csv.writer(file)
writer.writerows(prodlist)
def search():
file=open("product.csv","r")
reader=csv.reader(file)
for record in reader:
if(record[2]>5000):
print("Product id",record[0])
print("Product name",record[1])
print("Product price",record[2])
1 mark for correct explanation of question
½ marks for correctly opening the file
½ marks for creating reader and writer objects
Full marks for correct code
SECTION E
34. Rahul created following table TRAVEL to store the travel details 1+1+2
(i) Identify the most appropriate column, which can be considered as

Primary key.
(ii) If 3 columns are added and 1rows are deleted from the table TRAVEL,
15
what will be the new degree and cardinality of the above table?

(a) Insert the following record into the table
110 BIMAL 28-11-2022 20 VOLVO BUS 40
(b) Increase KM travelled by 10 if the VTYPE is VOLVO.
ANS:
a)(i)TNO (ii)degree-9 cardinality-6
iii)a.INSERT INTO TRAVEL VALUES(110,’BIMAL’,’28-11-
2022’,200,’VOLVOBUS’,40)
b.UPDATE TRAVEL SET KM=KM+10 WHERE VTYPE=’VOLVO
BUS’

a. Delete the record of travel of traveler NANDA.
b. Add a column MILEAGE in the table with data type as
integer
ANS:
a)DELETE FROM TRAVEL WHERE TNAME=’NANDA’
b)ALTER TABLE TRAVEL ADD(MILEAGE int)
35. Biplab is a Python programmer. He has written a code and created a binary file
STUDENT.DAT which has structure (admission_number, Name, Percentage).
He has written an incomplete function countrec() in Python that would read
contents of the file “STUDENT.DAT” and display the details of those students
whose percentage is above 75. Also display number of students scoring above
75%.As a Python expert, help him to complete the following code based on the
requirement given above:
import __________#statement1
def countrec():
_____________________#Statement2
records=_______________#Statement3
count=0
for record in records:
if(_______________):#Statement4
count=count+1
print("ID",record[0])
print("NAME",record[1])
print("PERCENTAGE",record[2])
print("No of students with perentage above 75",count)
(i) Which module should be imported in the program? (Statement1)

(ii) Write the correct statement required to open a file named
STUDENT.DAT. in binary mode (Statement2)
16 1
(iii) Which statement should Biplab fill in Statement 3 to readthe
data from the binary file, STUDENT.DATand in Statement 4 to check the 1
percentage?
ANS
(i) pickle
2
(ii)fp=open("STUDENT.DAT","rb")
(iii)records=pickle.load(fp)
if(record[2]>75)
17
Sample Question Paper (Theory)
Que Question Marks

s No
SECTION A
“In a Python program, if a break statement is given in a nested loop, it
terminates the execution of all loops in one go.”
2 In a table in MYSQL database, an attribute A of datatype varchar(20) 1
has the value “Keshav”. The attribute B of datatype char(20) has value
“Meenakshi”. How many characters are occupied by attribute A and
attribute B?
a. 20,6 b. 6,20
c. 9,6 d. 6,9

print(3-2**2**3+99/11)
a. 244 b. 244.0
c. -244.0 d. Error
[1]
Options:
a. PYTHON-IS-Fun
b. PYTHON-is-Fun
c. Python-is-fun
d. PYTHON-Is -Fun
5 In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and 1
another table, Beta has degree 3 and cardinality 5, what will be the degree
and cardinality of the Cartesian product of Alpha and Beta?
a. 5,3 b. 8,15
c. 3,5 d. 15,8
6 Riya wants to transfer pictures from her mobile phone to her laptop. She 1
uses 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 Which of the following will delete key-value pair for key = “Red” from a 1
dictionary D1?
a. delete D1("Red")
b. del D1["Red"]
c. del.D1["Red"]
d. D1.del["Red"]
pride="#G20 Presidency"
print(pride[-2:2:-2])
[2]
Options:
a. ndsr
b. ceieP0
c. ceieP
d. yndsr
9 Which of the following statement(s) would give an error during execution of 1

the following code?
tup = (20,30,40,50,80,79)
print(tup) #Statement 1
print(tup[3]+50) #Statement 2
print(max(tup)) #Statement 3
tup[4]=80 #Statement 4
Options:
a. Statement 1
b. Statement 2
c. Statement 3
d. Statement 4

executed?
Options:
a.
[3]
RED*
WHITE*
BLACK*
b.
WHITE*
BLACK*
c.
WHITE* WHITE*
BLACK* BLACK*
d.
YELLOW*
WHITE*WHITE*
BLACK* BLACK* BLACK*

The modem at the sender’s computer end acts as a ____________.
a. Model
b. Modulator
c. Demodulator
d. Convertor
12 Consider the code given below: 1
[4]
Which of the following statements should be given in the blank for
#Missing Statement, if the output produced is 110?
Options:
a. global a
b. global b=100
c. global b
d. global a=100

An exception may be raised even if the program is syntactically correct.
14 Which of the following statements is FALSE about keys in a relational 1
database?
a. Any candidate key is eligible to become a primary key.
b. A primary key uniquely identifies the tuples in a relation.
c. A candidate key that is not a primary key is a foreign key.
d. A foreign key is an attribute whose value is derived from the primary
key of another relation.

In case of _____________ switching, before a communication starts, a
dedicated path is identified between the sender and the receiver.
16 Which of the following functions changes the position of file pointer and 1
returns its new position?
a. flush()
b. tell()
c. seek()
d. offset()
Q17 and 18 are ASSERTION AND REASONING based questions. Mark

the correct choice as
[5]
17 Assertion(A): List is an immutable data type 1
Reasoning(R): When an attempt is made to update the value of an
immutable variable, the old variable is destroyed and a new variable is
created by the same name in memory.
18 Assertion(A): Python Standard Library consists of various modules. 1
Reasoning(R): A function in a module is used to simplify the code and
avoids repetition.
SECTION B
2
POP3 , URL
(ii) Give one difference between XML and HTML.
OR
(i) Define the term bandwidth with respect to networks.
(ii) How is http different from https?
20 The code given below accepts a number as an argument and returns the 2
reverse number. Observe the following code carefully and rewrite it after
removing all syntax and logical errors. Underline all the corrections made.
[6]
21 Write a function countNow(PLACES) in Python, that takes the 2
dictionary, PLACES as an argument and displays the names (in
uppercase)of the places whose names are longer than 5 characters.
For example, Consider the following dictionary
PLACES={1:"Delhi",2:"London",3:"Paris",4:"New
York",5:"Doha"}
LONDON
NEW YORK
OR
Write a function, lenWords(STRING), that takes a string as an argument
For example, if the string is "Come let us have some fun", the
tuple will have (4, 3, 2, 4, 4, 3)
2
functions/methods only:
(i) To insert an element 200 at the third position, in the list L1.
(ii) To check whether a string named, message ends with a full stop
/ period or not.
[7]
OR
A list named studentAge stores age of students of a class. Write the
Python command to import the required module and (using built-in
function) to display the most common age value from the given list.
24 Ms. Shalini has just created a table named “Employee” containing 2
columns Ename, Department and Salary.
After creating the table, she realized that she has forgotten to add a primary
key column in the table. Help her in writing an SQL command to add a
primary key column EmpId of integer type to the table Employee.
Thereafter, write the command to insert the following record in the table:
EmpId- 999
Ename- Shweta
Department: Production
Salary: 26900
OR
Zack is working in a database named SPORT, in which he has created a

table named “Sports” containing columns SportId, SportName,
no_of_players, and category.
After creating the table, he realized that the attribute, category has to be
deleted from the table and a new attribute TypeSport of data type string
has to be added. This attribute TypeSport cannot be left blank. Help Zack
write the commands to complete both the tasks.
[8]
SECTION C
27 Consider the table CLUB given below and write the output of the SQL 1*3=
3
queries that follow.
CID CNAME AGE GENDER SPORTS PAY DOAPP

5246 AMRITA 35 FEMALE CHESS 900 2006-
03-27
[9]
4687 SHYAM 37 MALE CRICKET 1300 2004-
04-15
1245 MEENA 23 FEMALE VOLLEYBALL 1000 2007-
06-18
1622 AMRIT 28 MALE KARATE 1000 2007-
09-05
1256 AMINA 36 FEMALE CHESS 1100 2003-
08-15
1720 MANJU 33 FEMALE KARATE 1250 2004-
04-10
2321 VIRAT 35 MALE CRICKET 1050 2005-
04-30
(i) SELECT COUNT(DISTINCT SPORTS) FROM CLUB;

(ii) SELECT CNAME, SPORTS FROM CLUB WHERE
DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
(iii) SELECT CNAME, AGE, PAY FROM CLUB WHERE
GENDER = "MALE" AND PAY BETWEEN 1000 AND
1200;
28 Write a function in Python to read a text file, Alpha.txt and displays 3
those lines which begin with the word ‘You’.
OR
Write a function, vowelCount() in Python that counts and displays the
number of vowels in the text file named Poem.txt.
29 Consider the table Personal given below: 1*3=
3
Table: Personal
P_ID Name Desig Salary Allowance
P01 Rohit Manager 89000 4800
[10]
P02 Kashish Clerk NULL 1600
P03 Mahesh Superviser 48000 NULL
P04 Salil Clerk 31000 1900

P05 Ravina Superviser NULL 2100
(i) Increase the salary by 5% of personals whose allowance is known.
(ii) Display Name and Total Salary (sum of Salary and Allowance) of
all personals. The column heading ‘Total Salary’ should also be
displayed.
(iii) Delete the record of personals who have salary greater than 25000
30 A list, NList contains following record as list elements: 3
[City, Country, distance from Delhi]
Each of these records are nested together to form a nested list. Write the
following user defined functions in Python to perform the specified
operations on the stack named travel.
(i) Push_element(NList): It takes the nested list as an
argument and pushes a list object containing name of the city and
country, which are not in India and distance is less than 3500 km
from Delhi.
(ii) Pop_element(): It pops the objects from the stack and displays
them. Also, the function should display “Stack Empty” when there
are no elements in the stack.
For example: If the nested list contains the following data:
NList=[["New York", "U.S.A.", 11734],
["Naypyidaw", "Myanmar", 3219],
["Dubai", "UAE", 2194],
["London", "England", 6693],
[11]
["Gangtok", "India", 1580],
["Columbo", "Sri Lanka", 3405]]
['Naypyidaw', 'Myanmar'],
['Dubai', 'UAE'],
['Columbo', 'Sri Lanka']
['Dubai', 'UAE']
['Naypyidaw', 'Myanmar']
Stack Empty
SECTION D
31 Consider the tables PRODUCT and BRAND given below: 1*4=
4
Table: PRODUCT
PCode PName UPrice Rating BID
P01 Shampoo 120 6 M03
P02 Toothpaste 54 8 M02
P03 Soap 25 7 M03
P05 Soap 38 5 M05
Table: BRAND
BID BName
M02 Dant Kanti
M03 Medimix
M04 Pepsodent
M05 Dove
[12]
(i) Display product name and brand name from the tables PRODUCT
and BRAND.
(ii) Display the structure of the table PRODUCT.
(iii) Display the average rating of Medimix and Dove brands
(iv) Display the name, price, and rating of products in descending order
of rating.
32 Vedansh is a Python programmer working in a school. For the Annual 4
Sports Event, he has created a csv file named Result.csv, to store the
results of students in different sports events. The structure of Result.csv
is :
[St_Id, St_Name, Game_Name, Result]
Where
St_Id is Student ID (integer)
ST_name is Student Name (string)
Game_Name is name of game in which student is participating(string)
Result is result of the game whose value can be either 'Won', 'Lost'
or 'Tie'
For efficiently maintaining data of the event, Vedansh wants to write the
following user defined functions:
Accept() – to accept a record from the user and add it to the file
Result.csv. The column headings should also be added on top of the csv
file.
wonCount() – to count the number of students who have won any event.
As a Python expert, help him complete the task.
SECTION E
[13]
33 Meticulous EduServe is an educational organization. It is planning to setup 1*5=
5
its India campus at Chennai with its head office at Delhi. The Chennai campus
has 4 main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA

From To Distance
ADMIN ENGINEERING 55 m
ADMIN BUSINESS 90 m
ADMIN MEDIA 50 m
ENGINEERING BUSINESS 55 m
ENGINEERING MEDIA 50 m
BUSINESS MEDIA 45 m
DELHI HEAD CHENNAI 2175 km
OFFICE CAMPUS

ADMIN 110
ENGINEERING 75
BUSINESS 40
MEDIA 12
DELHI HEAD 20
a) Suggest and draw the cable layout to efficiently connect various blocks of
buildings within the CHENNAI campus for connecting the digital devices.
[14]
b) Which network device will be used to connect computers in each block to
form a local area network?
c) Which block, in Chennai Campus should be made the server? Justify your
answer.
d) Which fast and very effective wireless transmission medium
should preferably be used to connect the head office at DELHI with the
campus in CHENNAI?
e) Is there a requirement of a repeater in the given cable layout? Why/
Why not?
34 (i) Differentiate between r+ and w+ file modes in Python. 2+3=
5
(ii) Consider a file, SPORT.DAT, containing records of the following
structure:
[SportName, TeamName, No_Players]
Write a function, copyData(), that reads contents from the file
SPORT.DAT and copies the records with Sport name as “Basket Ball”
to the file named BASKET.DAT. The function should return the total
number of records copied to the file BASKET.DAT.
OR
(i) How are text files different from binary files?
(ii) A Binary file, CINEMA.DAT has the following structure:
{MNO:[MNAME, MTYPE]}
Where
MNO – Movie Number
MNAME – Movie Name
MTYPE is Movie Type
Write a user defined function, findType(mtype), that accepts mtype
as parameter and displays all the records from the binary file
CINEMA.DAT, that have the value of Movie Type as mtype.
35 (i) Define the term Domain with respect to RDBMS. Give one example 1+4=
5
to support your answer.
[15]
(ii) Kabir wants to write a program in Python to insert the following record
in the table named Student in MYSQL database, SCHOOL:
 rno(Roll number )- integer
 name(Name) - string
 DOB (Date of birth) – Date
 Fee – float
MySQL:
 Username - root
The values of fields rno, name, DOB and fee has to be accepted from
the user. Help Kabir to write the program in Python.
OR
(i) Give one difference between alternate key and candidate key.
(ii) Sartaj has created a table named Student in MYSQL database,

SCHOOL:
 Fee – float
MySQL:
 Username - root
[16]
Sartaj, now wants to display the records of students whose fee is more than
5000. Help Sartaj to write the program in Python.
[17]
Class XII
Marking Scheme

No of Marks Marks
SECTION A
1 False 1 mark for 1
correct
answer

correct
6,20
answer

correct
-244.0 answer
4 PYTHON-is-Fun 1 mark for 1

correct
answer

correct
8,15
answer

correct
PAN
answer

correct
del D1["Red"] answer

correct
answer
[1]
ceieP0

correct
Statement 4 answer

correct
WHITE* answer
BLACK*

correct
Modulator answer

correct
global b answer

correct
answer

correct
A candidate key that is not a primary key is a foreign key. answer
15 Circuit 1 mark for 1

correct
answer

correct
seek() answer

A is false but R is True correct
answer
[2]
correct
Both A and R are true but R is not the correct explanation for A answer
SECTION B
19 (i) ½ mark for 1+1=2
each correct
POP3 – Post Office Protocol 3 expansion
URL – Uniform Resource Locator
(ii)
HTML( Hyper text mark Up language)
 We use pre-defined tags

 Static web development language – only focuses on how
data looks
 It use for only displaying data, cannot transport data
 Not case sensistive
XML (Extensible Markup Language) 1 mark for

any one
correct
 we can define our own tags and use them
difference
 Dynamic web development language – as it is used for
No mark to
transporting and storing data be awarded if
 Case sensitive only full form
is given
OR
(i) Bandwidth is the maximum rate of data transfer over 1 mark for
correct
a given transmission medium. / The amount of definition
information that can be transmitted over a network.
[3]
(ii) https (Hyper Text Transfer Protocol Secure) is the 1 mark for
correct
protocol that uses SSL (Secure Socket Layer) to
difference.
encrypt data being transmitted over the Internet.
Therefore, https helps in secure browsing while http
does not.
20 def revNumber(num): ½ mark for 2

rev = 0 each
rem = 0 correction
while num > 0: made
rem =num %10
rev = rev*10 + rem
num = num//10
return rev
print(revNumber(1234))
21 ½ mark for 2
correct
function
header
½ mark for
correct loop
½ mark for
correct if
statement
½ mark for
displaying
OR
the output
½ mark for
correct
function
header
½ mark for
using split()
[4]
½ mark for
adding to
tuple
½ mark for
return
statement
22 4*L ½ mark for 2

each correct
33*4
line of output
21*S
10*6
each correct
(ii) message.endswith('.') statement
OR
import statistics
1 mark for
print( statistics.mode(studentAge) )
correct
import
statement
1 mark for
correct
command
with mode()
and print()

correct
ALTER TABLE Employee ADD EmpId INTEGER ALTER TABLE
command
PRIMARY KEY;
[5]
As the primary key is added as the last field, the command for
inserting data will be: 1 mark for
correct
INSERT INTO Employee INSERT
VALUES("Shweta","Production",26900,999); command
Alternative answer:
INSERT INTO
Employee(EmpId,Ename,Department,Salary)
VALUES(999,"Shweta","Production",26900);
OR
To delete the attribute, category:
1 mark for
ALTER TABLE Sports correct
DROP category; ALTER TABLE
command
with DROP
To add the attribute, TypeSport
1 mark for
correct
ALTER TABLE Sports ALTER TABLE
command
ADD TypeSport char(10) NOT NULL; with ADD
25 10.0$20 1 mark for 2

each correct
10.0$2.0###
line of output
SECTION C
26 ND-*34 ½ mark for 3
each correct
character
27
1 mark for 1*3=3

each correct
(i)
output
COUNT(DISTINCT SPORTS)
[6]
4
(ii)
CNAME SPORTS
AMINA CHESS
(iii)
CNAME AGE PAY
AMRIT 28 1000
VIRAT 35 1050
28 1 mark for 3
correctly
opening and
closing files
½ mark for
correctly
reading data
1 mark for
correct loop
and if
statement
OR
½ mark for
displaying
data
1 mark for
correctly
opening and
closing the
files
[7]
½ mark for
correctly
reading data
1 mark for
correct loop
and if
statement
½ mark for
displaying
the output.

29 (i) 1 mark for 1*3=3
each correct
UPDATE Personal
query
(ii)
SELECT Name, Salary + Allowance AS
"Total Salary" FROM Personal;
(iii)
DELETE FROM Personal
WHERE Salary>25000
[8]
30 1 ½ marks for 3
each function
SECTION D
31 (i) 1 mark for 1*4=4
each correct
SELECT PName, BName FROM PRODUCT P,
query
BRAND B WHERE P.BID=B.BID;
(ii)
DESC PRODUCT;
(iii)
SELECT BName, AVG(Rating) FROM PRODUCT
P, BRAND B
WHERE P.BID=B.BID
GROUP BY BName
HAVING BName='Medimix' OR
BName='Dove';
(iv)
SELECT PName, UPrice, Rating
FROM PRODUCT
ORDER BY Rating DESC;
[9]
32 ½ mark for 4
accepting
data
correctly
½ mark for
opening and
closing file
½ mark for
writing
headings
½ mark for
writing row
½ mark for
opening and
closing file
½ mark for
reader object
½ mark for
print heading
½ mark for
printing data
SECTION E
33 a) 1 mark for 1*5=5
each correct
Bus Topology
answer
ENGINEERING
Admin
BUSINESS
MEDIA
[10]
b) Switch
c) Admin block, as it has maximum number of computers.
d) Microwave
e) No, a repeater is not required in the given cable layout as the
length of transmission medium between any two blocks does not
exceed 70 m.
34 (i) 1 mark for 2+3=5

each correct
r+ mode:
difference
 Primary function is reading
( minimum
 File pointer is at beginning of file two
differences
 if the file does not exist, it results in an error
should be
w+ mode: given)
 primary function is writing
 if the file does not exist, it creates a new file.
 If the file exists, previous data is overwritten
 File pointer is at the beginning of file
(ii)
½ mark for
correctly
opening and
closing files
½ mark for
correct try
and except
block
½ mark for
correct loop
1 mark for
correctly
copying data
[11]
½ mark for
correct
return
statement
½ mark for
correctly
opening and
closing files
½ mark for
correct try
and except
block
½ mark for
correct loop
½ mark for
OR correct if
(i) Text files: statement
 Extension is .txt 1 mark for

correctly
 Data is stored in ASCII format that is human readable
displaying
 Has EOL character that terminates each line of data data
stored in the text files
Binary Files
 Extension is .dat
 Data is stored in binary form (0s and 1s), that is not
human readable.
(ii)
[12]
35 (i) Domain is a set of values from which an attribute can ½ mark for 1+4=5
correct
take value in each row. For example, roll no field can
definition
have only integer values and so its domain is a set of
½ mark for
integer values correct
example
(ii)
½ mark for
importing
correct
module
1 mark for
correct
connect()
½ mark for
correctly
accepting the
input
1 ½ mark for
correctly
[13]
executing the
query
½ mark for
correctly
using
OR commit()
(i) All keys that have the properties to become a primary

key are candidate keys. The candidate keys that do not
become primary keys are alternate keys.
1 mark for
(ii) correct
difference
½ mark for
importing
correct
module
1 mark for
correct
connect()
1 mark for
correctly
executing
the query
½ mark for
correctly
using
fetchall()
1 mark for
correctly
[14]
displaying
data
[15]
Sample Question Paper (Theory)
Que Question Marks

s No
SECTION A
“In a Python program, if a break statement is given in a nested loop, it
terminates the execution of all loops in one go.”
2 In a table in MYSQL database, an attribute A of datatype varchar(20) 1
has the value “Keshav”. The attribute B of datatype char(20) has value
“Meenakshi”. How many characters are occupied by attribute A and
attribute B?
a. 20,6 b. 6,20
c. 9,6 d. 6,9

print(3-2**2**3+99/11)
a. 244 b. 244.0
c. -244.0 d. Error
[1]
Options:
a. PYTHON-IS-Fun
b. PYTHON-is-Fun
c. Python-is-fun
d. PYTHON-Is -Fun
5 In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and 1
another table, Beta has degree 3 and cardinality 5, what will be the degree
and cardinality of the Cartesian product of Alpha and Beta?
a. 5,3 b. 8,15
c. 3,5 d. 15,8
6 Riya wants to transfer pictures from her mobile phone to her laptop. She 1
uses 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 Which of the following will delete key-value pair for key = “Red” from a 1
dictionary D1?
a. delete D1("Red")
b. del D1["Red"]
c. del.D1["Red"]
d. D1.del["Red"]
pride="#G20 Presidency"
print(pride[-2:2:-2])
[2]
Options:
a. ndsr
b. ceieP0
c. ceieP
d. yndsr
9 Which of the following statement(s) would give an error during execution of 1

the following code?
tup = (20,30,40,50,80,79)
print(tup) #Statement 1
print(tup[3]+50) #Statement 2
print(max(tup)) #Statement 3
tup[4]=80 #Statement 4
Options:
a. Statement 1
b. Statement 2
c. Statement 3
d. Statement 4

executed?
Options:
a.
[3]
RED*
WHITE*
BLACK*
b.
WHITE*
BLACK*
c.
WHITE* WHITE*
BLACK* BLACK*
d.
YELLOW*
WHITE*WHITE*
BLACK* BLACK* BLACK*

The modem at the sender’s computer end acts as a ____________.
a. Model
b. Modulator
c. Demodulator
d. Convertor
12 Consider the code given below: 1
[4]
Which of the following statements should be given in the blank for
#Missing Statement, if the output produced is 110?
Options:
a. global a
b. global b=100
c. global b
d. global a=100

An exception may be raised even if the program is syntactically correct.
14 Which of the following statements is FALSE about keys in a relational 1
database?
a. Any candidate key is eligible to become a primary key.
b. A primary key uniquely identifies the tuples in a relation.
c. A candidate key that is not a primary key is a foreign key.
d. A foreign key is an attribute whose value is derived from the primary
key of another relation.

In case of _____________ switching, before a communication starts, a
dedicated path is identified between the sender and the receiver.
16 Which of the following functions changes the position of file pointer and 1
returns its new position?
a. flush()
b. tell()
c. seek()
d. offset()
Q17 and 18 are ASSERTION AND REASONING based questions. Mark

the correct choice as
[5]
17 Assertion(A): List is an immutable data type 1
Reasoning(R): When an attempt is made to update the value of an
immutable variable, the old variable is destroyed and a new variable is
created by the same name in memory.
18 Assertion(A): Python Standard Library consists of various modules. 1
Reasoning(R): A function in a module is used to simplify the code and
avoids repetition.
SECTION B
2
POP3 , URL
(ii) Give one difference between XML and HTML.
OR
(i) Define the term bandwidth with respect to networks.
(ii) How is http different from https?
20 The code given below accepts a number as an argument and returns the 2
reverse number. Observe the following code carefully and rewrite it after
removing all syntax and logical errors. Underline all the corrections made.
[6]
21 Write a function countNow(PLACES) in Python, that takes the 2
dictionary, PLACES as an argument and displays the names (in
uppercase)of the places whose names are longer than 5 characters.
For example, Consider the following dictionary
PLACES={1:"Delhi",2:"London",3:"Paris",4:"New
York",5:"Doha"}
LONDON
NEW YORK
OR
Write a function, lenWords(STRING), that takes a string as an argument
For example, if the string is "Come let us have some fun", the
tuple will have (4, 3, 2, 4, 4, 3)
2
functions/methods only:
(i) To insert an element 200 at the third position, in the list L1.
(ii) To check whether a string named, message ends with a full stop
/ period or not.
[7]
OR
A list named studentAge stores age of students of a class. Write the
Python command to import the required module and (using built-in
function) to display the most common age value from the given list.
24 Ms. Shalini has just created a table named “Employee” containing 2
columns Ename, Department and Salary.
After creating the table, she realized that she has forgotten to add a primary
key column in the table. Help her in writing an SQL command to add a
primary key column EmpId of integer type to the table Employee.
Thereafter, write the command to insert the following record in the table:
EmpId- 999
Ename- Shweta
Department: Production
Salary: 26900
OR
Zack is working in a database named SPORT, in which he has created a

table named “Sports” containing columns SportId, SportName,
no_of_players, and category.
After creating the table, he realized that the attribute, category has to be
deleted from the table and a new attribute TypeSport of data type string
has to be added. This attribute TypeSport cannot be left blank. Help Zack
write the commands to complete both the tasks.
[8]
SECTION C
27 Consider the table CLUB given below and write the output of the SQL 1*3=
3
queries that follow.
CID CNAME AGE GENDER SPORTS PAY DOAPP

5246 AMRITA 35 FEMALE CHESS 900 2006-
03-27
[9]
4687 SHYAM 37 MALE CRICKET 1300 2004-
04-15
1245 MEENA 23 FEMALE VOLLEYBALL 1000 2007-
06-18
1622 AMRIT 28 MALE KARATE 1000 2007-
09-05
1256 AMINA 36 FEMALE CHESS 1100 2003-
08-15
1720 MANJU 33 FEMALE KARATE 1250 2004-
04-10
2321 VIRAT 35 MALE CRICKET 1050 2005-
04-30
(i) SELECT COUNT(DISTINCT SPORTS) FROM CLUB;

(ii) SELECT CNAME, SPORTS FROM CLUB WHERE
DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
(iii) SELECT CNAME, AGE, PAY FROM CLUB WHERE
GENDER = "MALE" AND PAY BETWEEN 1000 AND
1200;
28 Write a function in Python to read a text file, Alpha.txt and displays 3
those lines which begin with the word ‘You’.
OR
Write a function, vowelCount() in Python that counts and displays the
number of vowels in the text file named Poem.txt.
29 Consider the table Personal given below: 1*3=
3
Table: Personal
P_ID Name Desig Salary Allowance
P01 Rohit Manager 89000 4800
[10]
P02 Kashish Clerk NULL 1600
P03 Mahesh Superviser 48000 NULL
P04 Salil Clerk 31000 1900

P05 Ravina Superviser NULL 2100
(i) Increase the salary by 5% of personals whose allowance is known.
(ii) Display Name and Total Salary (sum of Salary and Allowance) of
all personals. The column heading ‘Total Salary’ should also be
displayed.
(iii) Delete the record of personals who have salary greater than 25000
30 A list, NList contains following record as list elements: 3
[City, Country, distance from Delhi]
Each of these records are nested together to form a nested list. Write the
following user defined functions in Python to perform the specified
operations on the stack named travel.
(i) Push_element(NList): It takes the nested list as an
argument and pushes a list object containing name of the city and
country, which are not in India and distance is less than 3500 km
from Delhi.
(ii) Pop_element(): It pops the objects from the stack and displays
them. Also, the function should display “Stack Empty” when there
are no elements in the stack.
For example: If the nested list contains the following data:
NList=[["New York", "U.S.A.", 11734],
["Naypyidaw", "Myanmar", 3219],
["Dubai", "UAE", 2194],
["London", "England", 6693],
[11]
["Gangtok", "India", 1580],
["Columbo", "Sri Lanka", 3405]]
['Naypyidaw', 'Myanmar'],
['Dubai', 'UAE'],
['Dubai', 'UAE']
['Naypyidaw', 'Myanmar']
Stack Empty
SECTION D
31 Consider the tables PRODUCT and BRAND given below: 1*4=
4
Table: PRODUCT
PCode PName UPrice Rating BID
P03 Soap 25 7 M03
P05 Soap 38 5 M05
Table: BRAND
BID BName
M02 Dant Kanti
M03 Medimix
M04 Pepsodent
M05 Dove
[12]
(i) Display product name and brand name from the tables PRODUCT
and BRAND.
(ii) Display the structure of the table PRODUCT.
(iii) Display the average rating of Medimix and Dove brands
(iv) Display the name, price, and rating of products in descending order
of rating.
32 Vedansh is a Python programmer working in a school. For the Annual 4
Sports Event, he has created a csv file named Result.csv, to store the
results of students in different sports events. The structure of Result.csv
is :
[St_Id, St_Name, Game_Name, Result]
Where
St_Id is Student ID (integer)
ST_name is Student Name (string)
Game_Name is name of game in which student is participating(string)
Result is result of the game whose value can be either 'Won', 'Lost'
or 'Tie'
For efficiently maintaining data of the event, Vedansh wants to write the
following user defined functions:
Accept() – to accept a record from the user and add it to the file
Result.csv. The column headings should also be added on top of the csv
file.
wonCount() – to count the number of students who have won any event.
As a Python expert, help him complete the task.
SECTION E
[13]
33 Meticulous EduServe is an educational organization. It is planning to setup 1*5=
5
its India campus at Chennai with its head office at Delhi. The Chennai campus
has 4 main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA

From To Distance
ADMIN ENGINEERING 55 m
ADMIN BUSINESS 90 m
ADMIN MEDIA 50 m
ENGINEERING BUSINESS 55 m
ENGINEERING MEDIA 50 m
BUSINESS MEDIA 45 m
DELHI HEAD CHENNAI 2175 km
OFFICE CAMPUS

ADMIN 110
ENGINEERING 75
BUSINESS 40
MEDIA 12
DELHI HEAD 20
a) Suggest and draw the cable layout to efficiently connect various blocks of
buildings within the CHENNAI campus for connecting the digital devices.
[14]
b) Which network device will be used to connect computers in each block to
form a local area network?
c) Which block, in Chennai Campus should be made the server? Justify your
answer.
d) Which fast and very effective wireless transmission medium
should preferably be used to connect the head office at DELHI with the
campus in CHENNAI?
e) Is there a requirement of a repeater in the given cable layout? Why/
Why not?
34 (i) Differentiate between r+ and w+ file modes in Python. 2+3=
5
(ii) Consider a file, SPORT.DAT, containing records of the following
structure:
[SportName, TeamName, No_Players]
Write a function, copyData(), that reads contents from the file
SPORT.DAT and copies the records with Sport name as “Basket Ball”
to the file named BASKET.DAT. The function should return the total
number of records copied to the file BASKET.DAT.
OR
(i) How are text files different from binary files?
(ii) A Binary file, CINEMA.DAT has the following structure:
{MNO:[MNAME, MTYPE]}
Where
MNO – Movie Number
MNAME – Movie Name
MTYPE is Movie Type
Write a user defined function, findType(mtype), that accepts mtype
as parameter and displays all the records from the binary file
CINEMA.DAT, that have the value of Movie Type as mtype.
35 (i) Define the term Domain with respect to RDBMS. Give one example 1+4=
5
to support your answer.
[15]
(ii) Kabir wants to write a program in Python to insert the following record
in the table named Student in MYSQL database, SCHOOL:
 Fee – float
MySQL:
 Username - root
The values of fields rno, name, DOB and fee has to be accepted from
the user. Help Kabir to write the program in Python.
OR
(i) Give one difference between alternate key and candidate key.
(ii) Sartaj has created a table named Student in MYSQL database,

SCHOOL:
 Fee – float
MySQL:
 Username - root
[16]
Sartaj, now wants to display the records of students whose fee is more than
5000. Help Sartaj to write the program in Python.
[17]
Class XII
Marking Scheme

No of Marks Marks
SECTION A
1 False 1 mark for 1
correct
answer

correct
6,20
answer

correct
-244.0 answer
4 PYTHON-is-Fun 1 mark for 1

correct
answer

correct
8,15
answer

correct
PAN
answer

correct
del D1["Red"] answer

correct
answer
[1]
ceieP0

correct
Statement 4 answer

correct
WHITE* answer
BLACK*

correct
Modulator answer

correct
global b answer

correct
answer

correct
A candidate key that is not a primary key is a foreign key. answer
15 Circuit 1 mark for 1

correct
answer

correct
seek() answer

A is false but R is True correct
answer
[2]
correct
Both A and R are true but R is not the correct explanation for A answer
SECTION B
19 (i) ½ mark for 1+1=2
each correct
POP3 – Post Office Protocol 3 expansion
URL – Uniform Resource Locator
(ii)
HTML( Hyper text mark Up language)
 We use pre-defined tags

 Static web development language – only focuses on how
data looks
 It use for only displaying data, cannot transport data
 Not case sensistive
XML (Extensible Markup Language) 1 mark for

any one
correct
 we can define our own tags and use them
difference
 Dynamic web development language – as it is used for
No mark to
transporting and storing data be awarded if
 Case sensitive only full form
is given
OR
(i) Bandwidth is the maximum rate of data transfer over 1 mark for
correct
a given transmission medium. / The amount of definition
information that can be transmitted over a network.
[3]
(ii) https (Hyper Text Transfer Protocol Secure) is the 1 mark for
correct
protocol that uses SSL (Secure Socket Layer) to
difference.
encrypt data being transmitted over the Internet.
Therefore, https helps in secure browsing while http
does not.
20 def revNumber(num): ½ mark for 2

rev = 0 each
rem = 0 correction
while num > 0: made
rem =num %10
rev = rev*10 + rem
num = num//10
return rev
print(revNumber(1234))
21 ½ mark for 2
correct
function
header
½ mark for
correct loop
½ mark for
correct if
statement
½ mark for
displaying
OR
the output
½ mark for
correct
function
header
½ mark for
using split()
[4]
½ mark for
adding to
tuple
½ mark for
return
statement
22 4*L ½ mark for 2

each correct
33*4
line of output
21*S
10*6
each correct
(ii) message.endswith('.') statement
OR
import statistics
1 mark for
print( statistics.mode(studentAge) )
correct
import
statement
1 mark for
correct
command
with mode()
and print()

correct
ALTER TABLE Employee ADD EmpId INTEGER ALTER TABLE
command
PRIMARY KEY;
[5]
As the primary key is added as the last field, the command for
inserting data will be: 1 mark for
correct
INSERT INTO Employee INSERT
VALUES("Shweta","Production",26900,999); command
Alternative answer:
INSERT INTO
Employee(EmpId,Ename,Department,Salary)
VALUES(999,"Shweta","Production",26900);
OR
To delete the attribute, category:
1 mark for
ALTER TABLE Sports correct
DROP category; ALTER TABLE
command
with DROP
To add the attribute, TypeSport
1 mark for
correct
ALTER TABLE Sports ALTER TABLE
command
ADD TypeSport char(10) NOT NULL; with ADD
25 10.0$20 1 mark for 2

each correct
10.0$2.0###
line of output
SECTION C
26 ND-*34 ½ mark for 3
each correct
character
27
1 mark for 1*3=3

each correct
(i)
output
COUNT(DISTINCT SPORTS)
[6]
4
(ii)
CNAME SPORTS
AMINA CHESS
(iii)
CNAME AGE PAY
AMRIT 28 1000
VIRAT 35 1050
28 1 mark for 3
correctly
opening and
closing files
½ mark for
correctly
reading data
1 mark for
correct loop
and if
statement
OR
½ mark for
displaying
data
1 mark for
correctly
opening and
closing the
files
[7]
½ mark for
correctly
reading data
1 mark for
correct loop
and if
statement
½ mark for
displaying
the output.

29 (i) 1 mark for 1*3=3
each correct
UPDATE Personal
query
(ii)
SELECT Name, Salary + Allowance AS
"Total Salary" FROM Personal;
(iii)
DELETE FROM Personal
WHERE Salary>25000
[8]
30 1 ½ marks for 3
each function
SECTION D
31 (i) 1 mark for 1*4=4
each correct
SELECT PName, BName FROM PRODUCT P,
query
BRAND B WHERE P.BID=B.BID;
(ii)
DESC PRODUCT;
(iii)
SELECT BName, AVG(Rating) FROM PRODUCT
P, BRAND B
WHERE P.BID=B.BID
GROUP BY BName
HAVING BName='Medimix' OR
BName='Dove';
(iv)
SELECT PName, UPrice, Rating
FROM PRODUCT
ORDER BY Rating DESC;
[9]
32 ½ mark for 4
accepting
data
correctly
½ mark for
opening and
closing file
½ mark for
writing
headings
½ mark for
writing row
½ mark for
opening and
closing file
½ mark for
reader object
½ mark for
print heading
½ mark for
printing data
SECTION E
33 a) 1 mark for 1*5=5
each correct
Bus Topology
answer
ENGINEERING
Admin
BUSINESS
MEDIA
[10]
b) Switch
c) Admin block, as it has maximum number of computers.
d) Microwave
e) No, a repeater is not required in the given cable layout as the
length of transmission medium between any two blocks does not
exceed 70 m.
34 (i) 1 mark for 2+3=5

each correct
r+ mode:
difference
 Primary function is reading
( minimum
 File pointer is at beginning of file two
differences
 if the file does not exist, it results in an error
should be
w+ mode: given)
 primary function is writing
 if the file does not exist, it creates a new file.
 If the file exists, previous data is overwritten
 File pointer is at the beginning of file
(ii)
½ mark for
correctly
opening and
closing files
½ mark for
correct try
and except
block
½ mark for
correct loop
1 mark for
correctly
copying data
[11]
½ mark for
correct
return
statement
½ mark for
correctly
opening and
closing files
½ mark for
correct try
and except
block
½ mark for
correct loop
½ mark for
OR correct if
(i) Text files: statement
 Extension is .txt 1 mark for

correctly
 Data is stored in ASCII format that is human readable
displaying
 Has EOL character that terminates each line of data data
stored in the text files
Binary Files
 Extension is .dat
 Data is stored in binary form (0s and 1s), that is not
human readable.
(ii)
[12]
35 (i) Domain is a set of values from which an attribute can ½ mark for 1+4=5
correct
take value in each row. For example, roll no field can
definition
have only integer values and so its domain is a set of
½ mark for
integer values correct
example
(ii)
½ mark for
importing
correct
module
1 mark for
correct
connect()
½ mark for
correctly
accepting the
input
1 ½ mark for
correctly
[13]
executing the
query
½ mark for
correctly
using
OR commit()
(i) All keys that have the properties to become a primary

key are candidate keys. The candidate keys that do not
become primary keys are alternate keys.
1 mark for
(ii) correct
difference
½ mark for
importing
correct
module
1 mark for
correct
connect()
1 mark for
correctly
executing
the query
½ mark for
correctly
using
fetchall()
1 mark for
correctly
[14]
displaying
data
[15]
KENDRIYA VIDYALAYA SANGATHAN
RANCHI RAGION
COMPUTER SCINCE (083)
FIRST PRE-BOARD EXAMINATION
Class-XII
Max Marks-70 Time: 3 hrs
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c
only.
SECTION A
1 Identify the invalid Python statement from the following. 1
(a) _b=1 (b) __b1= 1 (c) b_=1 (d) 1 = _b
2 Identify the valid arithmetic operator in Python from the following. 1

(a) // (b) < (c) or (d) <>
3 If Statement in Python is __ 1
(a) looping statement (b) selection statement (c) iterative (d) sequential
4 Predict the correct output of the following Python statement – 1

print(4 + 3**3/2)
(a) 8 (b) 9 (c) 8.0 (d) 17.5
5 Choose the most correct statement among the following – 1
(a) a dictionary is a sequential set of elements

(b) a dictionary is a set of key-value pairs
(c) a dictionary is a sequential collection of elements key-value pairs
(d) a dictionary is a non-sequential collection of elements
6 Consider the string state = “Jharkhand”. Identify the appropriate statement that will display the last 1
five characters of the string state?
(a) state [-5:] (b) state [4:] (c) state [:4] (d) state [:-4]
7 What will be the output of the following lines of Python code? 1
if not False:
print(10)
else:
print(20)
Page 1 of 9
(a) 10 (b) 20 (c) True (d) False
8 Consider the Python statement: f.seek(10, 1) 1

Choose the correct statement from the following:
(a) file pointer will move 10 byte in forward direction from beginning of the file
(b) file pointer will move 10 byte in forward direction from end of the file
(c) file pointer will move 10 byte in forward direction from current location
(d) file pointer will move 10 byte in backward direction from current location
9 Which of the following function returns a list datatype? 1
a) d=f.read() b) d=f.read(10) c) d=f.readline() d) d=f.readlines()
10 Identify the device on the network which is responsible for forwarding data from one device to 1
another
(a) NIC (b) Router (c) RJ45 (d) Repeater
11 A table has initially 5 columns and 8 rows. Consider the following sequence of operations 1
performed on the table –
i. 8 rows are added
ii. 2 columns are added
iii. 3 rows are deleted
iv. 1 column is added
What will be the cardinality and degree of the table at the end of above operations?
(a) 13,8 (b) 8, 13 (c) 14,5 (d) 5,8
12 Which of the following constraint is used to prevent a duplicate value in a record? 1
(a) Empty (b) check (c) primary key (d) unique
13 The structure of the table/relation can be displayed using __________ command. 1
(a) view (b) describe (c) show (d) select
14 Which of the following clause is used to remove the duplicating rows from a select statement? 1
(a) or (b) distinct (c) any (d)unique
15 How do you change the file position to an offset value from the start? 1
(a) fp.seek(offset, 0) (b) fp.seek(offset, 1) (c) fp.seek(offset, 2) (d) None of them
16 Which of the following method is used to create a connection between the MySQL database and 1
Python?
(a) connector ( ) (b) connect ( ) (c) con ( ) (d) cont ( )
Page 2 of 9
17 Assertion (A): The function definition calculate(a, b, c=1,d) will give error. 1
Reason (R): All the non-default arguments must precede the default arguments.
18 Assertion (A): CSV files are used to store the data generated by various social media platforms. 1
Reason (R): CSV file can be opened with MS Excel.
SECTION - B
19 Find error in the following code(if any) and correct code by rewriting code and underline the 2
correction;‐
x= int(“Enter value of x:”)

for in range [0,10]:
if x=y
print( x + y)
else:
print( x‐y)
20 (a) 2
Find output generated by the following code:
Str = "Computer"
Str = Str[-4:]
print(Str*2)
OR
Consider the following lines of codes in Python and write the appropriate output:
student = {'rollno':1001, 'name':'Akshay', 'age':17}

student['name']= “Abhay”
print(student)
21 What do you mean by Foreign key? How it is related with Referential Integrity? 2
22 Find output generated by the following code: 2

string="aabbcc"
count=3
while True:
if string[0]=='a':
string=string[2:]
elif string[-1]=='b':
string=string[:2]
else:
count+=1
break
print(string)
print(count)
23 Expand the following terms: 2

i. NIC
ii. TCP/IP
iii. POP
iv. SMTP
Page 3 of 9
24 Write one advantage and one disadvantage of each – STAR Topology and Tree Topology 2
OR
What do you mean by Guided Media? Name any three guided media?
25 Differentiate between DDL and DML? 2
OR
Write the main difference between INSERT and UPDATE Commands in SQL
SECTION - C
26 Write definition of a method/function AddOdd(VALUES) to display sum of odd values from the 3
list of VALUES
27 Define a function SHOWWORD () in python to read lines from a text file STORY.TXT, and 3
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
28 Write the outputs of the SQL queries (a) to (c) based on the relation Furniture 3
No Itemname Type Dateofstock Price Discount

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 Table 01/01/2002 25000 30
5 Comfort Zone Double Bed 12/01/2002 25000 25
6 Donald Baby Cot 24/02/2002 6500 15
7 Royal finish Office Table 20/02/2002 18000 30
8 Royal tiger Sofa 22/02/2002 31000 30
9 Econo sitting Sofa 13/12/2001 9500 25
10 paradise Dining Table 19/02/2002 11500 25
11 Wood Comfort Double Bed 23/03/2003 25000 25
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 MONTHNAME(Dateofstock) FROM Furniture WHERE Type="Sofa";
(c) SELECT Price*Discount FROM Furniture WHERE Dateofstock>31/12/02;
29 Consider the following table GAMES 3
GCode GameName Number PrizeMoney ScheduleDate

101 Carom Board 2 5000 23‐Jan‐2004
102 Badminton 2 12000 12‐Dec‐2003
103 Table Tennis 4 8000 14‐Feb‐2004
105 Chess 2 9000 01‐Jan‐2004
108 Lawn Tennis 4 25000 19‐Mar‐2004
Write the output for the following queries :
Page 4 of 9
(i) SELECT COUNT(DISTINCT Number) FROM GAMES;
(ii) SELECT MAX(ScheduleDate),MIN(ScheduleDate) FROM GAMES;
(iii) SELECT SUM(PrizeMoney) FROM GAMES;
30 Write PushOn(Book) and Pop(Book) methods/functions in Python to add a new Book and delete a 3
Book from a list of Book titles, considering them to act as push and pop operations of the Stack data
structure.
OR
Mr.Ajay has created a list of elements. Help him to write a program in python with functions,
PushEl(element) and PopEl(element) to add a new element and delete an element from a List of
element Description, 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 24 8
SECTION - D
31 India Tech Solutions (ITS) is a professional consultancy company. The company is planning 5
to set up their new offices in India with its hub at Hyderabad. As a 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 TTC
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 TTC 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
• lInfrared
Page 5 of 9
• Ethernet
(iv)Which of the following device will be suggested by you to connect each computer in each
of the buildings?
• l Switch
• l Modem
• l Gateway
(v) Company is planning to connect its offices in Hyderabad which is less than 1 km. Which
type of network will be formed?
32 Find the output of the following: 2

(a)
fruit_list1 = ['Apple', 'Berry', 'Cherry', 'Papaya']
fruit_list2 = fruit_list1
fruit_list3 = fruit_list1[:]
fruit_list2[0] = 'Guava'
fruit_list3[1] = 'Kiwi'
sum = 0
for ls in (fruit_list1, fruit_list2, fruit_list3):
if ls[0] == 'Guava':
sum += 1
if ls[1] == 'Kiwi':
sum += 20
print (sum)
(b) Consider the table 3

TRAINER
TI TNAME CITY HIREDAT SALAR
D E Y
101 SUNAINA MUMBAI 1998‐10‐15 90000
102 ANAMIKA DELHI 1994‐12‐24 80000
103 DEEPTI CHANDIGA 2001‐12‐21 82000
RG
104 MEENAKSHI DELHI 2002‐12‐25 78000
105 RICHA MUMBAI 1996‐01‐12 95000
106 MANIPRAB CHENNAI 2001‐12‐12 69000
HA
The Following program code is used to increase the salary of Trainer SUNAINA by 2000.

Username is root
Password is system
The table exists in a MYSQL database named Admin.

Statement 2 – to execute the command that inserts the record in the table Student.
Statement 3- to add the record permanently in the database
import mysql.connector as mydb

mycon = mydb.connect
(host = “localhost”,
user = “root”,
Page 6 of 9
passwd = “system”,
database = “Admin”)
cursor = _______________ #Statement 1
sql = “UPDATE TRAINER SET SALARY = SALARY + 2000
WHERE TNAME = ‘SUNAINA’”
cursor. _______________ #Statement 2
_______________ #Statement 3
mycon.close( )
OR
(a) Write the output of the following Python program code: 2
my_dict = {}
my_dict[(1,2,4)] = 8
my_dict[(4,2,1)] = 10
my_dict[(1,2)] = 12
sum = 0
for k in my_dict:
sum += my_dict[k]
print (sum)
print(my_dict)
(b) Consider the table 3

TABLE : GRADUATE
S.N NAME STIPEN SUBJECT AVERAG DI
O D E V
1 KARAN 400 PHYSICS 68 I
2 DIWAKA 450 COMP Sc 68 I
R
3 DIVYA 300 CHEMISTR 62 I
Y
4 REKHA 350 PHYSICS 63 I
5 ARJUN 500 MATHS 70 I
6 SABINA 400 CHEMISTR 55 II
Y
7 JOHN 250 PHYSICS 64 I
8 ROBERT 450 MATHS 68 I
9 RUBINA 500 COMP Sc 62 I
10 VIKAS 400 MATHS 57 II
The Following program code is used to view the details of the graduate whose subject is
PHYSICS.

Username is root
Password is system
The table exists in a MYSQL database named Admin.

Statement 1 – to import the proper module
Statement 2 – to create the cursor object.
Statement 3- to Close the connection
Page 7 of 9
import ______________ as mydb #Statement 1
mycon = mydb.connect
(host = “localhost”,
user = “root”,
passwd = “system”,
database = “Admin”)
cursor = _________________ #Statement 2
sql = “SELECT * FROM GRADUATE WHERE SUBJECT = ‘PHYSICS’”
cursor. execute(sql)
mycon.commit ( )
___________________ #Statement 3
33 Sumit is a programmer who is working on a project that requires student data of a school to be 5
stored in a CSV file. Student data consists of roll no, name, class and section. He has written a
program to obtain the student data from user and write it to a CSV file. After getting errors in
the program he left five statements blank in the program as shown below. Help him to find the
answer of the following questions to find the correct code for missing statements.
#Incomplete Code
import_____ #Statement 1
fh = open(_____, _____, newline=‘ ’) #Statement 2
stuwriter = csv._____ #Statement 3
data = []
header = [‘ROLL_NO’, ‘NAME’, ‘CLASS’, ‘SECTION’]
data.append(header)
for i in range(5):
roll_no = int(input(“Enter Roll Number : ”))
name = input(“Enter Name : ”)
Class = input(“Class : ”)
section = input(“Enter Section : ”)
rec = [_____] #Statement 4
data.append(rec)
stuwriter. _____ (data) #Statement 5
fh.close()
(i) Identify the suitable code for blank space in line marked as Statement 1.
(ii) Identify the missing code for blank space in line marked as Statement 2.
(iii) Choose the function name (with argument) that should be used in the blank space of line
marked as Statement 3.
(iv) Identify the suitable code for blank space in line marked as Statement 4.
(v) Choose the function name that should be used in the blank space of line marked as
Statement 5 to create the desired CSV file?
OR
What are the advantages of binary file over text file? Write a Python program in Python to
search the details of the employees (name, designation and 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.
SECTION - E
34 Based on given table “DITERGENTS” answer following questions.
PID PName Price Category Manufacturer
Page 8 of 9
1 Nirma 40 Detergent Powder Nirma Group
2 Surf 80 Detergent Powder HL
3 Vim Bar 20 Disc washing Bar HL
4 Neem Face Wash 50 Face Wash Himalaya
a) Write SQL statement to display details of all the products not manufactured by HL. 1
b) Write SQL statement to display name of the detergent powder manufactured by HL. 1
c) Write SQL statement to display the name of the Product whose price is more than 0.5 2
hundred.
OR
c) Write SQL statement to display name of all such Product which start with letter ‘N’
35 Arun is a class XII student of computer science. The CCA in-charge of his school wants to 1+1+2
display the words form a text files which are less than 4 characters. With the help of his
computer teacher Arun has developed a method/function FindWords() for him in python
which read lines from a text file Thoughts. TXT, and display those words, which are lesser
than 4 characters. His teachers kept few blanks in between the code and asked him to fill the
blanks so that the code will run to find desired result. Do the needful with the following
python code.
def FindWords():
c=0
file=open(‘NewsLetter.TXT’, ‘_____’) #Statement-1
line = file._____ #Statement-2
word = _____ #Statement-3
for c in word:
if _____: #Statement-4
print(c)
_________ #Statement-5
FindWords()
(i) Write mode of opening the file in statement-1?

(ii) Fill in the blank in statement-2 to read the data from the file.
(iii) Fill in the blank in statement-3 to read data word by word
(iv) Fill in the blank in statement-4, which display the word having lesser than 4 characters
OR (Only for iii and iv above)

(v) Fill in the blank in Statement-5 to close the file.
(vi) Which method of text file will read only one line of the file?
Page 9 of 9

Class 12 Cs All Region Papers

Uploaded by

Copyright:

Available Formats

Class 12 Cs All Region Papers

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Class 12 Cs All Region Papers

Uploaded by

Copyright:

Available Formats

SAMPLE QUESTION PAPER (THEORY)

CLASS: XII SESSION: 2024-25

Time allowed: 3 Hours Maximum Marks: 70

Q No. Section-A (21 x 1 = 21 Marks) Marks

1. State True or False:

2. Identify the output of the following code snippet:

3. Which of the following expressions evaluates to False?

4. What is the output of the expression?

6. What will be the output of the following code?

7. If my_dict is a dictionary as defined below, then which of the following

8. What does the list.remove(x) method do in Python?

10. Write the missing statement to complete the following code:

11. State whether the following statement is True or False:

14. What will be the output of the query?

17. Which protocol is used to transfer files over the Internet?

20. Assertion (A): Positional arguments in Python functions must be passed in

Q No Section-B ( 7 x 2=14 Marks) Marks

22. How is a mutable object different from an immutable object in Python?

23. Give two examples of each of the following:

24. If L1=[1,2,3,2,1,2,4,2, . . . ], and L2=[10,20,30, . . .], then

(A) W# (B) W#i#

(C) W#s# (D) W#i#s#

result = swap_first_last((1, 2, 3, 4))

28. A) List one advantage and one disadvantage of star topology.

Q No. Section-C ( 3 x 3 = 9 Marks) Marks

Then the stack `EvenNumbers` should store:

31. Predict the output of the following code:

Predict the output of the following code:

Q No. Section-D ( 4 x 4 = 16 Marks) Marks

32. Consider the table ORDERS as given below

O_Id C_Name Product Quantity Price

(I) To display the total Quantity for each Product, excluding

35. A table, named STATIONERY, in ITEMDB database, has the following

Assume the following for Python-Database connectivity:

Q.No. SECTION E (2 X 5 = 10 Marks) Marks

36. Surya is a manager working in a recruitment agency. He needs to manage

You, as a programmer of the company, have been assigned to do this job

(I) Write a function to input the data of a candidate and append it in a

37. Event Horizon Enterprises is an event planning organization. It is planning

Block to Block distances (in Mtrs.)

Time allowed: 3 Hours Maximum Marks: 70

Q No. SECTION B (7 X 2 =14) Marks

(II) Relational operators: >, >= (2)

(½ x 4 = 2 Marks for each correct operator)

result = swap_first_last((1, 2, 3, 4))

(½ mark each for correcting 4 mistakes)

Disadvantage: Failure of switch/hub results in failure of the network.

SMTP is used for sending e-mails from client to server.

Q No. SECTION C (3 X 3 = 9) Marks

(1 mark for each correct line of output)

Q No. SECTION D (4 X 4 = 16) Marks

(4 x 1 mark for each correct query)

O_Id | C_Name | Product | Quantity | Price

(III) O_Id | C_Name | Product | Quantity | Price

(4 x 1 mark for each correct output)

(B) Select * from FACULTY, COURSES;

(4x1 mark for each correct query)

Q No. SECTION E (2 X 5 = 10) Marks

with open('candidates.bin', 'wb') as file:

print("Candidates updated to Senior Manager where applicable.")