XIIComp - Sc. 15 Sample Papers

कें द्रीय विद्यालय संगठन
(जम्मू संभाग )
KENDRIYA VIDYALAYA SANGATHAN

(JAMMU REGION)
SAMPLE PAPER
FOR CLASS XII
COMPUTER SCIENCE (083)
क्षेत्रीय कायाालय, जम्मू, नज़दीक राजकीय विककत्सालय, गााँधी नगर

जम्मू-180004
Regional Office, Jammu, Near Govt. Hospital,
Gandhi Nagar, Jammu-180004
KENDRIYA VIDYALAYA SANGHATHAN, JAMMU REGION
SAMPLE PAPER SET 1
CLASS-XII SUBJECT: COMPUTER SCIENCE
TIME: 3 HOURS M.M.: 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.
8. All programming questions are to be answered using Python Language only.
Section A
1 Write full form of CSV. 1
2 Which is valid keyword? 1
a. Int b. WHILE c.While d.if
3 Which of the following is not a valid identifier name in Python? 1
a) 5Total b) _Radius c) pie d)While
4 Consider the following expression: 1
51+4-3**3//19-3
Which of the following will be the correct output if the expression is evaluated?
a. 50
b. 51
c. 52
d. 53
5 Select the correct output of the code: 1
Str=“Computer”
Str=Str[-4:]
print(Str*2)
a. uter
b. uterretu
c. uteruter
d. None of these
6 Which module is imported for working with CSV files in Python? 1
a. csv
b. python-csv connector
c. CSV
d. python.csvconnector
7 Fill in the blank: 1
_____ command is used to update records in the MySQL table.
(a) ALTER (b) UPDATE (c) MODIFY (d) SELECT
8 Which command used to fetch rows from the table in database? 1
(a) BRING (b) FETCH (c) GET (d) SELECT
9 Which of the following statement(s) would give an error after executing the following 1
code?
print(9/2) # Statement-1
print(9//2) # Statement-2
print(9%%2) # Statement-3
print(9%2) # Statement-4
(a) Statement-1 (b) Statement-2 (c) Statement-3 (d) Statement-4

10 Fill in the blanks: 1
_______ is the table constraint used to stop null values to be entered in the field.
(i) Unique
(ii) Not NULL
(iii) Not Empty
(iv) None
11 The correct syntax of read() function from text files is: 1
a. file_object.read()
b. file_object(read)
c. read(file_object)
d. file_object().read

In SQL, we use _____ command to display the list of databases in the server.
(a) SELECT DATABASES;
(b) SELECT DATABASE;
(c) SHOW DATABASES;
(d) DESC;
________ protocol is used to send mail.
(a) SMTP (b) FTP (c) POP (d) HTTPS
14 What will the following expression be evaluated to in Python? 1
10*1*2**4-4//4
15 Which function is used to display the maximum of records from table in a database? 1
(a) MAX (b) MAXIMUM (c) LARGEST (d) GREAT
16 To establish a connection with MySQL from Python which of the following functions is 1
used?
(a) connection() (b) connect() (c) open() (d) cursor()
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct
choice as:
(a) Both A and R are true and R is the correct explanation for A
(b) Both A and R are true and R is not the correct explanation for A
(c) A is True but R is False
(d) A is false but R is True
17 Assertion (A): Global variable is declared outside the all the functions. 1
Reasoning (R): It is accessible through out all the functions.
18 Assertion (A): Binary files store all data in text format. 1
Reasoning (R): Binary files data remain in its original type.
Section B
19 Rajat has written the following Python code. There are some errors in it. Rewrite the 2
correct code and underline the corrections made.
DEF execmain():
x = input("Enter a number:")
if (abs(x)=x):
print ("You entered a positive number")
else:
x=*-1
print "Number made positive:"x
execmain()
20 Write two advantages of star topology and bus topology each. 2
OR
Briefly explain HTML and HTTP.

21 a. Find output generated by the following code: 1+1
mystr = “Hello I am a Human.”
print(mystr[::-3])
b. Write the output of the code given below:

p=10
q=20
p*=q//3
p=q**2
q+=p
print(p,q)
22 Differentiate between DDL and DML with one Example each. 2
23 a. Give the full form of the following: 2
i. URL
ii. FTP
b. What is the use of HTTP?

24 Predict the output of the following code: 2
def CALLME(n1=1,n2=2):
n1=n1*n2
n2+=2
print(n1,n2)
CALLME()
CALLME(3)
OR
mylist = [2,14,54,22,17]
tup = tuple(mylist)
for i in tup:
print(i%3, end=",")
25 Answer the following : 2

i) Name the package imported for connecting Python with MySQL database. mysqlclient
ii) What is the purpose of cursor object?
OR
What is primary key in MySQL database? Give an example.
Section-C
26 a. Consider the following tables Trainer and Course: 1+2
What will be the output of the following statement?

SELECT * FROM TRAINER NATURAL JOIN COURSE;
b. Write the Outputs of the MySQL queries (i) to (iv) based on the given above tables:
i. SELECT DISTINCT(CITY) FROM TRAINER WHERE SALARY>80000;
ii. SELECT TID, COUNT(*), MAX(FEES) FROM COURSE GROUP BY TID
HAVING COUNT(*)>1;
iii. SELECT T.TNAME, C.CNAME FROM TRAINER T, COURSE C WHERE
T.TID=C.TID AND T.FEES<10000;
iv. SELECT COUNT(CITY),CITY FROM TRAINER GROUP BY CITY;
27 Write a method/function COUNTLINES_ET() in python to read lines from a text file 3
REPORT.TXT, and COUNT those lines which are starting either with ‘E’ or starting
with ‘T’ and display the Total count separately.
For example:
If REPORT.TXT consists of
“ENTRY LEVEL OF PROGRAMMING CAN BE LEARNED FROM PYTHON. ALSO, IT
IS VERY FLEXIBLE LANGUGAE. THIS WILL BE USEFUL FOR VARIETY OF
USERS.”
Then, Output will be:
No. of Lines with E: 1
No. of Lines with T: 1
OR
Write a method/ function SHOW_TODO() in python to read contents from a text file
ABC.TXT and display those lines which have occurrence of the word ‘‘TO’’ or
‘‘DO’’.
For example :
If the content of the file is
“THIS IS IMPORTANT TO NOTE THAT
SUCCESS IS THE RESULT OF HARD WORK.
WE ALL ARE EXPECTED TO DO HARD WORK.
AFTER ALL EXPERIENCE COMES FROM HARDWORK.”
The method/function should display:

THIS IS IMPORTANT TO NOTE THAT
WE ALL ARE EXPECTED TO DO HARD WORK.
28 a. Write the outputs of the SQL queries (i) to (iv) based on the relations Teacher and 3
Posting given below:
i. SELECT Department, count(*) FROM Teacher GROUP BY Department;

ii. SELECT Max(Date_of_Join),Min(Date_of_Join) FROM Teacher;
iii. SELECT Teacher.name,Teacher.Department, Posting.Place
FROM Teacher, Posting
WHERE Teacher.Department = Posting.Department AND Posting.Place=”Delhi”;
iv. SELECT Gender, COUNT(Gender) FROM Teacher GROUP BY Gender;
b. Write the command to view the schema of the table Teacher.

29 Python funtion oddeve(L) to print positive numbers in a list L. 3
Example:
Input: [4, -1, 5, 9, -6, 2, -9, 8]
Output: [4, 5, 9, 2, 8]
30 Write a function AddCustomer(Customer) in Python to add a new Customer information 3
into the stack (list) CStack and display the information.
OR
Write a function DeleteCustomer() to delete a Customer information from a list of

CStack. The function delete the name of customer from the stack.
Example: If the stack contains [“Abhinav”,”Vimank”],
the output should be:
Vimank
Abhinav
Section-D
31 Prithvi Training Institute is planning to set up its centre in Jaipur with four specialized 5
blocks for Medicine, Management, Law courses along with an Admission block in
separate buildings. The physical distances between these blocks and the number of
computers to be installed in these blocks are given below. You as a network expert have
to answer the queries raised by their board of directors as given in (i) to (v).
i. Suggest the most suitable location to install the main server of this institution
to get efficient connectivity.
ii. Suggest by drawing the best cable layout for effective network connectivity
of the blocks having server with all the other blocks.
iii. Suggest the devices to be installed in each of these buildings for connecting
computers installed within the building out of the following:
Modem, Switch, Gateway, Router
iv. Suggest the most suitable wired medium for efficiently connecting each
computer installed in every building out of the following network cables:
Coaxial Cable, Ethernet Cable, Single Pair, Telephone Cable
v. Suggest the type of network implemented here.
32 (a) Write the output of following python code: 2+3
def result(s):
n = len(s)
m=''
for i in range(0, n):
if (s[i] >= 'a' and s[i] <= 'm'):
m = m + s[i].upper()
elif (s[i] >= 'n' and s[i] <= 'z'):
m = m + s[i-1]
elif (s[i].isupper()):
m = m + s[i].lower()
else:
m = m + '#'
print(m)
result('Cricket')
(b) Avni is trying to connect Python with MySQL for her project. Help her to write the
python statement on the following:
i. Name the library, which should be imported to connect MySQL with Python.
ii. Name the function, used to run SQL query in Python.
iii. Write Python statement of connect function having the arguments values as :
Host name :192.168.11.111
User : root
Password: Admin
Database : MYPROJECT
OR
(a) Find the output
Msg1="WeLcOME"
Msg2="GUeSTs"
Msg3=""
for I in range(0,len(Msg2)+1):
if Msg1[I]>="A" and Msg1[I]<="M":
Msg3=Msg3+Msg1[I]
elif Msg1[I]>="N" and Msg1[I]<="Z":
Msg3=Msg3+Msg2[I]
else:
Msg3=Msg3+"*"
print(Msg3)
b) Your friend Jagdish is writing a code to fetch data from a database Shop and table
name Products using Python. He has written incomplete code. You have to help him
write complete code:
import __________ as m # Statement-1
object1 = m.connect(
host="localhost",
user="root",
password="root",
database="Shop"
)
object2 = object1._____ # Statement-2
query = '''SELECT * FROM Products WHERE NAME LIKE "A%";'''
object2._____(query) # Statement-3
object1.close()
33 What is the advantage of using pickle module? 2+3
Write a program to write into a CSV file “one.csv” Rollno, Name and Marks separated
by comma. It should have header row and then take input from the user for all following
rows. The format of the file should be as shown if user enters 2 records.
Roll.No,Name,Marks
20,Ronit,67
56,Nihir,69
OR
What is difference between tell() and seek() methods?
Write a program to read all content of “student.csv” and display records of only those
students who scored more than 80 marks. Records stored in students is in format :
[Rollno, Name, Marks]
34 ABC Gym has created a table TRAINER. Observe the table given below and answer the 1+1
following questions accordingly. +2
a. What is Degree and Cardinality of the above table?

b. Which field should be made as the primary key? Justify your answer.
c. Write the query to:
i. Insert a record: (107,Bhoomi,Delhi,2001-12-15,90000)
ii. Increase the salary by 1% for the trainers whose salary is more than 80000
OR
i. Delete the record of Richa
ii. Add a new column remarks of VARCHAR type with 50 characters.
Section E
35 Priti of class 12 is writing a program to create a CSV file “emp.csv”. She has written the 1+1
following code to read the content of file emp.csv and display the employee record +2
whose name begins from “S‟ also show no. of employee with first letter “S‟ out of total
record. As a programmer, help her to successfully execute the given task.
Consider the following CSV file (emp.csv):
1,Peter,3500
2,Scott,4000
3,Harry,5000
4,Michael,2500
5,Sam,4200
import _____ # Line-1

def snames():
with open(______) as csvfile: # Line-2
myreader = csv.___ (csvfile, delimiter=",") # Line-3
count_rec=0
count_s=0
for row in myreader:
if row[1][0].lower() == "s":
print(row[0],",",row[1],",",row[2])
count_s += 1
count_rec += 1
print(count_rec, count_s)
i. What should be written in Line-1?
ii. In which mode should Priti open the file to print the data?
iii. What should be written in Line-2 and Line-3?
KENDRIYA VIDYALAYA SANGHATHAN, JAMMU REGION
SAMPLE PAPER SET 2
CLASS-XII SUBJECT: COMPUTER SCIENCE
TIME: 3 HOURS M.M.: 70
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against
part c only.
SECTION A
1 State True or False 1
“The characters of string will have two-way indexing.”
2 Which of the following is the valid variable name? 1
(a) f%2 (b) 20ans (c) ans (d) $ans
3 What will be the output of the following code? 1
D1={1: “One”,2: “Two”, 3: “C”}
D2={4: “Four”,5: “Five”}
D1.update(D2)
print (D1)
a) {4:’Four’,5: ‘Five’}
b) Method update() doesn’t exist for dictionary
c) {1: “One”,2: “Two”, 3: “C”}
d) {1: “One”,2: “Two”, 3: “C”,4: ‘Four’,5: ‘Five’}
4 Evaluate the expression given below if A=16 and B=15. 1
A % B // A
a) 1 b) 0.0 c) 0 d) 1.0
5 Select the correct output of the following code : 1
s=“I#N#F#O#R#M#A#T#I#C#S”
L=list(s.split(‘#’))
print(L)
a) [I#N#F#O#R#M#A#T#I#C#S]
b) [‘I’, ‘N’, ‘F’, ‘O’, ‘R’, ‘M’, ‘A’, ‘T’, ‘I’, ‘C’, ‘S’]
c) [‘I N F O R M A T I C S’]
d) [‘INFORMATICS’]
6 Which of the following are the modes of both writing and reading in binary format in file? 1
a) wb+
b) w
c) w+
d) wb
7 Fill in the blank 1
_____________ command is used to modify the attribute datatype or size in a table structure.
a) update b) alter c) insert d) None of these
8 Which of the following clause is used to sort records in a table? 1
a) GROUP
b) GROUP BY
c) ORDER BY
d) ORDER
9 Which of the following statement(s) would give an error after executing the following code? 1
str= “Python Programming” #statement 1
x= ‘2’ #statement 2
print(str*2) #statement 3
print(str*x) #statement 4
a) statement 1
b) statement 2
c) statement 3
d) statement 4
_________ constraint is used to restrict entries in other table’s non key attribute, whose values
are not existing in the primary key of reference table..
a) Primary Key
b) Foreign Key
c) Candidate Key
d) Alternate Key
11 A text file student.txt is stored in the storage device. Identify the correct option out of the 1
following options to open the file in read mode.
i. myfile = open('student.txt','rb')
ii. myfile = open('student.txt','w')
iii. myfile = open('student.txt','r')
iv. myfile = open('student.txt')
a) only i
b) both i and iv
c) both iii and iv
d) both i and iii
_______________ define rules regarding the values allowed in columns and is the standard
mechanism for enforcing database integrity.
a) Attribute
b) Constraint
c) Index
d) Commit
13 Fill in the Blank 1
________________ is the networking device that connects computers in a network by using
packet switching to receive, and forward data to the destination.
a) Switch b)Hub c) Repeater d) Router
14 What will the following expression be evaluated to in Python? 1
print(6*3 / 4**2//5-8)
(a) -10 (b) 8.0 (c) 10.0 (d) -8.0
15 The operation whose result contains all pairs of tuples from the two relations, regardless of 1
whether their attribute values match.
a) Join
b) Intersection
c) Union
d) Cartesian Product
16 To create a connection between MYSQL database and Python application connect() function is 1
used. Which of the following are mandatory arguments required to connect any database from
Python.
a) Username, Password, Hostname, Database Name, Port
b) Username, Password, Hostname
c) Username, Password, Hostname, Database Name
d) Username, Password, Hostname, Port
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as
17 Assertion (A):- All the keyword arguments passed must match one of the arguments accepted by 1
the function
C
Reasoning (R):- You cannot change the order of appearance of the keyword.
18 Assertion (A): CSV file is a human readable text file where each line has a number of fields, 1
separated by commas or some other delimiter. B?
Reason (R): writerow() function can be used for writing into writer object.
SECTION B
19 Raman has written a code to find its sum of digits of a given number passed as parameter to 2
function sumdigits(n). His code is having errors. Rewrite the correct code and underline the
corrections made.
def sumdigits(n):
d=0
for x in str(n): RANGE N
d=d+x
return d
n=int(input(‘Enter any number”))
s=sumdigits(n)
print(“Sum of digits”,s)
20 Write two points of difference between Switch and Router. 2
OR
Write two points of difference between Web Server and Web Browser.
21 (a) Given is a Python List declaration: 1
list= [10, 20, 30, 40, 50, 60, 70, 80]
print(list[ : : 2])
(b) Write the output of the code given below:
squares = {1: 1, 2: 4, 3: 9, 4: 16, 5: 25} 1
16
print(squares.pop(4))
22 Explain the use of ‘Primary Key’ in a Relational Database Management System. Give example to 2
support your answer.
23 (a) Write the full forms of the following: 2
(i) POP3 (ii) TCP/IP post office protocol
(b) What is the use of VoIP?
24 Predict the output of following code: 2
def fun(x):
x[0] = 5
return x
g = [10,11,12] [5,11,12] ,[5,11,12]
print(fun(g),g)
OR
test_list = [5, 6, 7]
test_tup = (9, 10)
(9,10,5,6,7)
res = tuple(list(test_tup) + test_list)
print(str(res))
25 Differentiate between char and varchar in SQL with appropriate examples. 2
OR
What are different types of SQL Aggregate Functions? Give two examples.
SECTION C
26 (a) Consider the following tables – Uniform and Cost: 1+2
Uniform
UCODE UNAME UCOLOR
1 Shirt White
2 Pant Grey
3 Tie Blue
4 Shocks Blue
Cost
UCODE SIZE PRICE
1 L 580
1 M 600
2 L 800
2 M 810

SELECT * FROM UNIFORM U JOIN COST C ON U.Ucode=C.Ucode;
(b) Write the output of the queries (i) to (iv) based on the table “Product”, showing details of
products being sold in a grocery shop.
Pcode Pname Uprice Manufacturer
P01 Washing Powder 120 Surf
P02 Toothpaste 54 Colgate
P03 Soap 25 Lux
P04 Toothpaste 65 Pepsodent
P05 Soap 38 Dove
P06 Shampoo 245 Dove
i) SELECT PName, Average (UPrice) FROM Product GROUP BY Pname;

ii) SELECT DISTINCT Manufacturer FROM Product;
iii) SELECT COUNT (DISTINCT PName) FROM Product;
iv) SELECT PName, MAX(UPrice), MIN(UPrice) FROM Product GROUP BY PName;
27 Write a function countwords() in Python that counts the number of words containing digits in it 3
present in a text file “myfile.txt”.
Example: If the “myfile.txt” contents are as follows:
This is my 1st class on Computer Science. There are 100 years in a Century. Student1 is present in
the front of the line.
The output of the function should be: 3
OR
Write a function countwords() in Python, which should count the occurrences of word ‘me’ and
‘my’ in the text file ‘myfile.txt’.
“I will have nothing more to do with you and you are no longer my friend, no longer my 'faithful
slave,' as you call yourself!
Keep the third piece of wisdom for your own use, and let me have the gold.”
The output of the function should be: No of words ‘my’ is 2
No. of Words ‘me’ is 1
28 (a) Write the outputs of the SQL queries (i) to (iv) based on the relations Company and Customer 3
given below:
COMPANY
CID NAME CITY PRODUCTNAME
111 SONY DELHI TV
222 NOKIA MUMBAI MOBILE
333 ONIDA DELHI TV
444 SONY MUMBAI MOBILE
555 BLACKBERRY DELHI LAPTOP
CUSTOMER
CUSTID NAME PRICE QTY CID
101 ROHAN 70000 20 222
102 DEEPAK 50000 10 555
103 MOHAN 30000 5 111
104 SAHIL 35000 3 333
105 NEHA 25000 7 444
106 SOHAN 20000 5 333
107 ARUN 50000 15 555
i) SELECT COUNT(*) , CITY FROM COMPANY GROUP BY CITY;
ii) SELECT MIN(PRICE), MAX(PRICE) FROM CUSTOMER WHERE QTY>10;
iii) SELECT PRODUCTNAME, CITY, PRICE FROM COMPANY, CUSTOMER WHERE
COMPANY. CID=CUSTOMER.CID AND PRODUCTNAME= “MOBILE”;
iv) SELECT CUSTOMER.NAME, CITY, PRICE FROM COMPANY, CUSTOMER WHERE
COMPANY. CID=CUSTOMER.CID AND PRICE>25000;
(b) Write command to show all the tables in a database.
29 Write a function listchange(Arr,n)in Python, which accepts a list Arr of numbers and n is an 3
numeric value depicting length of the list. Modify the list so that all even numbers doubled and
odd number multiply by 3
Sample Input Data of the list: Arr= [ 10,20,30,40,12,11], n=6
Output: Arr = [20,40,60,80,24,33]
30 A list contains following record of a student: [Rno, Name, Dob, Class] 3
Write the following user defined functions to perform given operations
on the stack named ‘status’:
(i) Push_element() - To Push an record of student 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.
OR
Write a function in Python, Push(book) where, book is a dictionary containing the details of a
book in form of {bookno : price}.
The function should push the book in the stack which have price greater than 300. Also display
the count of elements pushed into the stack.
For example:
If the dictionary contains the following data:
Dbook={"Python":350,"Hindi":200,"English":270,"Physics":600, “Chemistry”:550}
The stack should contain
Chemistry
Physics
Python
The output should be:
The count of elements in the stack is 3
SECTION D
31 Eduminds University of India is starting its first campus in a small town Parampur of central India 5
with its centre admission office in Delhi. The university has three major buildings comprising of
Admin Building, Academic Building and Research Building in the 5 km area campus.
As a network expert, you need to suggest the network plan as per (a) to (e) to the authorities
keeping in mind the distance and other given parameters.
Expected wire distances between various locations:

Research Building to Admin Building 90m
Research Lab to Academic Building 80m
Academic Building to Admin Building 15m
Delhi Admission Office to Parampur 1450km
Campus
Expected number of computers to installed at various locations in the university are as follows:
Research Building 20
Academic Building 150
Admin Building 35
Delhi Admission Office 5
a. Suggest the authorities, the cable layout amongst various blocks inside university campus
for connecting the buildings
b. Suggest the most suitable place (i.e. block) to house the server of this university with a
suitable reason
c. Suggest an efficient device from the following to be installed in each of the blocks to
connect all the computers
d. Suggest the placement of a Repeater (if any) in the network with justification.
e. Suggest the most suitable (very high speed) service to provide data connectivity between
Admission Building located in Delhi and the campus located in Parampur.
32 a) Write output of the following code: 2+3
value = 50
def display(N):
global value
value = 25
if N%7==0:
value = value + N
else:
value = value - N
print(value, end="#")
display(20)
print(value)
b) The code given below inserts the following record in the table Employee:
Empno – integer
EName – string
Desig – integer
Salary – integer
Note the following to establish connectivity between Python and MYSQL:
 Username is root
 Password is Password
 The table exists in a MYSQL database named Bank.
 The details (Empno, Ename, Design 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 query string.
Statement 3- to execute insert query for employee table
import mysql.connector
mydb=mysql.connector.connect(host='localhost',user='root',passwd='Password',database='bank')
mycursor=_________________ # statement1
eno=int(input('enter Employee no'))
nm=input('enter Employee name')
d=input('enter Designation)
s=int(input(‘Enter salary’))
rtup=(eno,n,d,s)
rq=’’’insert into Employee (Empno, Ename, Design,Salary)
values (___________________)’’’ #statement2
mycursor.________________ #statement 3
mydb.commit()
print("Data Added successfully"
OR
a) Predict the output of the following code:
def Display(str):
m=""
for i in range(0,len(str)):
if(str[i].isupper()):
m=m+str[i].lower()
elif str[i].islower():
m=m+str[i].upper()
else:
if i%2==0:
m=m+str[i-1]
else:
m=m+"#"
print(m)
Display('Fun@Python3.0')
b) The code given below reads the following record from Table named Employee and display
those record salary >= 30000 and <= 90000:
Empno – integer
EName – string
Desig – integer
Salary – integer
 Password is Password
 The table exists in a MYSQL database named Bank.
Statement 2 – to query string.
Statement 3- to execute the query that extracts records of those Employees whose salary
>=30000 and <=90000.
import mysql.connector
mydb=mysql.connector.connect(host='localhost',user='root',passwd='Password',database='bank')
mycursor=_________________ # statement1
mycursor.________________ #statement 2
data= __________________ # statement 3
for x in data:
print(x)
33 What is the use of tell() function? 5
Write a program in Python that defines and calls the following user defined functions:
i. Add(): to add the record of a student to a csv file “record.csv”. Each record should be
with field elements [admno,sname,class]
ii. Count(): to count the number of students studying in class 12
OR
Give a difference between dump and load function. Write a program in Python that defines and
calls the following user defined functions:
i. Add(): to add the record of an animal to a csv file “animal.csv”. Each record should be
with field elements [animalname, animaltype, animalfood]
ii. Search(): to print all the animal names who eat grass as their food.
SECTION E
34 Arjun creates a table Employee with a set of records to maintain their Inventory. After 1+1+2
creation of table, he entered data of 7 employees in the table.
EMPNO NAME DEPT SALARY
1021 Radhika sales 5000
1022 Anu dev 12000
1023 Rajesh support 8000
1024 Arunag dev 20000
1026 Manisha sales 7000
1027 Disha support 4000
1035 Sanjay dev 34000
(a) Identify the attribute best suitable to be declared as a primary key
(b) If two columns and two rows are added what will be the degree and cardinality of the
table Employee
(c) i) Insert the following data into the attributes empID, empName and empDept
respectively
in the given table SUDENT empID = 1042, empName = “Abhinav” and empDept =
“support”
ii) Write a command display structure of table employee.
OR
(c) i) Write a command to add new column bonus to Employee Table
ii) Write SQL statement to update the Bonus of all employees by 20% of salary.
35 Aditya is a Python programmer. He has written a code and created a binary file student.dat with
rollno, name, class and marks. The file contains 10 records. He now has to search record based on
rollno in the file student.dat
As a Python expert, help him to complete the following code based on

the requirement given above:
import _______ #Statement 1
def searchrec():
r=int(input('Enter roll no of student to be searched'))
f=open(______________________) # staement2
found=False
try:
while True:
data=_______________ # statement 3
for rec in data:
if r==_______: # staement4
found=True
print('Name: ',rec[1])
print('Class : ',rec[2])
print('marks :',rec[3])
break
except Exception:
f.close()
if found==True:
print('Search successful')
else:
print('Record not exist')
(i) Which module should be imported in the program? (Statement1) 1
(ii) Write the correct statement required to open a file student.dat in the required mode 1
(Statement 2)
(iii) Which statement should Aditya fill in Statement 3 for reading data from binary file s 2
tudent.dat. Also Write the correct comparison to check existence of record (Statement4).
KENDRIYA VIDYALAYA SANGATHAN, JAMMU REGION
SAMPLE PAPER SET 3
CLASS-XII SUBJECT- COMPUTER SCIENCE
Time: 3 hours MM: 70
3. Section A have 18 questions carrying 01 mark each.
7. Section E has 02 questions carrying 04 marks each.
SECTION – A
1. Which of the following is not a valid identifier name in Python? 1
a) First_Name
b) _Area
c) 2nd_num
d) While
2. Find the operator which cannot be used with a string in Python from the following:- 1
a) //
b) *
c) +
d) in
3. Identify the valid declaration of Record: Record=(1342, “Pooja” , 45000, “Sales”) 1
a) List
b) Tuple
c) String
d) Dictionary
4. Which of the following expressions is an example of type casting? 1
a) 4.0+float(6)
b) 5.3+6.3
c) 5.0+3
d) None of these
5. What will be the output of the following statements? 1
a = [0, 1, 2, 3]
del a[:]
print(a)
a) None
b) [ ]
c) [0, 1, 2, 3]
d) NameError
6. Which of the following command is used to open a file “c:\temp.txt” in read mode only? 1
a) infile = open(“c:\temp.txt”, “r”)
b) infile = open(“c:\\temp.txt”, “r”)
c) infile = open(file = “c:\temp.txt”, “r+”)
d) infile = open(file = “c:\\temp.txt”, “r+”)
7. Which command is used to add a new record in existing table in SQL 1
a) insert into
b) alter table
c) add into
d) create table
8. Which SQL command is used to delete an existing column from a table? 1
a) update
b) delete
c) alter
d) order
9. What will be the output after the following statements? 1
x = 27
y=9
while x < 30 and y < 15:
x=x+1
y=y+1
print(x,y)
a) 26 11
b) 25 11
c) 30 12
d) 26 10
10. Which of the following function is used to FIND the largest value from the given data in 1
MYSQL?
a) MAX()
b) MAXIMUM ()
c) LARGEST ()
d) BIG ()
11. To print 4th line from text file, which of the following statement is true? 1
a) dt = f.readlines()
print(dt[3])
b) dt=f.read(4)
print(dt[3])
c) dt=f.readline(4)
print(dt[3])
d) All of these
12. What will be the order of the data being sorted after the execution of given query 1
SELECT * FROM STUDENT ORDER BY ROLL_NO;
a) Custom Sort
b) Descending
c) Ascending
d) None of the above
13. In specific, if the systems use separate protocols, which one of the following devices is 1
used to link two systems?
a) Repeater
b) Gateway
c) Bridge
d) Hub
14. Consider the expression given below. The value of X is: 1
X = 2+9*((3*12)-8)/10
a) 30.0
b) 27.2
c) 28.4
d) 30.8
15. Consider the table with structure as: Student (ID, name, dept name, tot_cred) 1
In the above table, which attribute will form the primary key?
a) Name
b) Dept
c) total_credits (
d) ID
16. To retrieve all the rows from the result set, which method is used? 1
a) fetchall
b) fetchone
c) fetchmany
d) none of the above
a) Both A and R are true and R is the correct explanation for A
b) Both A and R are true and R is not the correct explanation for A
c) A is True but R is False
d) A is false but R is True
17. Assertion (A): The math.pow(2,4)gives the output: 16.0 1
Reason (R): The math.pow() method receives two float arguments, raise the first to the
second and return the result.
18. Assertion (A): CSV stands for comma separated value. 1
Reason (R): CSV files are a common file format for transferring and storing data.
SECTION – B
19. Aman has write the code to find factorial of an integer number as follow. But he got 2
some error while running this program. Kindly help him to correct the errors.
num=int(input("Enter any integer number"))

fact=1
for x of range(num,1,-1)
if num=1 or num=0
print ("Fact=1")
break
else
fact=fact*x
print(fact)
20. ABC Company wants to link its computers in Head office in New Delhi to its office in 2
Sydney. Name the type of Network that will be formed. Which communication media
should be used to form this Network?
OR
Differentiate between communication using Optical Fiber and Ethernet Cable in context
of wired medium of communication technologies.
21. a) Given a list: 1
List1=[10,[20,30,40],50,60,70,80,90]
What will be the output of
print(List1[1:3:2])? 1
b) Write the output of following code:

Tup1=(10,15,20,25,30)
print(Tup1[-1:0:-2])
22 What do you mean by Primary Key in a relation/table? Give a suitable example of 2
primary key.
23 a) Which service/protocol will be most helpful to conduct live interactions from one 1
location to different locations?
b) Write full form of the following: 1
i) FTP
ii) HTTP
24 Write the output of the following Python program code: 2
TXT = ["10","20","30","5"]
CNT = 3
TOTAL = 0
for C in [7,5,4,6]:
T = TXT[CNT]
TOTAL = float (T) + C
print (TOTAL)
CNT-=1
OR
def check(x,y):
if x != Y:
return x + 5
else:
return y +10
print(check(10,5))
25 What do you understand by ORDER BY in SQL? Explain the use of Where clause with 2
SELECT.
OR
What do you mean by degree and cardinality of table?
Section-C
26 a) Table: EMPLOYEES 2+1
Empid Firstname Lastname Address City
010 Ravi Kumar Raj nagar GZB
105 Harry Waltor Gandhi nagar GZB
152 Sam Tones 33 Elm St. Paris
215 Sarah Ackerman 440 U.S. 110 Upton
244 Manila Sengupta 24 Friends street New Delhi
300 Robert Samuel 9 Fifth Cross Washington
335 Ritu Tondon Shastri Nagar GZB
400 Rachel Lee 121 Harrison St. New York
441 Peter Thompson 11 Red Road Paris
Table: EMPSALARY
Empid Salary Benefits Designation
010 75000 15000 Manager
105 65000 15000 Manager
152 80000 25000 Director
215 75000 12500 Manager
400 32000 7500 Salesman
441 28000 7500 salesman
501 18000 6500 Clerk
Give the Output of following SQL commands:

(i) Select Employee.firstname, empsalary,salary from employees, empsalary
where designation = ‘Salesman’ and Employees.empid=Empsalary.empid;
(ii) Select count(distinct designation) from empsalary;
(iii) Select designation, sum(salary) from empsalary group by designation having
count(*) >2;
(iv) Select sum(benefits) from empsalary where designation =’Clerk’;
b) Define Equi join with a suitable example
27 Write a function readMe() which read a file ‘data.txt’ and print the frequency of the 3
words ‘India’ in it.
OR
Write a function linecount() in python which read a file ‘data.txt’ and count number of
lines starts with character ‘P’.
28 Write SQL commands for (a) to (d) and write output for (e) to (f) on the basis of 3
TRANSPORT table:
Rtno Area_overed Capacity Noofstudents Distance Transporter Charges
1 Vasant kunj 100 120 10 Shivamtravels 100000
2 Hauz Khas 80 80 10 Anand travels 85000
3 Pitampura 60 55 30 Anand travels 60000
4 Rohini 100 90 35 Anand travels 100000
5 Yamuna Vihar 50 60 20 Bhalla Co. 55000
6 Krishna Nagar 70 80 30 Yadav Co. 80000

7 Vasundhara 100 110 20 Yadav Co. 100000
8 Paschim Vihar 40 40 20 Speed travels 55000
9 Saket 120 120 10 Speed travels 100000
10 Jank Puri 100 100 20 Kisan Tours 95000

a) To show all information of students where capacity is more than the no of
student in order of rtno.
b) To show area_covered for buses covering more than 20 km., but charges less
than 80000.
c) select sum(distance) from schoolbus where transporter= “ Yadav Co.”;
d) select min(noofstudents) from schoolbus;
29 Write definition of a method/function AddOddEven(VALUES) to display sum of odd and 3
even values separately from the list of VALUES.
For example : If the VALUES contain [15, 26, 37, 10, 22, 13]
The function should display
Even Sum: 58
Odd Sum: 65
30 Write PushOn(Book) and Pop(Book) methods/functions in Python to add a new Book and 3
delete a Book from a List of Book titles, considering them to act as push and pop
operations of the Stack data structure.
OR
Write a program to implement a stack for the students(studentno, name). Just
implement Pop and display.
SECTION-D
31 Ayurveda Training Educational Institute is setting up its centre in Hyderabad with four 5
specialised departments for Orthopedics, Neurology and Pediatrics along with an
administrative office in separate buildings. The physical distances between these
department buildings and the number of computers to be installed in these departments
and administrative office are given as follows. You, as a network expert, have to answer
the queries as raised by them in (i) to (v).
Administrative Office to Orthopedics Unit 55
Neurology Unit to Administrative Office 30
Orthopedics Unit to Neurology Unit 70
Pediatrics Unit to Neurology Unit 50
Pediatrics Unit to Administrative Office 40
Pediatrics Unit to Orthopedics Unit 110
Number of Computers installed at various locations are as follow:

Administrative Office 150
Orthopedics Unit 40
Pediatrics Unit 50
Neurology Unit 80
Administrative Orthopaedics
Office Unit
Pediatrics Neurology
Unit Unit
i. Suggest the most suitable location to install the main server of this institution to get
efficient connectivity.
ii. Suggest the best cable layout for effective network connectivity of the building
having server with all the other buildings.
iii. Suggest the devices to be installed in each of these buildings for connecting
computers installed within the building out of the following : Gateway, switch,
Modem
iv. Suggest the topology of the network and network cable for efficiently connecting
each computer installed in each of the buildings out of the following :
Topologies: Bus Topology, Star Topology
Network Cable: Single Pair Telephone Cable, Coaxial Cable, Ethernet Cable.
v. Suggest a system (hardware/software) to prevent unauthorized access to or from the
network.
32 a) What possible output(s) are expected to be displayed on screen at the time of 2+3
execution of the program from the following code? Also write the value assigned to
variable first and second.
from random import randint
LST=[5,10,15,20,25,30,35,40,45,50,60,70]
first = random.randint(3,8) – 1
second = random.randint(4,9) – 2
third = random.randint(6,11) – 3
print(LST[first],"#", LST[second],"#", LST[third],"#")
i) 20#25#25#
ii) 30#40#70#
iii) 15#60#70#
iv) 35#40#60#
b) The code given below inserts the following record in the table Student:
Empno – integer
EName – string
Designation – integer
Salary – integer
Bonus - Integer
 Password is tiger
 The table exists in a MYSQL database named Employee.
 The details (Empno, EName, Designation, Salary and Bonus) are to be accepted
from the user.
Statement 2 – to execute the command that inserts the record in the table
Employee.
Statement 3- to add the record permanently in the database
import mysql.connector as mysql
def sql_data():
con1=mysql.connect(host="localhost",user="root", password="tiger",
database="Employee")
mycursor=_________________ #Statement 1
eno=int(input("Enter Employee Number: "))
Ename=input("Enter Employee Name: ")
Designation=input("Enter Designation: "))
Salary=int(input("Enter Salary: "))
Bonus=int(input("Enter Bonus: "))
querry="insert into employee values({},'{}',{},{})".
format(eno,ename,designation,bonus)
______________________ #Statement 2
______________________ # Statement 3
print("Employee Data Added successfully")
OR
a) Predict the output:
def func(S):
k=len(S)
m=''
for i in range(0,k):
if S[i].isalpha( ):
m=m+S[i].upper( )
elif S[i].isdigit( ):
m=m+'0'
else:
m=m+'#'
print(m)
func("Python 3.9")
b) What are the basic steps to connect Python with MYSQL using table Members
present in the database ‘Society’?
33 Rohit, a student of class 12th, is learning CSV File Module in Python. During examination, 5
he has been assigned an incomplete python code (shown below) to create a CSV File
'Student.csv' (content shown below). Help him in completing the code which creates the
desired CSV File. CSV File
1,AKSHAY,XII,A
2,ABHISHEK,XII,A
3,ARVIND,XII,A
4,RAVI,XII,A
5,ASHISH,XII,A
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("Enter Class : ")
section = input("Enter Section : ")
rec = [_____] #Statement-4
data.append(rec)
stuwriter. _____ (data) #Statement-5
fh.close()
Answer the following questions
i. Write the suitable code for blank space in line marked as Statement-1
ii. Write the missing code for blank space in line marked as Statement-2?
iii. Write function name (with argument) that should be used in the blank space of line
marked as Statement-3
iv. Complete the statement-4 with suitable code.
v. Write the function name that should be used in the blank space of line marked as
Statement-5 to create the desired CSV File?
OR
Your teacher has given you a method/function FilterWords() in python which read lines
from a text file NewsLetter.TXT, and display those words, which are lesser than 4
characters. Your teachers intentionally kept few blanks in between the code and asked
you to fill the blanks so that the code will run to find desired result. Do the needful with
the following python code.
def FilterWords():
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
FilterWords()
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
v. Fill in the blank in Statement-5 to close the file.
SECTION E
34 A department is considering to maintain their worker data using SQL to store the data. As 4
a Database Administrator, Karan has decided that:
Name of the database –Department
Name of the table –Worker
The attributes of Worker are as follows:
WORKER_ID – CHARACTER OF SIZE 3
FIRST_NAME – CHARACTER OF SIZE 10
LAST_NAME – CHARACTER OF SIZE 10
SALARY – NUMERIC
JOINING_DATE – DATE
WORKER_ID FIRST_NAME LAST_NAME SALARY JOINING_DATE DEPARTMENT
001 MONIKA ARORA 100000 2014-02-20 HR
002 NIHARIKA DIWAN 80000 2014-06-11 Admin
003 VISHAL SINGHAL 300000 2014-02-20 HR
004 AMITABH SINGH 500000 2014-02-20 Admin
005 VIVEK BHATI 500000 2014-06-11 Admin
006 VIPUL DIWAN 200000 2014-06-11 Account
007 SATISH KUMAR 75000 2014-02-20 Account
008 MONIKA CHAUHAN 80000 2014-04-11 Admin
a) Karan wants to remove all the data from table WORKER from the database
department. Write the command to delete above said information.
b) Identify the attribute best suitable to be declared as a primary key.
c) (i) Karan wants to increase the size of the FIRST_NAME column from 10 to 20
characters. Write an appropriate query to change the size.
(ii) Write a query to display the structure of the table Worker, i.e. name of the
attribute and their respective data types
OR (only for part c)
Write command to create above table
35 Amritya Seth is a programmer, who has recently been given a task to write a python code 4
to perform the following binary file operations with the help of two user defined
functions/modules:
a. AddStudents() to create a binary file called STUDENT.DAT containing student
information – roll number, name and marks (out of 100) of each student.
b. GetStudents() to display the name and percentage of those students who have a
percentage greater than 75. In case there is no student having percentage > 75 the
function displays an appropriate message. The function should also display the average
percent.
SAMPLE PAPER SET 4
CLASS – XII SUBJECT: Computer Science-083
Total Time- 3 Hours Total Marks- 70

7. Section E has 02 questions carrying 04 marks each. One internal choice is given in
Q34 against part iii only.
SECTION A
1. Find the invalid identifier from the following 1
a) MyName b) True c) 2ndName d) My_Name
2. (Which of the following is a mutable datatype in Python? 1
(a) String (b) List (c)Integer (d) Tuple
3. Given the following dictionaries 1
D1={"Exam":"ICSCE", "Year":2023, "Total":500}
Which statement will add a new value pair (Grade: “A++”) in dictionary D1?
a. D1.update(“REMARK” : “EXCELLENT”)
b. D1 + {“REMARK” : “EXCELLENT”}
c. D1[“REMARK”] = “EXCELLENT”
d. D1.merge({“REMARK” : “EXCELLENT”})
4. Consider the given expression: 1
not False or 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
5. Select the correct output of the code: 1
Str = "KENDRIYA VIDYALAYA SANGATHAN JAMMU REGION"
Str = Str.split()
NewStr = Str[0] + "#" + Str[1] + "#" + Str[4]
print (NewStr)
a) KENDRIYA#VIDYALAYA#SANGATHAN# JAMMU
b) KENDRIYA#VIDYALAYA#SANGATHAN
c) KENDRIYA#VIDYALAYA# REGION
d) None of these
1
6. Assume that the position of file pointer is at the beginning of 3 rd line in a text file. 1
Which of the following option can be used to read all remaining lines?
(a) file.read() (b) file.readlines() (c) file.readline() (d) None of these
7. Fill in the blank: 1
command is used to change datatype of a field in table in SQL.
(a) update (b)remove (c) alter (d)drop
8. ________ in a table represent relationship among a set of values. 1
(a) Column (b) Keys (c) Row (d) Entry

9. Which of the following statement(s) would give an error after executing the 1
following code?
P ="FIRST PRE BOARD" # Statement 1 print(P) #

Statement 2
P = P[1:7] + "Questions" # Statement 3
P[0] = '&' # Statement 4
P =P + "Over" # Statement 5
(a) Statement 3 b) Statement 4

(c) Statement 5 d) Statement 4 and 5

is a set of one or more attributes, which can uniquely identify any tuple
in a relation.
a) Primary Key b) Foreign Key c) Candidate Key d) Alternate Key
11. The _________ method of _____ module is used to read data from binary file : 1
a) read(), binary b) load(), pickle
c) dump(), binary d) dump(), pickle
12. Which keyword can be used to show only different values in a particular 1
column in a table?
a) DESCRIBE b) DISTINCT c) UNIQUE d)NULL
Which of the following statement are true about URL?
(a) URL means Uniform Resource Locator b) We can enter URL into address bar
(c) An example of URL is top@gg.com (d) Both A and B
14. What will the following expression be evaluated to in Python? 1
print(75.0 / 4 + (2** 3))
(a) 20.5 (b)20.05 (c) 18.25 (d) 17.75
15. Which function is used to display the Smallest largest value from the selected column 1
of table in a database?
a) Small() b) Least() c) Min() d) None of above()
16. To establish a connection between Python and MySQL database, which of the following 1
method is used?
a) connector() b) connect() c) cont() d) con()
2
17. Assertion (A):- Keyword arguments are related to function call statement. 1
Reasoning (R):- When we use keyword argument in a function call, the caller
identifies the argument by the parameter.
18. Assertion (A): CSV (Comma Separated Values) stands for Comma Separated values File. 1
Reason (R): CSV files are common file format for transferring and storing data.
SECTION
B
19. Correct Code is 2
def DigitSum():
n = int( input("Enter number :: ")
dsum = 0
while n > 0
d = n % 10
dsum =dsum + d
n = n //10
RETURN dsum
20. What is an E-mail? Write two advantages of an E-mail. 2
OR
Write two points of difference between Bus topology and Star topology.
21. (a) Given is a Python string declaration: 1

Word = "Connect Python”
Write the output of: print(Word[: : 3])
dict = {"Item": "Laptop", "Make": "LG" }
dict["Price"] = 57000 1
dict["Make"] = "DELL"
for k in dict:
print(k, ‘@’, dict[k])
22. What do you mean by Candidate Key in Relational Database Management System. Also 2
define Alternate Key.
23. (a) Write the full forms of the following: 2
(i) CDMA (ii) VOIP
(b) What is Web browser? Give name of two commonly used web browsers.
3
24. Predict the output of the Python code given below: 2
L1 =[]
def display(N):
for K in N:
if K % 2 ==0:
L1.append(K//2)
else:
L1.append(K*2)
L = [11,22,33,45,55,66]
print(L)
display(L)
print(L1)
OR
Predict the output of the Python code given below:
T1 = (12, 22, 33, 55 ,66)

list1 =list(T1)
new_list = []
for i in list1:
if i%3==0:
new_list.append(i)
new_T = tuple(new_list)
print(new_T)
25. Differentiate between WHERE and HAVING clause in SQL with appropriate example. 2
OR
Write any Two DDL and Two DML commands.
SECTION C
26 A Stationery shop MyBag has decided to maintain its inventory of items using 1+2
MySQL. As a database administer, Rahul has created the database and table as per
the following :
Name of the database -MyBag
Name of the table - ITEMS
The attributes of ITEMS are as follows: ItemNo – Numeric, ItemName – Character of
size 20 ,Scode –Numeric,Quantity –Numeric
ITEMS
ItemNo ItemName Scode Quantit
y
2005 Sharpener Classic 23 60
2002 Get Pen Premium 21 150
2006 Get Pen Classic 21 250
2001 Eraser Small 22 220
2004 Eraser Big 22 110
a. Identify the best suitable attribute to be declared as a primary key.
b. Insert the following data into the attributes ItemNo, ItemName and SCode
respectively in the given table ITEMS.
ItemNo = 2010, ItemName = “Note Book” , Scode = 25 and Quantity=50
c. Rahul wants to display all the records where ItemName starts with ‘G’.
Write a MySQL query to do the same.
4
27 Write a function in Python to read from a text file “INDIA.TXT”, to find and display 3
those words of file which have 3 characters. For example, If the “INDIA.TXT” contents
are as follows:
“India is the fastest growing economy.
India is looking for more investments around the globe.”
The output of the function should be: the for the
28 a) Write the outputs of the SQL queries (i) to (iv) based on the relations 3
BOOK and ISSUES given below:
Table : Book
Quanti
Book_id Book name Author_name Publisher Price Type ty
C0001 Fast Cook Lata Kapoor EPB 355 Cookery 5
William
F0001 The Tears Hopkins First Pub 650 Fiction 20
T0001 My First c++ Brain & Brooke FPB 350 Text 10
C++ Brain
T0002 works A.W. Rossaine TDH 350 Text 15
F0002 Thunderbolts Anna Roberts First Publ. 750 Fiction 50
Table : issued
Book_Id Quantity Issued
T0001 4
C0001 5
F0001 2
i. Select Count(*) from Books
ii. Select Max(Price) from books where quantity >=15
iii. Select book_name, author_name from books where publishers=’First Publ.’
iv. Select a.book_id,a.book_name,b.quantity_issued from books a, issued b
where a.book_id=b.book_id
(b) Write the command to open a database “RAILWAY” in MySQL.

29. Write the definition of a function Reverse(X) in Python to display the elements in 3
reverse order such that each displayed element is twice of the original element
(element *2) of the List X in the following manner:
For example, if List X contains 7 integers as follows:
X [0] X[1] X[2] X[3] X[4] X[5] X[6]

4 8 7 5 6 2 10
After executing the function, the array content should be displayed as follows:
X [0] X[1] X[2] X[3] X[4] X[5] X[6]
20 4 12 10 14 16 8
5
30 Consider a binary file Employee.dat containing details such as 3
empno:ename:salary(separator ‘:’). Write a Python function Readfile() to display details
of those employees who are earning between 20000 and 40000(both values inclusive)
also count how many records are available in the file.
OR
A binary file named “TEST.dat” has some records of the structure [TestId, Subject,
MaxMarks, ScoredMarks]
Write a function in Python named DisplayAvgMarks(Sub) that will accept a subject as an
argument and read the contents of TEST.dat. The function will calculate & display the
Average of the ScoredMarks of the passed Subject on
screen.
SECTION D
31 Software Development Company has set up its new center at Raipur for its office and 5
web based activities. It has 4 blocks of buildings named Block A, Block B, Block C, Block
D.
No of Computers in each Block Distance between various blocks
Block A 25 Block A to Block B 60 Mtrs
Block B 50 Block B to Block C 40 Mtrs
Block C 125 Block C to Block A 30 Mtrs
Block D 10 Block D to Block C 50 Mtrs
a) Suggest the most suitable place (i.e. block) to house the server of this company
with a suitable reason.
b) Suggest the ideal layout to connect all the blocks with a wired connectivity.
c) Which device will you suggest to be placed/installed in each of these blocks to
efficiently connect all the computers within these blocks.
d) Suggest the placement of a repeater in the network with justification.
The company is planning to link all the blocks through a secure and
high speed wired medium. Suggest a way to connect all the blocks.
32 (a) Write the output of the code given below: 2+3
Find and write the output of the following python code:

def encrypt(s):
k=len(s)
m=""
if(s[i].isupper()):
m=m+str(i)
elif s[i].islower():
m=m+s[i].upper()
else:
m=m+'*'
print(m)
encrypt('KVS@Jammu')
(b) The code given below inserts the following record in the table Item:
6
ItemNo – integer Name –
string
Price – integer
Qty – integer

 Password is beeta
 The table exists in a MYSQL database named RESOURCE.
 The details (ItemNo, Name, Price and Qty) are to be accepted from the
user.
Statement 1 – to import the required module
Statement 2 – to execute the command that inserts the record in the table Student.
import ___________________ as mysql # Statement 1
def sql_data():
con1=mysql.connect(host="localhost", user="root",
password="omega", database="resource")
mycursor= con1.cursor()
ItemNo = int(input("Enter ItemNo :: "))
Name = input("Enter name :: ")
Price = int(input("Enter price :: "))
Qty = int(input("Enter Qty :: "))
querry="insert into student
values({}, '{}',{ }, {})".format(Itemno, Name, Price, Qty)
_______________________ #Statement 2
_______________________ # Statement 3
print("Data Added successfully")
OR
(a) Predict the output of the code given below:
s ="Back2Basic"
n = len(s)
NS =""
if (s[i] in “áeiou”):
NS = NS + s[i].upper()
elif (s[i] >= 'a' and s[i] <= 'z'):
NS = NS +s[i].lower()
else:
NS = NS + '#'
print(NS)
(b) The code given below reads the following record from the table named student
and displays only those records who have marks greater than 85:
RollNo – integer Name –
string Class – integer
Marks – integer
7
 The table exists in a MYSQL database named school.

Statement 2 – to execute the query that extracts records of those students whose
marks are greater than 85.
Statement 3- to read the complete result of the query (records whose marks are
greater than 85) into the object named data, from the table student in the database.
def sql_data():
database="school")
mycursor= #Statement 1
print("Students with marks greater than 85 are :")
_________________________ #Statement 2
data = #Statement 3
for i in data:
print(i)
print()
33. a) What do you mean by a csv file? 5
(1+2+2
)
b) A binary file “Book.dat” has structure [BookNo, Book_Name, Author, Price].
a) Write a user defined function CreateFile() to input data for a record and add to
Book.dat file.
b) Write a function CountRec(Author) in Python which accepts the Author name as
parameter and count and return number of books written by the given Author are
stored in the binary file “Book.dat”
OR
a) Difference between a binary file and a csv file.
b Write a function in python, pushme (stock, item) and popme(stock ) to add a new
item and delete an item from the stock, considering them to act as push and pop
operations of the stack.
SECTION E
8
34 Nawal Rao creates a table Emp 1+1+2
Emp Name Dept Design Gend Salary City

no er
1 Deepika Sales Mgr F 55000 Delhi
2 Gagan Acct Opt M 20000 Patna
3 Neelam Comp Opt F 25000 Delhi
4 Vijay Sales Mgr M 45000 Lucknow
5 Sunita Acct Opt F 14000 Delhi
6 Rajesh Sales Clrk M 35000 Patna
7 Kunal Comp Mgr M 40000 Lucknow
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 one column is added and 2 rows are deleted from the table EMP, 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
EmpNo- 8, Name- Ravi, Dept- Sales, Design- Mgr, Gender- M, Salary –
34000, City- Delhi .
b. Increase the Salary of the Employees who are in Acct department
by 3%.
OR (Option for part iii only)
a. Delete the record of Employees who lives in Delhi.
b. Add a column MobNo in the table with datatype as
varchar with 10 characters
35 Aditya has written a code and created a binary file record.dat with ItemNo, Itname and
Price.
As a Python expert, help him to complete the following code based on the requirement
given above:
Import ________________ #Statement 1

def Add_data():
fin = open("record.dat", " __ ") #Statement 2
Lst = [áa’, 3.5, 66,77, 8, 10]
________________.(Lst, fin) #Statement 3
print(“Record Added”)
fin.______________ #Statement 4
Add_Rec()
1
a) Name the Module that Aditya should import in Statement 1
b) In which mode, Aditya should open the file to add data into the file in statement 1
2.
2
c) Fill in the blank in statement 3 to fetch the data to a file and statement 4 to close
the file.
9
SAMPLE PAPER SET 5

7. Section E has 02 questions carrying 04 marks each. One internal choice isgiven
in Q35 against part c only.
Q1. Which is a valid identifier in python? 1

(a) int
(b) len
(c) ssum1
(d) all of them
Q2. Which type of Programming does Python support? 1
(a) object-oriented programming
(b) structured programming
(c) functional programming
(d) all of the mentioned
Q3 Which keyword is used for function in Python language? 1
(a) Function
(b) def
(c) Fun
(d) Define
Q4. Create the dictionary on data 1
Exam=”PB”
Year=”2013”
Where exam and year are keys
Q5. Consider the given expression: 1

not True and False or True
Which of the following will be correct output if the given expression is
evaluated?
(a) True
(b) False
(c) None
(d) NULL
Q6. What is the output of the following? 1
print('KV Sangathan'.split('an'))
(a) ['KV S', 'gath', ' ']
(b) [‘KV Sangathan’,’an’]
(c) [‘KV’,’Sang’,’athan’]
(d) All of them
Q7. Which of the following modes will refer to binary data? 1
(a) r
(b) wb
(c) +
(d) a
Q8. Fill in the blank: 1
______ command is used to remove the database in sql.
(a) Update
(b) Remove
(c) Drop
(d) alter
Q9. Which of the following commands will be delete the table from MYSQL 1
Database?
(a) Delete table
(b) Drop Table
(c) Remove Table
(d) Alter Table
Q10 If the following code is executed, what will be the output of the following code? 1
. name="Kendriya Vidyalaya Sangathan"
print(name[10:19])
(a) Kendriya
(b) Vidyalaya
(c) Sangathan
(d) nry iy
Q11 Which of the following types of table constraints will prevent the printing 1
.
of duplicate values after the Select statement fetches data from table?
(a) Unique
(b) Distinct
(c) Primary Key
(d) NULL
Q12 What is the use of tell () function in python 1
.
Q13 Switch is a 1
. A. Broadcast device B. Unicast device C. Multicast device D. None of the above
Q14 What will the following expression be evaluated to in python? 1
. print(15.0/4+(8*3.0))
(a) 14.5
(b) 14.0
(c) 27.7
(d) 15.5
Q15 Which function is used to display the sum of column of records from table in a 1
. database?
(a) sum(*)
(b) total(*)
(c) count(*)
(d) return(*)
Q16 What is the use of connect () function ? 1
.
Q17 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
17. Assertion (A):- If the arguments in function call statement match the 1
number and order of arguments as defined in the function definition,
such arguments are called positional arguments.
Reasoning (R):- During a function call, the argument list first contains
default argument(s) followed by positional argument(s).
Q18 Assertion (A): CSV (Comma Separated Values) is a file format for data storage 1
. which looks like a text file.
Reason (R): The information is organized with one record on each line and each
Section-B
Q19 Mr. Ram has written a code to input two numbers and swap the number using 2
. function but he has some error in his coding, so help him to rectify the errors
and rewrite the correct code.
Def swap(a,b)
c=a
a=b
b=c
print("a is",a,"b is",b )
#main()
a=int(input("enter in a "))
b=int(input("enter in b"))
Swap(a,b)#calling a function
Q20 What is the difference between a hub and a switch in context of computer 2
.
networking devices?
OR
Differentiate between HTTP and FTP.
Q21 Evaluate the following expressions: 2
.
(a) 5 // 10 * 9 % 3 ** 8 + 8 – 4
(b) 65 > 55 or not 8 < 5 and 0 != 55
Q22 Explain the use of ‘Foreign Key’ in a Relational Database Management System. 2
.
Give example to support your answer.
Q23 Expand the following terms: 2
. IMAP sHTTP URL POP3
Q24 Predict the output of the Python Code given below: 2
. d={"Rohan":67,"Ahasham":78,"naman":89,"pranav":79}
print(d)
sum=0
for i in d:
sum+=d[i]
print(sum)
print("sum of values of dictionaries",sum)
or
(i) def check(x,y):
if x != y:
return x+5
else:
return y+10
print(check(10,5))
Q25 Write the full forms of DDL and DML. Write any two commands of DDL in SQL. 2
. Or
In SQL, write the name of the aggregate function which is used to calculate &
display the sum of numeric values in an attribute of a relation.
Section- C
Q26 Write the outputs of the SQL queries (i) to (iii) based on the given tables: 3
.
Table: Event
EventID Event NumPerformers CelebrityID
101 Birthday 10 C102
102 Promotion Party 20 C103
103 Engagement 12 C102
104 Wedding 15 C104
Table: Celebrity
CelebrityID Event Phone FeeCharged
C101 FaizKhan 9910154555 200000
C102 Sanjay Kumar 6546454654 250000
C103 Neera Khan 4654656544 300000
C104 Reena Bhatia 9854664654 100000
(i) SELECT Event, NumPerformers FROM Event where EvenID>102;

(ii) SELECT max(FeeCharged), min(FeeCharged) FROM Celebrity;
(iii) SELECT Event.Event, Event.NumPerformers, Celebrity.Phone ,
Celebrity.FeeCharged FROM Event, Celebrity WHERE
Event.Celebrity = Celebrity.CelebrityID;
Q27 Write a function in Python that counts the number of “the” or “this” words 3
. present in a text file “myfile.txt”.
This is my first class on Computer Science. File handling is the easiest topic for
me and Computer Networking is the most interesting one.
The output of the function should be: Count of the/this in file: 3
OR
Write a function countVowels() in Python, which should read each character of a
text file “myfile.txt”, count the number of vowels and display the count.
This is my first class on Computer Science.
The output of the function should be: Count of vowels in file: 10
Q28 3
Q29 Write a function INDEX_LIST(L), where L is the list of elements passed 3

as argument to the function. The function returns sum of odd nos in list .
Q30 Two list Lname and Lage contains name of person and age of person 3
respectively. A list named Lnameage is empty. Write functions as details given
below
(i) Push_na() :- it will push the tuple containing pair of name and age
from Lname and Lage whose age is above 50
(ii) Pop_na() :- it will remove the last pair of name and age and also print
name and age of removed person. It should also print “underflow” if
there is nothing to remove
For example the two lists has following data
Lname=[‘narender’, ‘jaya’, ‘raju’, ‘ramesh’, ‘amit’, ‘Piyush’]
Lage=[45,23,59,34,51,43]
After Push_na() the contains of Lnameage stack is

[(‘raju’,59),(‘amit’,51)]
The output of first execution of pop_na() is
The name removed is amit
The age of person is 51
OR
A dictionary stu contains rollno and marks of students. Two empty list stack_roll
and stack_mark will be used as stack. Two function push_stu() and pop_stu() is
defined and perfom following operation
(a) Push_stu() :- It reads dictionary stu and add keys into stack_roll and
values into stack_marks for all students who secured more than 60
marks.
(b) Pop_stu() :- it removes last rollno and marks from both list and print
“underflow” if there is nothing to remove
For example
stu={1:56,2:45,3:78,4:65,5:35,6:90}
values of stack_roll and stack_mark after push_stu()

[3,4,6] and {78,65,90}
Section-D
Q31 Tech Up Corporation is a professional consultancy company. The company is
planning to set up their offices in India with it’s hub at Hyderabad. As a network
advisor, you have to understand their requirement and suggest to them the best
available solutions.
Block to Block distance (in meters):
Block (From) Block Distance (in meter)
Human Resource Conference 60
Human Resource Finance 60
Conference Finance 120
Expected number of Computers to be installed in each block:
Block Computer
Human Resource 125
Finance 25
Conference 60
(a) What will be the most appropriate block where TUC should plan to install 1
their server?
(b) What will be the best possible connectivity out of the following to 1
connect its new office in Bengaluru with its London based office?
(i) Infrared
(ii) Satellite Link
(iii) Ethernet Cable
(c) Which of the following devices will you suggest to connect each
1
computer in each of the above blocks?
(i) Gateway
(ii) Switch
(iii) Hub
(iv) Modem
1
(d) Write names of any two popular open Source software which are used as
Operating Systems.
1
(e) Suggest an ideal layout for connecting these blocks/centers for a wired
connectivity
Q32 (a) Write the output of the code given below: 2+3
p=5
def sum(q,r=2):global
p p=r+q**2
print(p, end= '#')
a=10
b=5
sum(a,b)
sum(r=5,q=1)
(b)The given program is used to connect with MySQL abd show the name of the
all the record from the table “stmaster” from the database “oraclenk”. You are
required to complete the statements so that the code can be executed properly.
import _____.connector_as_pymysql
dbcon=pymysql._____________(host=”localhost”, user=”root”,
________=”sia@1928”)
if dbcon.isconnected()==False:
print(“Error in establishing connection:”)
cur=dbcon.______________()
query=”select * from stmaster”
cur.execute(_________)
resultset=cur.fetchmany(3)
for row in resultset:
print(row)
dbcon.______()
OR
s="welcome2cs"
n = len(s)m=""
if (s[i] >= 'a' and s[i] <= 'm'):m =m +s[i].upper()
elif (s[i] >= 'n' and s[i] <= 'z'):m = m +s[i-1]
elif (s[i].isupper()): m = m +
s[i].lower()
else:
m = m +'&'
print(m)
(b) The code given below reads the following record from the tablenamed
student and displays only those records who have marks greater than 75:
RollNo – integer
Name – string
Clas – integer
Marks – integer
Note the following to establish connectivity between Python andMYSQL:

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
students whose marks are greater than 75.
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 mysqldef sql_data():
con1=mysql.connect(host="localhost",user="root",password="tiger",
database="school")
print("Students with marks greater than 75 are :")
__________________________________________#Statement 2
data= #Statement 3
for i in data:
print(i)
print()
Q33 What is the advantage of using a csv file for permanent storage? 5
. Write a Program in Python that defines and calls the following userdefined
functions:
(i) ADD() – To accept and add data of an employee to a CSV file
‘record.csv’. Each record consists of a list with field elements as
empid, name and mobileto store employee id, employeename and
employee salary respectively.
(ii) COUNTR() – To count the number of records present in the CSVfile
named ‘record.csv’.
OR
Give any one point of difference between a binary file and a csv file.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

‘furdata.csv’. Each record consists of a list with fieldelements as
fid, fname and fpriceto store furnitureid, furniture name and
furniture price respectively.
search()- To display the records of the furniture whoseprice is more than 10000.
Section-E
Q34 Nishant creates a table RESULT with a set of records to maintain the marks 1+1+
secured by students in Sem 1, Sem2, Sem3 and their division. After 2
creation of the table, he has entered data of 7 students in the table.
ROLL_NO SNAME SEM1 SEM2 SEM3 DIVISION
101 KARAN 366 410 402 I
102 NAMAN 300 350 325 I
103 ISHA 400 410 415 I
104 RENU 350 357 415 I
105 ARPIT 100 75 178 IV
106 SABINA 100 205 217 II
107 NEELAM 470 450 471 I
(i) Identify the most appropriate column, which can be consideredas

Primary key.
(ii) If two columns are added and 2 rows are deleted from the tableresult,
what will be the new degree and cardinality of the above table?
Roll No- 108, Name- Aadit, Sem1- 470, Sem2-444, Sem3-475,
Div – I.
b. Increase the SEM2 marks of the students by 3% whose
name begins with ‘N’.

a. Delete the record of students securing IV division.
b. Add a column REMARKS in the table with datatype as
varcharwith 50 characters
Q35 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
else:
pickle.dump(rec,fout)
except:
break
if found==True:
print("The marks of student id ",sid," hasbeen updated.")
else:
print("No student with such id is not found")
fin.close()
fout.close()
1
(i) Which module should be imported in the program? (Statement1)
(ii) Write the correct statement required to open a temporary filenamed
1
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 2
in the file, extra.dat?
SAMPLE PAPER SET 6

7. Section E has 02 questions carrying 04 marks each. One internal choice isgiven
Q1. State True or False 1

“variable declaration is implicit in Python”
Q2. Which type of Programming does Python support? 1
(a) object-oriented programming
(b) structured programming
(c) functional programming
(d) all of the mentioned
Q3 Which of the following is an invalid datatypes in Python? 1
(a) Set
(b) None
(c) Integer
(d) Real
Q4. Given the following dictionaries 1
exam={"Exam":"AISSCE","Year":2023}
result={"Total":500,"Pass_Marks":165}
(a) dict_exam.update(result)
(b) dict_exam+result
(c) dict_exam.add(result)
(d) dict.merge(result)
Q5. Suppose a tuple T is declare as: 1
T=(10,12,43,39)
Which of the following is in correct?
(a) print(t[1])
(b) T[2]=-29
(c) print(max(T)
(d) print(len(T))
Q6. What is the output of the following? 1
print('KV Sangathan'.split('an'))
(a) ['KV S', 'gath', ' ']
(b) [‘KV Sangathan’,’an’]
(c) [‘KV’,’Sang’,’athan’]
(d) All of them
Q7. What is the output of the following code. 1
Str1=”Hello World”
str1.replace('o','*')
str.replace('o','*')
(a) Hello World
(b) Hell* W*rld
(c) Hello W*rld
(d) Error
Q8. What is the datatype of the result set extracted from the databaseusing the cursor 1
object when we use the following:
(a) fetchone( ) method
(b) fetchall( ) method
Q9. Which of the following commands will be delete the table from MYSQL 1
Database?
(a) Delete table
(b) Drop Table
(c) Remove Table
(d) Alter Table
Q10 If the following code is executed, what will be the output of the following code? 1
. name="Kendriya Vidyalaya Sangathan"
print(name[2:13:2])
(a) Kendriya
(b) Vidyalaya
(c) Sangathan
(d) nry iy
Q11 Which of the following types of table constraints will prevent the printing of 1
.
duplicate values after the Select statement fetches data from table?
(a) Unique
(b) Distinct
(c) Primary Key
(d) NULL
Q12 The Correct syntax of seek() is: 1
.
(a) File_object.seek(offset[,reference_point])
(b) seek(offset[,referece_point])
(c) seek(offset,file_object)
(d) seek.file_object(offset)
Q13 (i) Expand the following: 1
. ARPANET, TCP/IP
Q14 What will the following expression be evaluated to in python? 1
. print(15.0/4+(8+3.0))
(a) 14.5
(b) 14.0
(c) 15
(d) 15.5
Q15 Which function is used to display the total number of records from table in a database? 1
. (a) sum(*)
(b) total(*)
(c) count(*)
(d) return(*)
Q16 To establish a connection between Python and sql database, connect() is used. Which of 1
. the following arguments may not necessarily be given while calling connect() ?
(a) host
(b) database
(c) user
(d) password
Q17 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
17. Assertion (A):-Serialization is the process of transforming data to a stream of bytes 1
Reasoning (R):-It is also known as Picking
Q18 Assertion (A): CSV (Comma Separated Values) is a file format for data storage which looks 1
. like a text file.
Reason (R): The information is organized with one record on each line and each
Section-B
Q19 Mr. Ram has written a code to input two numbers and swap the number using function 2
. but he has some error in his coding, so help him to rectify the errors and rewrite the
correct code.
Def swap(a,b)
c=a
a=b
b=c
print("a is",a,"b is",b )
#main()
a=int(input("enter in a "))
b=int(input("enter in b"))
Swap(a,b)#calling a function
Q20 What is the difference between a hub and a switch in context of computer networking 2
.
devices?
OR
Differentiate between HTTP and FTP.
Q21 Evaluate the following expressions: 2
.
(a) 5 // 10 * 9 % 3 ** 8 + 8 – 4
(b) 65 > 55 or not 8 < 5 and 0 != 55
Q22 Explain the use of ‘Foreign Key’ in a Relational Database Management System. Give 2
.
example to support your answer.
Q23 Define the following terms: 2
. Web server, Web Hosting
OR
Give two advantages and two disadvantages of bus topology.
Q24 Predict the output of the Python Code given below: 2
. d={"Rohan":67,"Ahasham":78,"naman":89,"pranav":79}
print(d)
sum=0
for i in d:
sum+=d[i]
print(sum)
print("sum of values of dictionaries",sum)
or
for i in range(1,3):
print('answer ',i,'is', i**2)
Q25 Write the full forms of DDL and DML. Write any two commands of DDL in SQL. 2
. Or
Categories the following commands as DDL or DML:
INSERT, UPDATE,ALTER,DROP
Section- C
Q26 Write the outputs of the SQL queries (i) to (iii) based on the given tables: 3
.
Table: Event
EventID Event NumPerformers CelebrityID
101 Birthday 10 C102
102 Promotion Party 20 C103
103 Engagement 12 C102
104 Wedding 15 C104
Table: Celebrity
CelebrityID Event Phone FeeCharged
C101 FaizKhan 9910154555 200000
C102 Sanjay Kumar 6546454654 250000
C103 Neera Khan 4654656544 300000
C104 Reena Bhatia 9854664654 100000
(i) SELECT Event, NumPerformers FROM Event where EvenID>=104;

(ii) SELECT max(FeeCharged) FROM Celebrity;
(iii) SELECT Event.Event, Event.NumPerformers, Celebrity.Phone ,
Celebrity.FeeCharged FROM Event, Celebrity WHERE Event.Celebrity =
Celebrity.CelebrityID;
Q27 Write a user-defined function named count() that will read the 3
. contents of text file named “Story.txt” and count the number
of lines which starts with either “I‟ or “M‟. E.g. In the following
paragraph, there are 2 lines starting with “I‟ or “M‟:
OR
Write a function countmy( )in Python to read the text file “Story.txt” and
count the number of times “my” or “My” occurs in the file. For example if
the file “Story.TXT” contains:
“This is my website. I have displayed my preferences in the CHOICE
section.”
The countmy( ) function should display the output as: “my occurs 2 times”.
Q28 (a) Write the output of the following sql queries (i) to (iv) based on the relations 3
Teacher and Placement given below:
Table: Teacher
T_ID Name Age Department DOJ Salary Gender

1 Arunan 34 Computer Sc 2019-01-01 12000 M
2 Saman 31 History 2017-03-24 20000 F
3 Randeep 32 Mathematics 2020-12-12 30000 M
4 Samira 35 History 2018-07-01 40000 F
5 Raman 42 Mathematics 2021-09-05 25000 M
6 Shyam 50 History 2019-06-27 30000 M
7 Shiv 44 Computer Sc 2019-02-25 21000 M
8 Shalakha 33 Mathematics 2018-07-31 20000 F
Table :Placement
P_ID Department Place
1 History Ahmedabad
2 Mathematics Jaipur
3 Computer Sc Nagpur
(i) SELECT Department, avg(salary) FROM Teacher GROUPBY Department;

(ii) SELECT MAX(DOJ), MIN(DOJ ) FROM Teacher;
(iii) SELECT NAME , SALARY, T. Department, Place from Teacher T, Placement P where
T. Department =P.Department and Salary>20000;
(iv) SELECT Name, Place from Teacher T, Placement P;
Q29 Write a program to calculate and display the sum of all the odd numbers in the list. 3
Q30 Alam has a list containing 10 integers. You need to help him create a program with 3
separate user
defined functions to perform the following operations based on this list.
l Traverse the content of the list and push the even numbers into a stack.
l Pop and display the content of the stack.
For Example:
If the sample Content of the list is as follows:
N=[12, 13, 34, 56, 21, 79, 98, 22, 35, 38]
Sample Output of the code should be:38 22 98 56 34 12
OR
Write a function in Python, Pop(Arr), where Arr is a stack implemented by a list of
numbers. The function should return the value deleted from the stack.
Section-D
Q31 National Centre for Indigenous Arts has just set up a new Campusand they want to
set up a Local area network.
The distances between various buildings of university aregiven as:-

Main to Admin 50 mtr Main to
Finance 100 mtrMain to
Academic 70 mtr Admin to
Finance 50 mtr Finance
to Academic70 mtrAdmin to Academic
60 mtr
Number of computers in each building:-
Main Building 150
Admin Building 75
Finance Building 50
Academic Building 60
As a network expert, you are required to give best possiblesolutions for the given
queries of the university administration:-
1
(a) Suggest and draw cable layout to efficiently connect various

buildings/blocks. 1
(b) Suggest the most suitable building to house the server of this university
with a suitable reason.
(c) Suggest the placement of following devices with justification:

1. Switch/Hub 1
2. Repeater
(d) Suggest the transmission medium out of the following for setting-up very 1
fast Internet connectivity among buildings of the university
1. Optical Fiber 1
2. Coaxial cable
3. Ethernet Cable
Q32 (a) Write the output of the code given below: 2+3
p=5
def sum(q,r=2):global p
p=r+q**2
print(p, end= '#')
a=10
b=5 sum(a,b)
sum(r=5,q=1)
(b) The code given below inserts the following record in the tableStudent:
RollNo – integer
Name – string
Class– integer
Marks – integer

Username is root,Password is tigerThe table exists in a MYSQL database named
school.The details (RollNo, Name, Clas and Marks) are tobe 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 thetable Student.
def sql_data():
con1=mysql.connect(host="localhost",user="root",password="tiger",database="s
chool")
rno=int(input("Enter Roll Number :: ")) name=input("Enter name :: ")
clas=int(input("Enter class :: ")) marks=int(input("Enter Marks :: "))
values({},'{}',{},{})".format(rno,name,clas,marks)
#Statement 2
# Statement 3
OR
s="hello kv *& INDia"

n = len(s)
m=""
if (s[i] >= 'a' and s[i] <= 'm'):
m= m +s[i].upper()
elif (s[i] >= 'n' and s[i] <= 'z'):
m = m +s[i-1]
elif (s[i].isupper()): m = m + s[i].lower()
else:
m = m +'&'
print(m)
(b) The code given below reads the following record from the tablenamed student
and displays only those records who have marks greater than 75:
RollNo – integer
Name – string
Clas – integer
Marks – integer

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 thosestudents whose
marks are greater than 75.
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.

def sql_data():
con1=mysql.connect(host="localhost",user="root",password="tiger",
database="_________") statement 1
print("Students with roll greater than 10 are :")
data= #Statement 3
for i in data:
print(i)
print()
Q33 What is the advantage of using a csv file for permanent storage? 5
. Write a Program in Python that defines and calls the following userdefined functions:
(i) ADD() – To accept and add data of an employee to a CSV file ‘record.csv’. Each
record consists of a list with field elements as empid, name and mobileto store
employee id, employeename and employee salary respectively.
(ii) COUNTR() – To count the number of records present in the CSVfile named
‘record.csv’.
OR
Give any one point of difference between a binary file and a csv file.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

‘furdata.csv’. Each record consists of a list with fieldelements as fid,
fname and fpriceto store furnitureid, furniture name and furniture
price respectively.
search()- To display the records of the furniture whoseprice is more than 10000.
Section-E
Q34 Nishant creates a table RESULT with a set of records to maintain the marks secured 1+1+
by students in Sem 1, Sem2, Sem3 and their division. After creation of the table, he 2
has entered data of 7 students in the table.
ROLL_NO SNAME SEM1 SEM2 SEM3 DIVISION
101 KARAN 366 410 402 I
102 NAMAN 300 350 325 I
103 ISHA 400 410 415 I
104 RENU 350 357 415 I
105 ARPIT 100 75 178 IV
106 SABINA 100 205 217 II
107 NEELAM 470 450 471 I
(i) Identify the most appropriate column, which can be consideredas Primary
key.
(ii) If 3 columns are added and 2 rows are deleted from the tableresult, what will
be the new degree and cardinality of the above table?
Roll No- 110, Name- Aadit, Sem1- 470, Sem2-444, Sem3-475, Div – I.
b. Increase the SEM2 marks of the students by 3% whosename
begins with ‘N’.

a. Delete the record of students securing I division.
b. Add a column REMARKS in the table with datatype as
varcharwith 100 characters
Q35 Devi is a Python programmer. He has written a code and created a binary file record.dat
with employeeid, ename and salary. The filecontains 10 records.
He now has to update a record based on the employee id entered bythe user and
update the salary. The updated record is then to be written in the file temp.dat. The
records which are not to be updated also have to be written to the file temp.dat. If
the employee id is not found, an appropriate message should to be displayed.
As a Python expert, help him to complete the following code based onthe requirement
given above:
import #Statement 1
def update_data():
rec={}
fin=open("record.dat","rb")
fout=open(" -------“) ") #Statement 2
found=False
eid=int(input("Enter employee id to update theirsalary :: "))
while True:
try:
rec= #Statement 3
if rec["Employee id"]==eid:
found=True
rec["Salary"]=int(input("Enter new salary:: "))
pickle. #Statement 4
else:
pickle.dump(rec,fout)except:
break
if found==True:
print("The salary of employee id ",eid," hasbeen updated.")
else:
print("No employee 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 filenamed 1
temp.dat. (Statement 2)
1
(iii) Which statement should Aman fill in Statement 3 to read the
data from the binary file, record.dat and in Statement 4 towrite the updated data in the
2
file, temp.dat?
SAMPLE PAPER SET – 7
CLASS – XII Subject: COMPUTER SCIENCE
Maximum Marks: 70 Time Allotted: 3 hours
7. Section E has 02 questions carrying 04 marks each.
SECTION – A
1. Python identifiers are case sensitive. 1
a) True
b) False
2. Find the invalid identifier from the following: 1
a) None
b) address
c) Name
d) Pass
3. Which is the correct form of declaration of dictionary? 1
a) Day={1:’Monday’,2:’Tuesday’,3:’Wednesday’}
b) Day={‘1:Monday’,’2:Tuesday’,’3:Wednesday’}
c) Day=(1:’Monday’,2:’Tuesday’,3:’Wednesday’)
d) Day=[1:’Monday’,2:’Tuesday’,3:’Wednesday’]
4. What is the output of ‘hello’+1+2+3? 1
a) hello123
b) hello6
c) Error
d) Hello+6
5. What will be the output for the following Python statement? 1
T=(10,20,[30,40,50],60,70)
T[2][1]=100
print(T)
a) (10,20,100,60,70)
b) (10,20,[30,100,50],60,70)
c) (10,20,[100,40,50],60,70)
d) None of these
6. Which of the following is not a correct Python statement to open a text file 1
“Notes.txt” to write content into it?
a) F=open(‘Notes.txt’,’w’)
b) F=open(‘Notes.txt’,’a’)
c) F=open(‘Notes.txt’,’A’)
d) F=open(‘Notes.txt’,’w+’)
7. Which command is used to add a new constraint in existing table in SQL. 1
a) insert into
b) alter table
c) add into
d) create table
8. Which SQL command is used to change some values in existing rows? 1
a) update
b) insert
c) alter
d) order
9. STRING=“WELCOME” Line1 1
NOTE= “ ” Line2
for S in range[0,8]: Line3
print(STRING[S]) Line4
print(S STRING) Line5
Which statement is wrong in above code:

a) Line3 and Line4
b) Line4 and Line5
c) Line2 and Line3
d) Line3 and Line5
10. Which of the following aggregate function ignore NULL value? 1
a) COUNT
b) MAX
c) AVERAGE
d) ALL OF THESE
11. Which of the following option is the correct Python statement to read and display 1
the first 10 characters of a text file “Notes.txt”?
a) F=open(“Notes.txt”); print(F.load(10))
b) F=open(“Notes.txt”); print(F.dump(10))
c) F=open(“Notes.txt”); print(F.read(10))
d) F=open(“Notes.txt”); print(F.write(10))
12. Consider the following statement: 1
SELECT * FROM PRODUCT ORDER BY RATE………, ITEM_NAME ………
Which of the following option should be used to display the rate from greater to
smaller and name in alphabetical order?
a) ASC, DESC
b) DESC, ASC
c) Descending, Ascending
d) Ascending, Descending
13. The function of a repeater is to take a weak signals and ……………… it. 1
a) Restore
b) Regenerate
c) Reroute
d) Drop
14. Evaluate the following expression and identify the correct answer: 1
16 – (4 + 2) * 5 + 2**3 * 4
a) 54
b) 46
c) 18
d) 32
15. In SQL, which command is use to display the structure of table stored in a database. 1
a) Describe
b) Display
c) Select
d) Alter
16. Which of the following is invalid method for fetching the records from database 1
within Python
a) fetchone()
b) fetchall()
c) fetchmany()
d) fetchmulti()
17. Assertion (A): Built-in function are predefined in the language that are used 1
directly.
Reason (R): print() and input() are built-in funcitions
18. Assertion (A): Access mode ‘a’ opens a file for appending. 1
Reason (R): The file pointer is at the end of the file if the file exists.
SECTION – B
19. Rewrite the following code in python after removing all errors. Underline each 2
correction done in the code:
num=int(“Enter any value”)

for in range(0,11):
if num==i
print num+i
else:
Print num-i
20. Differentiate between web browser and web server. 2
OR
Identify the type of topology from the following:
a) Each node is connected with central switching through independent cable.
b) Each node is connected with the help of a single cable.
21. a) Given a Tuple 1
tup1=(10,20,30,40,50,60,70,80,90).
What will be the output of
print(tup1[3:7:2])?
b) Write the output of following code:
lst1=[10,15,20,25,30]
lst1.insert(3,4)
lst1.insert(2,3)
print(lis[-5]) 1
22 What do you mean by alternate key in a relation/table? Give a suitable example of 2
alternate key.
23 a) Which protocol helps us to browse web pages on browsers? 1
b) Write full form of the following:
i) IMAP
ii) POP 1
24 Write the output of the following Python program code: 2
Value = 100
def funvalue():
global Value
Value//=9
print(Value,end=” “)
Value-=10
print(Value,end=” “)
funvalue()
OR
TXT = ["10","20","30","5"]
CNT = 3
TOTAL = 0
for C in [7,5,4,6]:
T = TXT[CNT]
TOTAL = float (T) + C
print (TOTAL)
CNT-=1
25 What do you understand by GROUP BY in SQL? Explain the use of HAVING clause 2
with GROUP BY.
OR
Write the full form of DDL and DML also write any two commands of DML in SQL.
Section-C
26 a) 2+1
Table: GAMES
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
Table: PLAYER
PCode Name Gcode
1 Nabi Ahmad 101
2 Ravi Sahai 108
3 Jatin 101
4 Nazneen 103
(i) SELECT COUNT(DISTINCT Number) FROM GAMES;

(ii) SELECT MAX(ScheduleDate),MIN(ScheduleDate) FROM GAMES GROUP
BY NUMBER HAVING COUNT(*)>2;
(iii) SELECT SUM(PrizeMoney) FROM GAMES;
(iv) SELECT AVG(PRIZEMONEY) FROM GAMES;
b) Define Equi join with a suitable example

27 Write a function in python to count the number of lowercase and uppercase 3
character in a text file “Story.txt”.
OR
Write a function to calculate the average word size in a text file “Report.txt” each
word is separated by a single space or full stop.
28 Write SQL commands for (a) to (d) and write output for (e) to (f) on the basis of 3
PRODUCTS table:
PRODUCT TABLE
PCODE PNAME COMPANY PRICE STOCK MANUFACTURE WARRANTY
P001 TV BPL 10000 200 12-JAN-2008 3
P002 TV SONY 12000 150 23-MAR-2007 4
P003 PC LENOVO 39000 100 09-APR-2008 2
P004 PC COMPAQ 38000 120 20-JUN-2009 2
P005 HANDYCAM SONY 18000 250 23-MAR-2007 3
a) To show details of all PCs with stock more than 110.

b) To list the company which gives warranty for more than 2 years.
c) To show number of products from each company.
d) To show the PRODUCT name which are within warranty as on date.
Give the output of following statements :-
e) Select COUNT(distinct company) from PRODUCT;
f) Select MAX(price) from PRODUCT where WARRANTY<=3;
29 Write a function in Shift(Lst), Which accept a List ‘Lst’ as argument and swaps the 3
elements of every even location with its odd location and store in different list
eg. if the array initially contains
2, 4, 1, 6, 5, 7, 9, 2, 3, 10
then it should contain
4, 2, 6, 1, 7, 5, 2, 9, 10, 3
30 Write a function in Python PUSH(A), where A is a list of numbers. From this list push 3
all even numbers into a stack implemented by using a list. Display the stack if it has
at least one element, otherwise display appropriate error message.
OR
Write a function in python Popstack(Lst), where Lst is a stack implemented by a list
of numbers. The function returns the value deleted from the stack.
SECTION-D
31 Rehaana Medicos Center has set up its new center in Dubai. It has four buildings as 5
shown in the diagram given below:
Accounts Research
Lab
Store Packaging
Unit
Shortest distance between various buildings
Accounts to Research Lab 55 m
Accounts to Store 150 m
Store to Packaging Unit 160 m
Packaging Unit to Research 60 m
Lab
Accounts to Packaging Unit 125 m
Store to Research Lab 180 m
No. of computers installed at various buildings are as follow:

Accounts 25
Research Lab 100
Store 15
Packaging Unit 60
As a network expert, provide the best possible answer for the following queries:
(i) Suggest a cable layout of connections between the buildings.

(ii) Suggest the most suitable place (i.e. buildings) to house the server of
this organization.
(iii) Suggest the placement of the following device with justification:
a) Repeater b) Hub/Switch
(iv) Suggest a system (hardware/software) to prevent unauthorized access

to or from the network.
(v) Which service/protocol will be most helpful to conduct live interactions
between the buildings?
32 a) Study the following program and select the possible output(s) from the options 2+3
(i) to (iv) following it.
import random
Ar=[20,30,40,50,60,70]
From = random.randint(1,3)
To = random.randint(2,4)
for K in range(From,To+1):
print(Ar[K],end="%")
(i) 10%40%70%
(ii) 30%40%50%
(iii) 50%60%70%
(iv) 40%50%60%
b) The code given below inserts the following record in the table Student:
Empno – integer
EName – string
Designation – integer
Salary – integer
Bonus - Integer
 The table exists in a MYSQL database named Employee.
 The details (Empno, EName, Designation, Salary and Bonus) are to be
accepted from the user.
Employee.

def sql_data():
database="Employee")
eno=int(input("Enter Employee Number: "))
Ename=input("Enter Employee Name: ")
designation=input("Enter Designation: "))
salary=int(input("Enter Salary: "))
bonus=int(input("Enter Bonus: "))
querry="insert into employee values({},'{}',{},{})".
format(eno,ename,designation,bonus)
______________________ #Statement 2
______________________ # Statement 3
print("Employee Data Added successfully")
OR
a) Write the output of the following Python program code:
def changedata(str1):
length=len(str1)
temp=""
for i in range(0, length):
if str1[i].islower():
temp=temp+str1[i].upper()
elif str1[i].isupper():
temp=temp+str1[i].lower()
elif str1[i].isdigit():
temp=temp+str(int(str1[i])+1)
else:
temp=temp+'@'
print(temp)
changedata("CbSe_exam@2023")
b) Consider the table Product with following structure:

P_ID, ProductName, Manufacture, Price.
Write python code to increase the price of all product by 50.
33 A binary file “Toy.dat” has structure [TID, Toy, Status, MRP]. 5

i. Write a user defined function CreateFile() to input data for a record and
add to Toy.dat.
ii. Write a function OnOffer() in Python to display the detail of those Toys,
which has status as “ON OFFER” from Toy.dat file.
OR
i. A binary file “ITEMS.DAT” has structure (ID, GIFT, Cost). Write a function to
write more items in ITEM.DAT
ii. Write a function Economic() in Python that would read contents of the file
“ITEMS.DAT” and display the details of those ITEMS whose cost is greater
then 2500.
SECTION-E
34 A music store MySports is considering to maintain their inventory using SQL to store 4
the data. The detail is as follow:
 Name of the database – MySports
 Name of the table – Sports
 The attributes of SPORTS are as follows:
 SCode – character
 SportName – character of size 20
 Noofplayers – numeric
 coachname – character of size 20
Table: SPORTS
SCode SportName No. of players Coachname
S001 Cricket 21 Rahul Dravid
S002 Football 25 Roshan Lal
S003 Hockey 40 Sardar Singh
S004 Cricket 19 Chetan Sharma
S005 Archery 12 Limbaram
S006 Shooting 17 Deepika Kumari
a) Identify the attribute best suitable to be declared as a primary key

b) Write the degree and cardinality of the SPORTS table
c) Insert the following data into the attributes SCode, SportName and No. of
players respectively in the given table SPORTS.
SCode = S007, SportName = “Kabbadi” and Noofplayers = 15
OR
d) Someone wants to delete the column coachname. Which command will he
use from the following:
i) DELETE Coachname FROM SPORTS;
ii) ALTER Coachname FROM SPORTS
iii) ALTER TABLE SPORTS DROP Coachname
iv) DELETE Coachname FROM SPORTS
35 Arjun of class 12 is writing a program to create a CSV file “user.csv” which will 4
contain user name and password for some entries. He has written the following
code. As a programmer, help him to successfully execute the given task.
import _____________ # Line 1

def addCsvFile(UserName,PassWord): # module to write data into a CSV file
f=open('user.csv','w')
newFileWriter = csv._______(f) # Line 2
x=[UserName,PassWord]
newFileWriter.___________(x) # Line 3
f._______() # Line 4
def readCsvFile(): # to read data from CSV file
with open(' user.csv', 'r') as newFile:
newFileReader = csv.reader(newFile)
for row in newFileReader:
print (row[0],row[1])
addCsvFile(“Arjun”,”123@456”)
addCsvFile(“Arunima”,”aru@nima”)
addCsvFile(“Frieda”,”myname@FRD”)
readCsvFile()
a) Name the module he should import in Line 1.

b) Fill in the blank in Line 2 to write data into a csv file.
c) Fill in the blank in Line 3 to write record into a csv file.
d) Fill in the blank in Line 4 to close the file.
part c only.
SECTION A
1. Which of the following is an invalid identifier? 1

(a) true
(b) print
(c) 4ever
(d) While
2. Consider the following expression 1
5+2**6<9+2-16//8
Which of the following will be correct output if the given expression is evaluated?
(a) 127
(b) False
(c) True
(d) Invalid expression
3. State True or False 1
“ There is no conceptual limit to the size of a list.”
4. Which of the following options will not result in an error when performed on types in 1
python where tp = (5,2,7,0,3) ?
(a) tp[1] = 22
(b) tp.append(23)
(c) tp1 = tp+tp*2
(d) tp.sum()
mystr = ‘Python programming is fun!’
mystr = mystr.partition(‘pro’)
mystr=’$’.join(mystr)
(a) Python $programming is fun!
(b) Python $pro$gramming is fun!
(c) Python$ pro$ gramming is fun!$
(d) P$ython $p$ro$gramming is $fun!
6. Which of the following commands is used to open a file “c:\test.txt” for reading and 1
writing data in binary format only.
(a) myfile = open(‘c:\\test.txt’,’rb+’)
(b) myfile = open(‘c:\test.txt\’,’wb’)
1
(c) myfile = open(‘c:\test.txt’,’w+’)
(d) myfile = open(‘c:\\test.txt’,’rb’)
7. Which of the following operators can take wild card characters for query condition? 1
(a) BETWEEN
(b) LIKE
(c) IN
(d) NOT
8. In SQL, which of the following will select only one copy of each set of duplicable rows 1
from a table?
(a) SELECT UNIQUE
(b) SELECT DISTINCT
(c) SELECT DIFFERENT
(d) All of these
9. Given tp = (1,2,3,4,5,6). Which of the following two statements will give the same 1
output?
1. print(tp[:-1])
2. print(tp[0:5])
3. print(tp[0:4])
4. print(tp[-4:])
(a) Statement 1 and 2

(b) Statement 2 and 4
(c) Statement 1 and 4
(d) Statement 1 and 3
10. The primary key is selected from the set of ____________ 1
(a) Composite keys
(b) Determinants
(c) Candidate keys
(d) Foreign keys
11. Which of the following functions do you use to write data in the binary format? 1
(a) write()
(b) output()
(c) dump()
(d) send()
12 In SQL, which command is used to change a table’s structure/characteristics? 1
(a) ALTER TABLE
(b) MODIFY TABLE
(c) CHANGE TABLE
(d) DESCRIBE TABLE
13. Your school has four branches spread across the city. A computer network created by 1
connecting the computers of computer labs of all the school branches, is an example
of _________.
(a) LAN
(b) MAN
(c) WAN
(d) PAN
14. What will be the following expression be evaluated to in Python? 1
print(5*2-5//9+2.0+bool(100))
(a) 11.0
(b) 13.0
(c) 112.0
2
(d) 100
15. Which clause is used with “aggregate functions” ? 1
(a) GROUP BY
(b) SELECT
(c) WHERE
(d) Both (a) and (c)
16. To fetch one record from the result set, you may use <cursor>.______ method: 1
(a) fetch()
(b) fetchone()
(c) fetchsingle()
(d) fetchtuple()
17. Assertion (A); Binary file is faster than text file, so it is mostly used for storing data. 1
Reasoning (R): Text file stores less characters as compared to the binary file.
18. Assertion (A); A variable is still valid if it is not defined inside the function. The values 1
defined in global scope can be used.
Reasoning (R): Python used LEGB rule to resolve the scope of a variable.
SECTION B
19. Sumit is trying to write a program to find the factorial of a number passed to the 2
function and he has written the following code but it’s not working and producing
errors. Help Sumit to correct this and rewrite the corrected code. Also underline the
corrections made.
Def prime (num):

factorial = 1
if num < 0:
print("Sorry, factorial does not exist for negative numbers")
else num == 0
print("The factorial of 0 is 1")
else:
for i in range(1,num + 1):
factorial = factorial*i
print("The factorial of",num,"is",factorial)
20. What is the difference between a hub and a switch? 2
OR
Differentiate between Bus Topology and Star Topology of Networks. What are the
advantages and disadvantages of Star Topology over Bus Topology ?
21. (a) Convert the following for loop into while loop: 2
name = ‘ Karim Benzema’

for index in range(len(name)):
print(name[index].upper(),end=’’)
3
(b) Write the output of the following code given below:
Marks = {‘Sidhi’:65,’Prakul’:62,’Suchitra’:64,’Prashant’:50}
newMarks = {‘Suchitra’:66,’Arun’:55,’Prashant’:49}
Marks.update(newMarks)
for key,value in Marks.items():
print(key,’scored’,value,’marks in Pre Board’,end= ‘ ‘)
if(value<55):
print(‘and needs imporovement’end=’.’)
print()
22. Explain Referential Integrity in a Relational Database Management System. Why DBMS 2
is better than File System.
23. (a) Write full forms of the following: 2
(i) SMTP
(ii) IMAP
(b) What is MAC address?
def change(A):
S=0
for i in range(len(A)//2):
S+=(A[i]*2)
return S
B = [10,11,12,30,32,34,35,38,40,2]
C = change(B)
print('Output is',C)
OR
Data = ["P",20,"R",10,"S",30]
Times = 0
Alpha = ""
Add = 0
for C in range(1,6,2):
Times = Times + C
Alpha = Alpha + Data[C-1]+"$"
Add = Add + Data[C]
print (Times,Add,Alpha)
25. What is the difference between CHAR and VARCHAR ? Write 2-3 differences. 2
OR
Differentiate between a Candidate Key and Alternate Key.
SECTION C
26. (a) Consider the following tables CUSTOMER and TRANSACTION: 1+2
Table: CUSTOMER
ACNO NAME GENDER BALANCE
C1 RISHABH M 15000
C2 AAKASH M 12500
C3 INDIRA F 9750
4
Table: TRANSACTIONS
ACNO TDATE AMOUNT TYPE
C1 2022-07-21 1000 DEBIT
C2 2022-08-31 1500 CREDIT
C3 2022-09-15 2000 CREDIT
SELECT NAME, TDATE, AMOUNT FROM CUSTOMER C, TRANSACTION T WHERE C.ACNO

= T.ACNO AND TYPE = 'CREDIT';
(b) Write the output of the queries (i) to (iv) based on the tables, ACCOUNT and
TRANSACT given below:
Table: ACCOUNT
ANO ANAME ADDRESS
101 Nirja Singh Bangalore
102 Rohan Gupta Chennai
103 Ali Reza Hyderabad
104 Rishabh Jain Chennai
105 Simran Kaur Chandigarh
Table: TRANSACT
TRNO ANO AMOUNT TYPE DOT
T001 101 2500 Withdraw 2017-12-21
T002 103 3000 Deposit 2017-06-01
T003 102 2000 Withdraw 2017-05-12
T004 103 1000 Deposit 2017-10-22
T005 101 12000 Deposit 2017-11-06
(i) SELECT ANO, ANAME FROM ACCOUNT WHERE ADDRESS NOT IN

('CHENNAI', 'BANGALORE');
(ii) SELECT DISTINCT ANO FROM TRANSACT;
(iii) SELECT ANO, COUNT(*), MIN(AMOUNT) FROM TRANSACT GROUP BY
ANO HAVING COUNT(*)> 1;
(iv) SELECT COUNT(*), SUM(AMOUNT) FROM TRANSACT WHERE DOT <=
'2017-06-01';
27. Write the definition of a function ChangeGender() in Python, which reads the contents 3
of a text file "BIOPIC.TXT" and displays the content of the file with every occurrence of
the word 'he' replaced by 'she'. For example,
if the content of the file "BIOPIC.TXT" is as follows :
5
Last time he went to Agra,
there was too much crowd, which he did not like.
So this time he decided to visit some hill station.
The function should read the file content and display the output as follows:
Last time she went to Agra,

there was too much crowd, which she did not like.
So this time she decided to visit some hill station.
OR
Write a method/function BIGWORDS() in Python to read contents from a text file

CODE.TXT, to count and display the occurrence of those words, which are having 5 or
more alphabets.
For example :
ME AND MY FRIENDS
ENSURE SAFETY AND SECURITY OF EVERYONE
The method/function should display

Count of big words is 5
28. (a) Write the outputs of the SQL queries (i) to (iv) based on the relations TRAINS and 3
PASSANGERS given below:
Table: TRAINS
TNO TNAME START END
11096 Ahimsa Express Pune Junction Ahmedabad Junction
12015 Ajmer Shatabdi New Delhi Ajmer Junction
1651 Pune Hbj Special Pune Junction Habibganj
13005 Amritsar Mail Howrah Junction Amritsar Junction
12002 Bhopal Shatabdi New Delhi Habibganj
12417 Prayag Raj Express Allahabad Junction New Delhi
Table: PASSANGERS
PNR TNO PNAME GENDER AGE TRAVELDATE
P001 13005 R N AGRAWAL MALE 45 2018-12-25
P002 12015 P TIWARY MALE 28 2018-11-10
P003 12015 S TIWARY FEMALE 22 2018-11-10
P004 12030 S K SAXENA MALE 42 2018-10-12
P005 12030 S SAXENA FEMALE 35 2018-10-12
P006 12030 P SAXENA FEMALE 12 2018-10-12
(i) SELECT DISTINCT TRAVELDATE FROM PASSENGERS;

(ii) SELECT MIN (TRAVELDATE), MAX (TRAVELDATE) FROM PASSENGERS
WHERE GENDER = 'MALE';
(iii) SELECT START, COUNT(*) FROM TRAINS GROUP BY START HAVING COUNT
(*)>1;
(iv) SELECT TNAME, PNAME FROM TRAINS T, PASSENGERS P WHERE T.TNO =
6
P.TNO AND AGE BETWEEN 40 AND 50;
(b) Write a query/command to display the structure of a table.

29. Define a function ZeroEnding(SCORES) to add all those values in the list of SCORES, 3
which are ending with zero (0) and display the sum.
For example :
If the SCORES contain [200, 456, 300, 100, 234, 678]
The sum should be displayed as 600
30. A list contains following record of a student: 3
[student_name, marks, subject]
Write the following user defined functions to perform given operations on the stack
named ‘status’:
(i) Push_element() - To Push an object containing name and marks of a student who
scored more than 75 marks in ‘CS’ 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:
[“Danish”,80,”Maths”]
[“Hazik”,79,”CS”]
[“Parnik”,95,”Bio”]
[“Danish”,70,”CS”]
[“Sidhi”,99,”CS”]

[“Hazik”,”79”]
[“Sidhi”,”99”]
[“Hazik”,”79”]
[“Sidhi”,”99”]
Stack Empty
OR
Write a function in Python, Push(emp) where , emp is a dictionary containing the

details of employees – {empname:salary}.
The function should push the names of those employees in the stack who have salary
less than 15000. Also display the count of elements pushed into the stack.
For example:
If the dictionary contains the following data:
Employee ={"Sohan”:20000,”Mohan”:9000,”Rohan”:25000,”Aman”:5000}
Mohan
Aman

The count of elements in the stack is 2
SECTION D
7
31. Ayurveda Training Educational Institute is setting up its centre in Hyderabad with four 5
specialised departments for Orthopedics, Neurology and Pediatrics along with an
administrative office in separate buildings. The physical distances between these
department buildings and the number of computers to be installed in these
departments and administrative office are given as follows.
You, as a network expert, have to answer the queries as raised by them in (i) to (iv).
Shortest distances between various locations in metres :
Administrative Office to Orthopedics Unit 55

Neurology Unit to Administrative Office 30
Orthopedics Unit to Neurology Unit 70
Pediatrics Unit to Neurology Unit 50
Pediatrics Unit to Administrative Office 40
Pediatrics Unit to Orthopedics Unit 110
Number of Computers installed at various locations are as follows
Pediatrics Unit 40
Administrative Office 140
Neurology 50
Orthopedics Unit 80
ADMINSISTRATIVE OFFICE
ORTHOPEDICS OFFICE PEDIATRICS UNIT
NEUROLOGY UNIT
(i) Suggest the most suitable location to install the main server of this
institution to get efficient connectivity.
(ii) Suggest the best cable layout for effective network connectivity of the
building having server with all the other buildings.
(iii) Suggest the devices to be installed in each of these buildings for connecting
computers installed within the building out of the following:
• Switch
• Gateway
(iv) Suggest a device/software to be installed in the given network to take care of

data security.
(v) Suggest an efficient as well as economic wired medium to be used within each
unit for connecting computer systems out of the following network cable :
8
Co-axial Cable, Ethernet Cable, Single Pair Telephone Cable.
32. (a) Write the output of the code given below: 2+3
def myfunction(str1):
rstr1 = ‘’
index = len(str1)
while index>0:
if str1[index-1].isalpha():
rstr1+=str1[index-1]
index = index-1
return rstr1
print(myfunction(‘1234abcd’))
(b)
The code given below updates the record of table EMP by increasing salary by
1000Rs. of all those employees who are getting less than 80000Rs.
empno – integer
empname – string
salary – float

Username is root
Password is admin
The table exists in a MYSQL database named abcinfo.

Statement 2 – to update the records as mentioned in the question
import mysql.connector as ms
db1 = ms.connect(host=’localhost’,user=’root’,passwd=’admin’,database=’abcinfo’)
cur = __________ #Statement 1
sql = ‘UPDATE ____ ________________’ #Statement 2
______ _______ #Statement 3
print(‘Data Updated successfully’)
OR
(a) What possible output(s) is/are expected to be displayed on the screen at the
time of execution of the program from the following code ? Also specify the
maximum and minimum value that can be assigned to the variable R when K
is assigned value as 2.
import random
Signal = [ 'Stop', 'Wait', 'Go' ]
for K in range(2, 0, -1):
R = random.randrange(K)
print (Signal[R], end = ' # ')
(a) Stop # Wait # Go #

(b) Wait # Stop #
(c) Go # Wait #
(d) Go # Stop #
9
(b) The code given below inserts the following record in the table employee:
empID – integer
empName – string
salary – float
dept – sting
 Password is admin
 The table exists in a MYSQL database named empdata.
 The details (empID, empName, salary and dept) are to be accepted from
the user.
Student.

def sql_data():
con1=mysql.connect(host="localhost",user="root",password="admin",
database="empdata")
empID =int(input("Enter employee ID :: "))
empName=input("Enter employee name :: ")
salary =float(input("Enter salary :: "))
dept= input("Enter department :: ")
querry="insert into employee
values({},'{}',{},{})".format(empID,empName,salary,dept)
______________________ #Statement 2
______________________ # Statement 3
33. What is the full form of CSV? 5
Write a Program in Python that defines and calls the following user defined functions:
A csv file "PLANTS.csv" has structure [ID, NAME, PRICE].
 WRITEREC() - to input data for records from the user and write them to the file
PLANTS.csv. Each record consists of a list with field elements as ID, NAME and
PRICE to store plant id, plant name and price respectively
 SHOWHIGH() - To read the records of PLANTS.csv and displays those records
for which the PRICE is more than 500.
OR
What is the difference between a text file and a binary file?

Write a Program in Python that defines and calls the following user defined functions:
A csv file "PATIENTS.csv" has structure [PID, NAME, DISEASE].

Write the definition of a function countrec()in Python that would read contents
of the file "PATIENTS.csv" and display the details of those patients who have
the DISEASE as 'COVID-19'. The function should also display the total number
of such patients whose DISEASE is 'COVID-19'.
SECTION E
34. Pravesh is a database administrator for a company and has created the following 1+1+2
table:
10
Table: MOVIEDETAILS
MOVIEID TITLE LANGUAGE RATING PLATFORM
M001 Minari Korean 5 Netflix
M004 MGR Magar Tamil 4 Hotstar
M010 Kaagaz Hindi 3 Zee 5
M011 Harry Potter English 4 Prime Video
M015 Uri Hindi 5 Zee5
M020 Avengers: English 4 Hotstar
Endgame
(a) Identify the degree and cardinality of the table.

(b) Which field should be made the primary key? Justify your answer.
(c) Write the statements to:
(i) Delete the Records where the rating is less than 4
(ii) Update the rating of Movie having ID as M020 to 5.
OR
(c) Write the statements to
(i) Add another column called Recommended having default value of
‘Recommended’.
(ii) Increase the ratings of all Hindi movies by 1.
35. Aaruni Shah is learning to work with Binary files in python using a process knows as 4
pickling/de-pickling. Her teacher has given her the following incomplete code, which is
creating a binary file namely Mydata.dat and then opens , reads and displays the
content of the created files.
________________ #Fill_Line 1
sqlist = list()
for k in range(10):
sqlist.append(k*k)
fout = ______________‘ #Fill_Line2A
____________________ #Fill_Line3
fout.close()
fin = __________________ #Fill_Line2B
______________________ #Fill_Line4
fin.close()
print(“Data from file:”,mylist)
Help her complete the above code as per the instructions given below:
(a) Complete Fill_Line1 so that the required Python library becomes available to
the program.
(b) Complete Fill_Line2A so that the above mentioned binary file is opened for
writing in the file object fout.
Similarly, complete Fill_Line2B, which will open the same binary file for reading
in the file object fin.
(c) Complete Fill_Line3 so that the list created in the code, namely Sqlist is written
in the open file.
(d) Complete Fill_Line4 so that the contents of the open file in the file handle fin
are read in a list namely mylist.
11
part c only.
SECTION A
1. State weather True or False: 1

“ The expression 2**2**3 is evaluated as (2**2)**3.
2. Evaluate the following expression and identify the correct answer. 1
16 - (4 + 2) * 5 + 2**3 * 4
a. 54
b. 46
c. 18
d. 32
3. What gets printed when the following code is executed? 1
names = [‘Hasan’,’Balwant’,’Sean’,’Dia’]
print(names[-1][-1])
(a) h
(b) n
(c) a
(d) Dia
4. Which among the following operators has the highest precedence? 1
a)+
b)%
c)|
d)**
5. Which of the following is not a valid identifier ? 1
a) ABC
b) _num
c) Prints
d)4map
6. To use randint(a,b) which of the following module should be imported ? 1
a)math
b)random
c)CSV
d)randinteger()
1
7. What will be the output when the following code is executed? 1
L= [1,3,5,4,8,9]
print(L[-1:-5])
8. Central computer which is powerful than other computers in the network is called 1
a) Hub
b) Sender
c) Switch
d) Server
9. Method used to force python to write the contents of file buffer on to storage file is 1
a) count()
b) read()
c) flush()
d) True
10. In a range function, which of the following argument is mandatory to pass: 1
a) Start
b) Stop
c) Step
d) All of these
___________ is the protocol used to send emails to the e-mail server and _________
is the protocol used to download mail to the client computer from the server.
(a) SMTP,POP (b) HTTP,POP (c) FTP,TELNET (d) HTTP,IMAP
12 Which of the following is a DDL command? 1
a) SELECT
b) ALTER
c) INSERT
d) UPDATE
13. Which of the following is not a function / method of csv module in Python? 1
a. read()
b. reader()
c. writer()
d. writerow()
14. Syntax of seek function in Python is myfile.seek(offset, reference_point) where 1
myfile is the file object. What is the default value of reference_point?
a. 0
b. 1
c. 2
d. 3
15. Which of the following character acts as default delimiter in a csv file? 1
a. (colon) :
b. (hyphen) -
c. (comma) ,
d. (vertical line) |
__________ is the method used in python while interfacing the SQL with Python to
save the changes permanently to the database while inserting or modifying the
records.
(a) save() (b) commit() (c) final() (d) lock()
2
17. Assertion (A): When passing a mutable sequence as an argument, function modifies 1
the original copy of the sequence.
Reasoning (R): Function can alter mutable sequences passes to it.
18. Assertion (A): with statement can be used to open a file and should be preferred 1
over other ways to open a file.
Reasoning (R): with statement is a block of statement that makes sure the file is
closed in case of any run-time error and buffer is cleared to avoid data loss.
SECTION B
19. Consider the following code written by a programming student. The student is a 2
beginner and has made few errors in the code. You are required to rewrite the code
after correcting it and underline the corrections.
Def swap(d):
n = {}
values = d.values()
keys = list(d.keys[])
k=0
for i in values
n(i) = keys[k]
k=+1
return n
result = swap({‘a’:1,’b’:2,’c’:3})
print(result)
20. What are cookies in a web browser ? Write one advantage and one disadvantage of 2
enabling cookies in a web browser.
OR
What is the difference between client side and server side scripting?
21. (a) Consider the given Python string declaration: 2
mystring = ‘Programming is Fun’
Write the output of: print(mystring[-50:10:2].swapcase())
a,b,c,d = (1,2,3,4)
mytuple = (a,b,c,d)*2+(5**2,)
print(len(mytuple)+2)
22. What do you mean by DDL and DML commands in DBMS? Write examples of each. 2
23. (a) Write the full forms of the following: 2
(i) WLAN
(ii) WWW
(b) What is a hub? What are its types?
24. Predict the output of the following code: 2
3
def my_func(var1=100, var2=200):
var1+=10
var2 = var2 - 10
return var1+var2
print(my_func(50),my_func())
OR
value = 50
def display(N):
global value
value = 25
if N%7==0:
value = value + N
else:
value = value - N
print(value, end="#")
display(20)
print(value)
25. Differentiate between a PRIMARY KEY and UNIQUE constraint in SQL with 2
appropriate example.
OR
What is the difference between WHERE and HAVING clause? Can we use them
together in a query?
SECTION C
26. (a) Consider the following tables STORE and SUPPLIERS: 1+2
Table: STORE
ItemNo Item Scode Qty Rate LastBuy
2005 Sharpner 23 60 8 31-Jun-
Classic 09
2003 Ball Pen 0.25 22 50 25 01-Feb-
10
2002 Gel Pen 21 150 12 24-Feb-
Premium 10
2006 Gel Pen 21 250 20 11-Mar-
Classic 09
2001 Eraser Small 22 220 6 19-Jan-
09
2004 Eraser Big 22 110 8 02-Dec-
09
2009 Ball Pen 0.5 31 180 18 03-Nov-
09
4
Table: SUPPLIERS
Scode Sname
21 Premium Stationers
23 Soft Plastics
22 Tetra Supply
SELECT * FROM STORE JOIN SUPPLIERS ON STORE.Scode = SUPPLIERS.Scode;
(b) Write the output of the queries (i) to (iv) based on the tables, ITEM and
CUSTOMER given below:
Table: ITEM
I_ID ItemName Manufacturer Price
PC01 Personal ABC 35000
Computer
LC05 Laptop ABC 55000
PC03 Personal XYZ 32000
Computer
PC06 Personal COMP 37000
Computer
LC03 Laptop PQR 57000
Table: CUSTOMER
C_ID CustomerName City I_ID
01 N Roy Delhi LC03
06 H Singh Mumbai PC03
12 R Pandey Delhi PC06
15 C Sarma Delhi LC03
16 K Agarwal Bangalore PC01
(i) SELECT DISTINCT City FROM Customer;

(ii) SELECT ItemName, MAX(Price), Count(*) FROM Item GROUP BY
ItemName;
(iii) SELECT CustomerName, Manufacturer FROM Item,Customer WHERE
Item.I_ID = Customer.I_ID;
(iv) SELECT ItemName,Price*100 FROM Item WHERE Manufacturer =
‘ABC’;
27. Write a method in python to read lines from a text file INDIA.TXT, to find and 3
display the occurrence of the word “INDIA” or “India”.
For example:
5
__________________________________________________________________
INDIA is a famous country all over the world.
Geographically, India is located to the
south of Asia continent. India is a high
population country and well protected
from all directions naturally.
India is a famous country for
its great cultural and traditional
values all across the world.
__________________________________________________________________
The output should be 4
OR
Write a method/function BIGLINES() in Python to read lines from a text file

CONTENT.TXT, and display those lines, which are bigger than 20 characters.
For example :
Stay positive and happy

Work hard and dont give up hope
Be open to criticism and keep learning
Surround yourself with happy, warm and genuine people
The method/function should display
Be open to criticism and keep learning

Surround yourself with happy, warm and genuine people
28. a) Write the outputs of the SQL queries (i) to (iv) based on the relations SENDER and 3
RECIPIENT below:
Table: SENDER
SenderID SenderName SenderAddress SenderCity
ND01 R Jain 2, ABC Appts New Delhi
MU02 H Sinha 12, Newtown Mumbai
MU15 S Jha 27/A, Park Street Mumbai
ND50 T Prashad 122-K, SDA New Delhi
Table: RECIPIENT
RecID SenderID RecName RecAddress RecCity
KO05 ND01 R Bajpayee 5, Central Avenue Kolkata
ND08 MU02 S Mahajan 116, A Vihar New Delhi
MU19 ND01 H Singh 2A, Andheri West Mumbai
MU32 MU15 P K Swamy B5, C S Terminus Mumbai
ND48 ND50 S Tripathy 13, B1 D, Mayur Vihar New Delhi
(i) SELECT DISTINCT SenderCity FROM Sender;

6
(ii) SELECT A.SenderName, B.RecName FROM Sender A, Recipient B WHERE
A.SenderID = B.SenderID AND B.RecCity = 'Mumbai';
(iii) SELECT RecName, RecAddress FROM Recipient WHERE RecCity NOT IN
("Mumbai', 'Kolkata');
(iv) SELECT RecID, RecName FROM Recipient WHERE SenderID = 'MU02' OR
SenderID = 'ND50';
29. Write a Python function SwitchOver(Val) to swap the even and odd positions of the 3
values in the list Val.
Note : Assuming that the list has even number of values in it.
For example :
If the list Numbers contain
[25,17,19,13,12,15]
After swapping the list content should be displayed as

[17,25,13,19,15,12]
30. Write the definition of a user defined function PushNV(N) which accepts a list of 3
strings in the parameters N and pushes all strings which have no vowels present in it,
into a list named NoVowel.
Write a program in python to input 5 words and push them one by one into a list
named All.
The program should then use the function PushNV() to create a stack of words in the
list NoVowel so that it stores only those words which do not have any vowels in it,
from the list All.
Thereafter , pop each word from the list NoVowel and display the message
“EmptyStack”
For example:
If the words accepted and pushed into the list All are
[‘DRY’,’LIKE’,’RHYTHM’,’WORK’,’GYM’]
Then the stack NoVowel should store

[‘DRY’,’RHYTHM’,’GYM’]
And the output should be displayed as
GYM RHYTHM DRY EmptyStack
OR
Write the definition of a user defined function Push3_5(N) which accepts a list of
integers in a parameter N and pushes all those integers which are divisible by 3 or
7
divisible by 5 from the list N into a list named Only3_5.
Write a program in Python to input 5 integers into a list named NUM.
The program should then use the function Push 3_5() to create the stack of the list
Only3_5. Thereafter pop each integer from the list Only3 5 and display the popped
value. When the list is empty, display the message "StackEmpty".
For example:
If the integers input into the list NUM are:
[10, 6, 14, 18, 301
Then the stack Only3 5 should store
[10, 6, 18, 301
And the output should be displayed as
30 18 6 10 StackEmpty
31. Piccadily Design and Training Institute is setting up its centre in Jodhpur with four 5
specialised units for Design, Media, HR and Training in separate buildings. The
physical distances between these units and the number of computers to be installed
in these units are given as follows.
You as a network expert, have to answer the queries as raised by the administrator
as given in (i) to (iv).
Shortest distances between various locations in metres :
Design Unit to Media Unit 60

Design Unit to HR Unit 40
Design Unit to Training Unit 60
Media Unit to Training Unit 100
Media Unit to HR Unit 50
Training Unit to HR Unit 60
Number of computers installed at various locations are as follows :
Design Unit 40
Media Unit 50
HR Unit 110
Training Unit 40
8
i) Suggest the most suitable location to install the main server of this institution to
get efficient connectivity.
(ii) Suggest by drawing the best cable layout for effective network connectivity of the
building having server with all the other units.
(iii) Suggest the devices to be installed in each of these buildings for connecting
computers installed within each of the units out of the following :
Modem, Switch, Gateway, Router
(iv) Suggest an efficient as well as economic wired medium to be used within each
unit for connecting computer systems out of the following network cable :
Co-axial Cable, Ethernet Cable, Single Pair Telephone Cable.
(v) Suggest a protocol that shall be needed to provide Video Conferencing solution
between Jodhpur and HQ which is situated in Delhi.
32. (a) Write the output of the code given below: 2+3
def ChangeVal(M,N):
for i in range(N):
if M[i]%5 == 0:
M[i] //= 5
if M[i]%3 == 0:
M[i] //= 3
L=[25,8,75,12]
ChangeVal(L,4)
for i in L :
print(i, end='#')
(b) The code given below is trying to delete the record of table category of
database items that have the name = ‘Stockable’

Username is learner
Password is fast

Statement 2 – to delete the records as mentioned in the question
Statement 3- to save the changes permanently in the database
import mysql.connector as ms
9
db1 =
ms.connect(host=’localhost’,user=’learner’,passwd=’fast’,database=’items’)
cur = _ ____ #Statement 1
sql = ‘DELETE ____ ________________’ #Statement 2
cur.execute(sql)
______ _______ #Statement 3
print(‘Data Updated successfully’)
OR
(a) Find the output of the following code:
Name="PythoN3.1"
R=""
for x in range(len(Name)):
if Name[x].isupper():
R=R+Name[x].lower()
elif Name[x].islower():
R=R+Name[x].upper()
elif Name[x].isdigit():
R=R+Name[x-1]
else:
R=R+"#"
print(R)
(b) The code given below reads the following record from the table named
teacher and displays only those records whose year of retirement is in 2022.
empcode – integer
Name – string
post – integer
dateofretire – integer
Username is root
Password is kvs
The table exists in a MYSQL database named school.

Statement 1 – to import the required modules and give alias as ms
Statement 2 – to execute the query that extracts records of those teachers whose
year of retirement is 2022. Consider the date format to be ‘YYYY-MM-DD’
Statement 3- to fetch all the data from the cursor instance
import ______ as ______ #Statement 1

con1=ms.connect(host="localhost",user="root",password="kvs", database="school")
mycursor= con1.cursor()
print("Teachers about to retire in 2022 are: ")
_________________________ #Statement 2
data=__________________ #Statement 3
for i in data:
print(i)
print()
33. What is the difference between ‘w’ and ‘a’ file modes used in the open() function? 5
Write a program in python that defines and calls the following user defined
10
functions:
(I) addCsvFile(UserName,Password) – To accept and add the login details of a
user into the CSV file ‘login.csv’. Each record consist of a list with field
elements as [id,pass] to store Username and password respectively.
(II) checkDetails(username,pass) – To check the login details passed to the
finction from the file. If the details are correct the function returns True
otherwise it returns False.
OR
Name the methods used to read and write the data in a binary file.
Write a program in python that defines and calls the following user defined
functions:
(i) insertData() – To accept and add data of a customer and add it to a csv file
‘customerData.csv’. Each record should contain a list consisting
customername,mobileno,dateofPurchase,itempurchased.
(ii) frequency (name) – To accept the name of a customer and search how
many times the customer has purchased any item. The count and return
the number.
SECTION E
34 Consider the following table HOSPITAL. Answer the questions that follows the table:
Table: HOSPITAL
No. Name Age Department Dateofadm Charges Sex
1 Arpit 62 Surgery 21/01/98 3000 M
2 Zarina 22 ENT 12/12/97 2000 F
3 Kareem 32 Orthopaedic 19/02/98 1500 M
4 Arun 12 Surgery 11/01/98 3000 M
5 Zubin 30 ENT 12/01/98 1500 F
6 Ketaki 16 ENT 24/02/98 2000 M
7 Ankita 29 Cardiology 20/02/98 10000 F
8 Zareen 45 Cardiology 14/07/99 1400 F
9 Kushi 19 Gynaecology 20/01/22 1800 F
10 Shilpa 23 Nuclear 19/05/22 2500 F
Medicine

(i) Identify the columns which can be considered as candidate keys.
(ii) What is the degree and cardinality of the above table.
(a) Delete the record where the Name starts with ‘Z’
(b) Modify the Charges of Ankita from 10000 to 1000.
OR
(a) To check the structure of the given table.
(b) To increase the age of everyone by 2 years.
35 Sunil is a Python programmer. He has written the following incomplete code, which
11
takes a students details (rollnumber,name
import pickle
sturno = int(input("Enter roll number :"))

stuname = input("Enter name:")
stumarks = float(input("Enter marks :"))
Stul = {"RollNo. ":sturno, "Name": stuname, "Marks":stumarks}
with ______________________ as fh: # Fill_Line 1
_____________________ # Fill_Line 2
___________________ as fin: #Fill_Line 3
________________________ #Fill_Line 4
print(Rstu)
if Rstu["Marks"] >= 85:

print("Eligible for merit certificate")
else:
print("Not eligible for merit certificate")
Help Sunil to complete the code as per the following instructions.
(a) Complete Fill_Line1 so that the mentioned binary file is opened for writing in
fh object using a with statement.
(b) Complete Fill Line2 so that the dictionary Stul's contents are written on the
file opened in step (a).
(c) Complete Fill_Line3 so that the earlier created binary file is opened for
reading in a file object namely fin, using a with statement.
(d) Complete Fill_Line4 so that the contents of open file in fin are read into a
dictionary namely Rstu.
12
SAMPLE PAPER SET-10
Class: XII Session SUBJECT : Computer Science(083)
TIME : 3 HOURS MM : 70
1. This question paper contains five sections, Section A to E
3. Section A have 18 questions carrying 01 marks each.
4. Section B has 07 very Short Answer type question carrying 02 marks each
5. Section C has 05 Short Answer type question carrying 03 marks each.
6. Section D has 03 Long Answer types question 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
8. All Programming questions are to be answered using python Language only.
SECTION A
1 Which of the following in not a valid variable name in python? 1
(i) Peacock (iii) Pea Cock
(ii) Peacock5 (iv) Peacock_
2 Write the type of tokens from the following: 1

(i) if (ii) roll_no
3. If the following code is executed, what will be the output of the following 1
code?
name="IlovemyCountry"
print(name[3:10])
4. Find and write the output of the following Python code: 1

def Change(P ,Q=40):
P=P+Q
Q=P-Q
print( P,"#",Q)
return (P)
R=100
S=200
R=Change(R,S)
print(R,"#",S)
S=Change(S)
1
5. Select the correct output of the following code
Fp.seek(5,1)
a) Move file pointer five character ahead from the current postion
b)Move file pointer five character ahead from the beginning of a file
c)Move file pointer five character behind from the current postion
d)Move file pointer five character behind ahead from the end of a file
6. Select the correct method to write a list of line to a file 1

a) write(list)
b)writelines(list)
c)writelist(list)
d) None
7. Select the correct output of the following string operations 1
mystring = “Pynative”
stringList = [ “abc”, “Pynative”,”xyz”]
print(stringList[1] == mystring)
print(stringList[1] is mystring)
a) True b) False c) False d) Ture

False True Flase Ture
8. What will be the output of the following Python code snippet? 1
D1={“John”:40 , “Peter” : 45}

D2= { “John”: 466, “Peter” : 45}
Print(D1>D2)
a) Ture b) False c) Error d) Non

9 Write a python command to create list of keys from a dictionary. 1
dict={‘a’:’A’, ‘b’:’B’, ‘c’:’C’, ‘d’:’D’}
a)dict.keys() b)keys() c) key.dict() d) None of these
10. The role of the statement 1

‘cursor=db.cursor’ is:
a)Create an instance of a cursor
b)Move cursor row wise
c) Connects cursor to database
d) Prepare cursor to move
11. ………………..is a set of attributes in a relation , for which no two tuples in a 1

relation state have the same combination of values.
a) Super Key
b) Candidate Key
c) Primary Key
d) All of the above
12 Evaluate the following expressions: 1

10 > 5 and 7 > 12 or not 18 > 3
a) Ture b) Flase C) 25 D) 0
13 The SELECT statement when combined with ………….clause,return records 1

without repletion.
a) NULL
b)UNIQUE
c)DESCRIBE
d) DISTINCT
14 Consider the following query: 1

SELECT name FROM class WHERE subject……NULL;
Which comparison operator may be used to fill the blank space in above
query?
a) = b)LIKE c)IS d)IS NOT
15. Which portion of the URL below records the directory or folder of the 1
desired resource?
https://www.nishantsingh.com/ghagwal/pgt.htm
a) http b) ghagwal c) www.nishantsingh.com d) pgt.htm
16 …………….Protocol is used to send the email to another email user. 1
a) FTP b)POP c) IMAP d) SMTP
Q17 and Q18 are ASSERTION AND REASONING based questions. Mark the correct choice as
17 Assertion (A):- Key word arguments are related to function calls. 1
Reasoning(R ):- When you use keyword arguments in funation call, the caller
identifies the arguments by the parameter name.
18 Assertion(A) : The tell method will stores/get the current location of the file 1
pointer.
Reasoning(R): Python seek method returns the current position of the file
read/write pointer with the file.
Section B
19. Mr. Akash has written a code , His code is having errors , Rewrite the correct code 2
and underline the correction s made.
5x=input(“Enter a number”)
If(abs(x)=x):
Print(“You Entered a positive number..”)
Else:
x=x-1
print(“Number made positive:”x)
20 Differentiate between default parameter(s) and keyword parameter(s) with a 2

suitable example for each.
Or
What is the difference between Local Variable and Global Variable?
21 a) If the following code is executed, what will be the output of the following 1
code?
mystr1 = ‘Sequence with labels’
mystr2 = ‘$’
print(mystr2*6+mystr1+mystr2*5)
1
b) What will be the output of the following code snippet?
init_tuple_a =( 'a', '3’)
init_tuple_b = ('sum', '4')
print (init_tuple_a + init_tuple_b)
22. What is the purpose of the following clauses in a select statement? 2

a) ORDER BY b) HAVING
23. What is the full forms of the following : 2

a) IMAP b) POP
24. Predict the output of the python code given below:- 2
def changedata(str1):
length=len(str1)
temp=""
else:
temp=temp+'^'
print(temp)
changedata("Kvs_nishant@2023")
25 Study the following program and select the possible output(s) from options (i) to 2
(iv) following it. Also, write the maximum and the minimum values that can be
assigned tovariable Y.
import random
X= random.random()
Y= random.randint(0,4)
print(int(X),":",Y+int(X))
(i) 0 : 0 (ii) 1 : 6 (iii) 2 : 4 (iv) 0 : 3
Section c
26 Write the outputs of the SQL queries (i) to (iii) based on the given tables: 3
Watches
Watchid Watch_name Price Type Qty_store
W001 High Time 10000 Ladies 100
W002 Life Time 15000 Gents 150
W003 Wave 12500 Ladies 200
W004 High Fashion 13500 Ladies 135
W005 Golden Time 14000 Unisex 150
Sale
Watchid Qty_sold Quarter
W001 10 1
W002 8 2
W003 15 1
W001 12 3
W003 11 2
W004 9 1
W002 15 1
i.SELECT MAX (PRICE), MIN(QTY_STORE) FROM WATCHES;
ii.SELECT QUARTER, SUM(QTY SOLD) FROM SALE GROUP BY QUARTER;
iii. SELECT WATCH_NAME, QTY_STORE, SUM (QTY_SOLD) FROM WATCHES W,
SALE S WHERE W. WATCHID = S.WATCHID GROUP BY S.WATCHID;
27 Assume that a text file named TEXT1.TXT already contains some text written 3
into it ,write a function named COPY(),that reads the file TEXT1.TXT and create a
new file named TEXT2.TXT ,which shall contain only those words from the file
TEXT1.TXT which don’t start with an uppercase vowel(i.e. with ‘A’,’E’,’I’,’O’,’U’)
,for example if the file TEXT1.TXT contains
He can appoint any member of the Lok Sabha
then the file TEXT2.TXT shall contain
He can member of the Lok Sabha
OR
write a function countmy() in python to read the text file "DATA.TXT" and
count the number of times "my" occurs in the file
28 Write the outputs of the SQL queries (i) to (iii) based on the relations VEHICLE 3
and TRAVEL given below:
VCODE VEHICLETYPE PERKM
V01 VOLVO BUS 150
V02 AC DELUX BUS 125
V03 ORDINARY BUS 80
V04 CAR 18
V05 SUV 30
NOTE: PERKM is fright charges per kilometer
Table: TRAVEL
CNO CNAME TRAVELDATE KM VCODE NOP
101 K. Niwal 2015-12-13 200 V01 32
103 Fredrick Sym 2016-03-21 120 V03 45
105 Hitesh Jain 2016-04-23 450 V02 42
102 Ravi Anish 2016-01-13 80 V02 40
107 John Malina 2015-02-10 65 V04 2
104 Sahanubhuti 2016-01-28 90 V05 4
106 Ramesh Jaya 2016-04-06 100 V01 25
NOTE: KM is Kilometres travelled and NOP is number of passengers travelled in

vehicle.
a) SELECT COUNT(*), VCODE FROM TRAVEL
GROUP BY VCODE HAVING C0UNT(*)>1;
b)SELECT VCODE,CNAME,VEHICLETYPE FROM TRAVEL A, VEHICLE B
WHERE A.VC0DE=B.VCODE AND KM<90;
c)SELECT DISTINCT VCODE FROM TRAVEL;
29 3
Write a python Function that accepts a string and calculates the number of
uppercase letters and lowercase letters.
Sample String : Python ProgrammiNg
Expected Output:
Original String : Python ProgrammiNg
No. of Upper case characters : 3
No. of Lower case characters :14
30 Write PushOn(Student) and Pop(Student) methods/functions in Python to add a 3

new Student and delete a Student from a list of Student Name, considering
them to act as push and pop operations of the Stack data structure.
31 Hindustan connecting world Association is planning to start their offices in four 5
major cities in India to provide regional IT infrastructure support in the field of
Education And Culture . The company has planned to setup their head office in
New Delhi in three location and have name their New Delhi office as “Sales
Office”, “Head Office” and “Tech Office”. The company’s regional offices are
loacated in “Coimbatore”, “Kolkata”, and “Ahmedabad”.
A rought layout of the same ia as follows
NEW DELHI
Head
INDIA Tech
Office
Sales Office
Office
eee
Kolkata
Ahmedabad Coimbat
ore
Approximate distance between these office as per network survey team is as

follows:
Place From Place TO Distance

Head Office Sales Office 10 km
Head Office Tech Office 70 mtr
Head Office Kolkata Office 1291 Km
Head Office Ahmedabad Office 790 Km
Head Office Coimbatore Office 1952 Km
In continuation of the above , the company expert have planned to install the
following number of computer in each of their offices:
Head Office 100

Sales Office 20
Tech Office 50
Kolkata Office 50
Ahmedabad Office 50
Coimbatore Office 50
a) Suggest network type for connecting each of the following set of their offices:
 Head Office and Tech Office
 Head Office and Coimbatore Office
b) Which device you will suggest to be produced by the company for connecting all the
computers with in each of their offices out of the following device?
i) Switch/Hub ii)Modem iii)Telephone
c) Which of the following communication media, you will suggest to be procured by th
company for connecting their local offices in New Delhi for very effective and fast
communication.
i) Telephone Cable ii) Optical fibre iii) Ethernet cable
d) Suggest a Cable /Wiring layout for connecting the company’s local offices located in
New Delhi . Also, suggest an effective method /technology for connecting the company
‘s regional office at “Kolkata”,”Coimbatore and “Ahmedabad”.
32 Write a function in python, PushEl(element) and MakeEl(element) to add a new 5
element and delete a element from a List of element Description, considering
them to act as push and pop operations of the Stack data structure .
Or
Write a function in Python PUSH(A), where A is a list of numbers. From this list
push all even numbers into a stack implemented by using a list. Display the stack
if it has at least one element, otherwise display appropriate error message
33 Write a function countVowels() in Python, which should read each character of a 5
text file
“myfile.txt”, count the number of vowels and display the count.
Example:If the “myfile.txt” contents are as follows:
This is my first class on Computer Science.
The output of the function should be: Count of vowels in file: 10
Section E
34 Consider the following tables MobileMaster and MobileStock. Write SQL 5

commands for the statements (i) to (v) .
Table: MobileMaster
M_Id M_Company M_Name M_Price M_Mf_Date
MB001 Samsung Galaxy 4500 23-Jan-2004
MB003 Nokia N1100 2250 12-Dec-2003
MB004 Micromax Unite3 4500 14-Feb-2004
MB005 Sony XperiaM 7500 01-Jan-2004
MB006 Oppo SelfieEx 8500 19-Mar-2004
Table: MobileStock
S_Id M_Id M_Qty M_Supplier
S001 MB004 450 New Vision
S002 MB003 250 Praveen Gallery
S003 MB001 300 Classic Mobile Store
S004 MB006 150 A-one-Mobiles
S005 MB003 150 The Mobile
S006 MB006 50 Mobile Centre
i)Display the Mobile company, Mobile Name & Price in descending order of their
manufacturing date.
ii)List the details of mobile whose name starts with s
iii)Display the mobile supplier and quantity of all mobiles except MB003.
iv) Display the name of mobile company having price between 3000 and 5000
v) Display the name of company, supplier and Price by joining the joining the two
tables where price is more than 5000.
35 Pushpa writing a program to create a CSV file “item.csv” which will contain item 5
name, Price and quantity of some entries. He has written the following code. As
a programmer, help him to successfully execute the given task.
import _____________ # Line
def addInCsv(item,price,qty): # to write / add data into the CSV file
f=open(' item.csv','________') # Line
csvFileWriter = csv.writer(f)
csvFileWriter.writerow([item,price,qty])
f.close()
#csv file reading code
defreadFromCsv(): # to read data from CSV file
with open(' item.csv','r') as csvFile:
newFileReader = csv._________(csvFile) # Line
print (row[0],row[1],row[2])
csvFile.______________ # Line
addInCsv('Note Book',45,100)
addInCsv('Text Book',60,150)
addInCsv('Ball Pen',10,100)
addInCsv('Pencil', 5,200)
readFromCsv() #Line
(a) Name the module he should import in Line 1.
(b) In which mode, Pushpa should open the file to add data into the file
(c) Fill in the blank in Line 3 to read the data from a csv file.
(d) Fill in the blank in Line 4 to close the file.
(e) Write the output he will obtain while executing Line 5.
SAMPLE PAPER SET-11
Class: XII Session SUBJECT : Compute Science(083)

7. Section E has 02 questions carrying 04 marks each. One internal choice is given
SECTION A
1. State True or False 1
The value of the expression 5/(6*(4-2)) and 5/6*(4-2) is the same.
2. Which of the following is the data type of value, returned by input( ) method in 1
Python?
(a ) Boolean (b) String (c) Int (d) Float
3. Given the following dictionaries 1
Dict1={‘Tuple’:’immutable’,’List’:’mutable’,’Dictionary’:’mutable’,’String’:’immu
table’}
Which of the following will delete key:value pair for key=‘Dictionary’ in the
above mentioned dictionary?
a. del Dict1[‘Dictinary’]
b. Dict1[‘Dictionary’].delete( )
c. delete (Dict1.[“Dictionary”])
d. del(Dict1.[‘Dictionary’])
4. Consider the given expression: 1
print(2**5+8//3*7-2)
Which of the following will be correct output if the given expression evaluated?
(a) 44
(b) 34
(c) 42
(d) 36

L1, L2 = [10, 23, 36, 45, 78], [ ]
for i in range :
L2.insert(i, L1.pop( ) )
print( L1, L2, sep=’@’)
(A) [78, 45, 36, 23, 10] @ [ ]

(B) [10, 23, 36, 45, 78] @ [78, 45, 36, 23, 10]
(C) [10, 23, 36, 45, 78] @ [10, 23, 36, 45, 78]
(D) [ ] @ [78, 45, 36, 23, 10]
6 If a file is opened for writing, which of the following statement is false 1

(a) If the file exists at the specified path, the file is successfully opened.
(b) Python gives error if the file does not exit at the specified path.
(c) The existing contents of the file will be erased as soon as you open the file.
(d) Python will create a new empty file at the specified path if the file does not
exist at the specified path.
7 A column added via ALTER TABLE command initially contains _______ value for 1
all existing rows.
8 Which of the following is the correct command to delete an attribute Salary 1
from relation Employee.
(A) DELETE SALARY FROM EMPLOYEE;
(B) ALTER TABLE EMPLOYEE DELETE SALARY;
(C) ALTER TABLE EMPLOYEE DROP SALARY;
(D) DROP COLUMN SALARY FROM EMPLOYEE;
9 To include integrity constraint in an existing relation, we should use 1
______________ statement.
(A) UPDATE TABLE

(B) ALTER TABLE
(C) MODIFY TABLE
(D) EDIT TABLE
10. The operator ___________ when used with a string and an integer gives an 1
error.
11 What is the significance of the seek method ? 1
(A) It seeks the absolute path of the file.
(B) It tells the current byte position of the file pointer within the file.
(C) It places the file pointer at a desired offset within the file
(D) It seeks the entire content of the file.
12 The sysntax of seek( ) method in Python is :- 1
File.object.seek(offset [, reference point])
In the above syntax the offset refers to :-
(A) Specifying Initial position of the file pointer.
(B) Specifying number of bytes.
(C) Specifying file opening mode.
(D) None of the above
13. The _____________ is a networking device that regenerates or recreates a 1
weak signal into its original strength and form.
14 What will be the output of the following Python code ? 1
T1= ( )
T2=T1 * 2
print(len(T2))
(A) 0
(B) 2
(C) 1
(D) Error
15 All aggregate function except _________ ignore NULL values in order the 1
produce the output.
(A) AVG( )
(B) COUNT( )
(C) COUNT(*)
(D) TOTAL( )
16 To establish a connection between Python and SQL database, connect() 1
method is used. Identify the correct syntax of connect( ) method from the
followings.
(A) Connect(user=”user name”, passwd=”password”, host=”host name”,
database= “database name”)
(B) Connect(host=”host name”, user=”user name”, password=”password”,
(C) Connect(host=”host name”, user=”user name”, passwd=”password”,
(D) Connect(host=”host name”, database= “database name”, user=”user
name”, password=”password”)
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 and R is False.
(D) A is False and R is True.
17 Assertion (A) : A function is a block of organized and reusable code that is used 1
to perform a single related action.
Reason (R) : Function provides better modularity for your application and a
high degree of code reusability.
18 Assertion (A) : Text file stores information in ASCII or Unicode characters. 1
Reason (R) : CSV stands for comma separated value. These files are common
file format for transferring and storing data.
SECTION B
19 Anshika has written a code to calculate the factorial value of a number, but her 2
code is having some errors. Rewrite the correct code and underline the
corrections made.
def Factorial(Num)
1=fact
While num=>0:
fact=fact*num
num=-1
print(“Factorial value is =”,fact)
20. Differentiate between Viruses and Worms in context of networking and data 2
communication threats.
OR
Differentiate between Web server and web browser. Write any two popular
web browsers.
21 (A) Given is a Python List declaration : 1
L1=[11,23,16,28,55,37,61,89]
write the output of the code given below :
print(L1[-3:8])
(B) Given is a Python Dictionary : 1
Lib={“Novel”:152,”Magzine”:20,”Newspaper”:10,”Books”:250}
Write Python statement to delete key:value pair for key=”Novels”.
22 What is the difference between UNIQUE and PRIMARY KEY constraints in an 2
RDBMS.
23 (A) Expand the following terms :- 1
(I) FTP (II) GSM
(B) Danish has to share the data among various computers of his two offices 1
branches situated in the same city. Name the type of network which is being
formed in this process.
24 Predict the output of the Python code given below: 2
def Update(str1):
length=len(str1)
temp=""
else:
temp=temp+'#'
print(temp)
Update("CBSE-2023 Exams")
OR
Mydict={}
Mydict[(1,2,3)]=12
Mydict[(4,5,6)]=20
Mydict[(1,2)]=25
total=0
for i in Mydict:
total=total+Mydict[i]
print(total)
print(Mydict)
25 Define the following terms in context with RDBMS:- 2
(I) Degree (II) Cardinality
OR
Write the full form of DDL and DML. Also write any two examples of DDL and
DML.
SECTION C
26 (A) Consider the following tables – Employee and Department 1+2

EMPLOYEE
Ecode Ename
M01 Bhavya
M02 Krish
S01 Mehul
S03 Sanket
A05 Vansh
H03 Pallavi
DEPARTMENT
Ecode Department
M01 Marketing
S01 Sales
A05 Accounts
H03 HR
SELECT E.Ecode,E.Ename,D. Department FROM EMPLOYEE E,
DEPARTMENT D WHERE E.Ecode = D.Ecode;
(B) Write the output of the queries (i) to (iv) based on the table PRODUCT and
CUSTOMER given below :
PRODUCT
P_ID P_Name Manufacturer Price Discount
TP01 Talcum Powder LAK 40
FW05 Face Wash ABC 45 5
BS01 Bath Soap ABC 55
SH06 Shampoo XYZ 120 10
FW12 Face Wash XYZ 95
CUSTOMER
C_ID C_Name City P_ID
01 Cosmetic Shop Delhi TP01
02 Total Health Mumbai FW05
03 Live Life Delhi BS01
04 Pretty Woman Delhi SH06
05 Dreams Delhi TP01
i. SELECT P_Name, count(*) FROM Product GROUP BY P_Name;
ii. SELECT Max(Price), Min(Price) FROM Product;
iii. SELECT Product.P_Name, Client.C_Name FROM Product, Client WHERE

Product.P_ID = Client.P_ID AND Client.City=”Mumbai”;
iv. SELECT P.P_Id, P.P_Name, C.C_Name, C.City, P.Price FROM Product P, Client
C WHERE Product.P_ID = Client.P_ID AND Client.City=”Mumbai” ORDER BY
P.Price DESC.;
27 Write a method COUNT_UPPER() in Python to read lines from Text File 3
“CONTENT.TXT” and display the count of uppercase alphabets in the File.
Example :
If the file contents are as follows:-
All India Senior Secondary Certificate Examination.
The COUNT_UPPER() function should display the output as :

The number of uppercase alphabets in the file :- 6
OR
Write a method COUNT_WORD()in Python to read lines from a text file
“PLEDGE.TXT” and count and display the occurrences of the word “country” in
the file.
Example :-
If the content of the file are as follows :-
India is my country and all Indians are my brothers and sisters. I love my country
and I am proud of its rich and varied heritage. I shall always strive to be worthy
of it.
I shall give respect to my parents, teachers and elders and treat everyone with
courtesy.
To my country and my people, I pledge my devotion. In their well being and
prosperity alone, lies my happiness.
The COUNT_WORD() function should display the output as :
Total Occurrences of word “country” = 3
28 (A) Write the outputs of the SQL queries (i) to (iv) based on the relations CAR 2+1
and OWNER given below:-
CAR
C_code Carname Make Color Capacity Charges
501 Ignis Suzuki Blue 5 14
503 Saltoz Tata White 5 16
502 Innova Toyota Silver 7 18
509 SX4 Suzuki Black 5 20
510 NIOS Hyundai Grey 5 15
CUSTOMER
C_Id Cname C_code
1001 Vansh Sharma 501
1002 Shivanand 509
1003 Tanish Sharma 503
1004 Palak 502
(i) SELECT COUNT(DISTINCT Make) FROM CAR;
(ii) SELECT MAX(Charges), MIN(Charges) FROM CAR;
(iii) SELECT COUNT(*), Make FROM CAR;
(iv) SELECT Carname FROM CAR WHERE Capacity=7;
(B) Write SQL Command to show the list of all the databases.
29 Write a function R_Shift(Arr,n) in Python, which accepts a list Arr of numbers 3

and n is a numeric value by which all elements of the list are shifted to right and
the last element removed should be added in the begining.
Sample Input Data of the list
Arr=[ 1,2,3,4,5,6], n=2
Output
Arr = [5, 6, 1, 2, 3, 4]
30. A List contains following record of a Book : 3

[Book Name, Write Name, Price]
Write the following user defined functions to perform given operations on the
stack named “BOOK” :
(i) Push_Rec( ) – To push the record containing Book name and author
name of Books having price > 500 to the stack.
(ii) Pop_Rec( ) – To pop the objects from the stack and display them. Also
display “STACK UNDERFLOW” when there are no elements in the Stack.
OR
Write a function in Python, Push(Item) where Item is a list containing the details
of Bakery Items – [[Name, Price], [Name, Price], [Name, Price]]
The function should push the names of those items in the Stack who have price
less than Rs. 50. Also display the count of elements pushed into the Stack.
Example:
If the list contains the following items :
l=[['ravi',26],['raman',36], ['chaman',56]]
The Stack should contain :
Ravi
Raman
The output should be :
The number of elements in stack is : 2
31 Rising Sun Corporation is a professional IT company. The company is planning to
set up their new offices in India with its hub at Hyderabad. The company has 03
Block named Conference Block, Finance Block, and Human Resource Block.
Suggest them the best available solutions based on the queries (i) to (v) as
mentioned below :
Block to Clock distance in Meters :
 Human Resource to Conference Block – 55 mtr.
 Human Resource to Finance – 110 mtr
 Conference to Finance – 90 mtr.
No. of computers to be installed in each block :-
 Human Resource – 150
 Finance - 45
 Conference – 75
(i) What will be the most appropriate block, where RSC should plan to 1
house the server?
(ii) Suggest the cable layout to connect al the buildings in the most 1
appropriate manner for efficient communication.
(iii) What will the best suitable connectivity out of the following to 1
connect the offices in Bangalore with its New York based office.
(a) Infrared (b) Satellite Link (c ) Ethernet Cable
(iv) Suggest the placement of the following devices with justification.
(a) Hub / Switch (b) Repeater 1
(v) Which service / protocol will be most helpful to conduct the live
interactions of Experts from New York to Human Resource Block. 1
32 (A) Write the output of the Python code given below : 2+3
a=10
def fun(x=10,y=5):
global a
a=y+x-3
print(a,end="@")
i=20
j=4
fun(i,j)
fun(y=10,x=5)
(B) The code given below inserts th following record in the table Employee:
ECode – Integer
EName – String
Deptt – String
Salary – Float
Note the following to establish connectivity between Python and MYSQL :
 Username is admin
 Password is Hello123
 Database is KVS
 The Department of the employee will be entered by the user in order
to get the list of employees in the department.
Statement 1 – To form the cursor object.
Statement 2 – To execute th command that searches for the employee code in
the table Employee.
Statement 3 – To show all the records returned by the query.
import mysql.connector as con
def Emp_data():
mycon=con.connect(host=”localhost”,user=”admin”,passwd=”Hello123
”,database=”KVS”)
mycursor=__________________________ # Statement 1
Dept=input(“Enter Department name to be searched for =”)
Qry_Str=”Select * from Employee where deptt=”+Dept
_______________________________ # Statement 2
Mydata=__________________________ # Statement 3
for row in Mydata:
print(row)
mycon.close()
OR
(A) Predict the output of the code given below:
x=[1,2,3]
ctr=0
while ctr<len(x):
print(x[ctr]*’#’
for y in x:
print(y*’$ ‘)
ctr+=1
(B) The code give below reads the following record from the table named
“SALES” and update those records who have Sale>50000 in order to
provide commission 4% of Sale amount.
Scode – integer
Sname- String
Saleamt – Float
Commission – Float
Note the following to establish conectivity between Python and MySQL :
 Password is Scott
 Database Name : Company
Write the following missing statements to complete the code :
Statement 2 – to execute the query to update the commission column as 4% of
Saleamount for those records only who have Sale>50000.
Statement 3 – to add the data parmanently in the database.
import mysql.connector as con

def Sale_data():
mycon=con.connect(host=”localhost”,user=”root”,passwd=”Scott”,data
base=”Company”)
mycursor=__________________________ # Statement 1
Qry_Str=”Update SALES set commission = Saleamt*4/100 where
Saleamt>50000;”
_______________________________ # Statement 2
__________________________ # Statement 3
mycon.close()
33 What is a reader object in CSV files? 5
Write a program in Python that defines and calls the following user defined
functions:-
(a) AddUser() – to accept and the username and password to a CSV file
“Users.CSV”. Each record consists of a list with field elements as UID and
PWD to store User ID and Password respectively.
(b) Search() – To search and display the password of the given User ID.
OR
(a) What is a CSV file?

(b) Write a program in Python that defines and calls the following user
defined functions:
WriteCSV() – to accept RollNo, Name and Marks of a student from the
user and Write it to CSV file.
ReadCSV() – To read the contents from the CSV file and display it to the
user.
34. Karan creates a table GAMES with a set of records to store the details of Games 1+1+2
like Name of Game, Type of Game, Prize Money etc. as given below. After
creation of the table, he has entered some records as shown below :
GCode GName Type PrizeMoney ScheduleDate
101 Badminton Outdoor 15000 10-Oct-2021
102 Chess Indoor 20000 01-JUL-2020
103 Table Tennis Indoor 10000 01-Mar-2022
104 Carom Board Indoor 8000 15-AUG-2023
105 Cricket Outdoor 25000 01-DEC-2022
Based on the data given above answer the following questions :-

(i) Identify the column which could be considered as PRIMARY KEY.
(ii) What will be the degree and Cardinality of the above table?
(iii) Write the statement to :
(a) Increase the prize money by 20% for all the Games.
(b) List the name of the Game and Prize Money whose Game name
starts with ‘C’.
(iii) Write statement to :-
(a) Add a new column NoOfPlayers with data type as integer.
(b) Print the sum of the column PrizeMoney.
35 Vanshika is learning Python and working with Binary Files. Her teacher has given 4
her the following incomplete, which is creating a binary file “Student.dat” which
contains student’s details (RNo, Name and Marks) in the form of List.She now
has to open the file, search for the Roll No., which will be entered by the user
and display the Student’s Details, if roll no. found otherwise print the message
“Roll Number Not Found”.
The content of the List are : [Rollno, Name, Marks]
As a Python programmer, help her to complete the following code based on the
requirement given below:
import ___________ # Statement 1
def ReadData() :
rec=[]
fin.open(________________________) # Statement 2
found=False
rno=int(input(“enter the Roll No. of the Student=”))
while True:
try :
rec=__________________ # Statement 3
if ______________ : # Statement 4
found=True
print(“Student Roll Number=”,rec[0])
print(“Student Name=”,rec[1])
print(“Total Marks obtained=”,rec[2])
except:
print(“File not found”)
if found==False:
print(“Record Not Found”)
fin.close() 1
(i) Which module should be imported in the program? (Statement 1)
(ii) Write the correct statement to open the file Student.dat in the 1
required mode. (Statement 2)
(iii) Write the correct statement to read the data from the binary file and 1
store it in rec. (Statement 3)
(iv) Write the correct condition to match the Roll no of the student in the 1
file with the Roll no. entered by the user.
SAMPLE PAPER SET-12
Class: XII Session SUBJECT : Computer Science(083)
---------------------------------------------------------------------------------------------------------------------------------------
------------General Instructions:
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c
only.
---------------------------------------------------------------------------------------------------------------------------------------
-----------
SECTION-A
Q.1 Which of the following are in-valid operators in Python? 1
(A) += (B) ^ (C) =+ (D) &&
Q.2 Which function is used to remove the given characters from trailing end i.e. right end of a string? 1
(A) strip( ) (B) remove( ) (C) lstrip( ) (D) rstrip( )
Q.3 Predict the output of following python code. 1
SS="PYTHON"
print( SS[:3:])
(A) THON (B) PYT (C) PYTH (D) HON
Q.4 A Python List is declared as Stud_Name = ['Aditya', 'aman', 'Aditi','abhay'] 1
What will be the value of min(Stud_Name)?
(A) abhay (B) Aditya (C) Aditi (D) aman
Q.5 Choose the correct output of following code: 1
Tup=(100)
print(Tup*3)
(A) (300,) (B) (100,100,100) (C) Syntax Error (D) 300
Q.6 In a stack, if a user tries to remove an element from empty stack it is called _________ 1
(A) Underflow (B) Empty (C) Overflow (D) Blank
Q.7 Which method is used for object serialization in Python? 1
(A) Pickling (B) Un-pickling (C) Merging (D) None of the above
Q.8 Which types of arguments/parameters supports by Python? 1
PS-SP-QP-XII-CS-22-23 1 | Page
(A) Positional Argument (B) Default Arguments
(C) Keyword (or named) Arguments (D) All of Above
Q.9 If a function in python does not have a return statement, which of the following does the function 1
return?
(A) int (B) float (C) None (D) Null
Q.10 A________is a set of rules that governs data communication. 1
(A) Forum (B) Protocol (C) Standard (D) None of the above
Q.11 Select correct collection of DDL Command? 1
(A) CREATE, DELETE, ALTER, MODIFY (B) CREATE, DROP, ALTER, UPDATE
(C) CREATE, DROP, ALTER, MODIFY (D) CREATE, DELETE, ALTER, UPDATE
Q.12 Which statement is used to display the city names without repetition from table Exam? 1
(A) SELECT UNIQUE(city) FROM Exam; (B) SELECT DISTINCT(city) FROM Exam;
(C) SELECT PRIMARY(city) FROM Exam; (D) All the above
Q.13 Ronak want to show the list of movies which name end with ‘No-1’. Select the correct query if table 1
is MOVIE and field attribute is Movie_Name.
(A) SELECT Movie_Name FROM MOVIE WHERE Movie_Name = ‘%No-1’;
(B) SELECT Movie_Name FROM MOVIE WHERE Movie_Name = ‘No-1%’;
(C) SELECT Movie_Name FROM MOVIE WHERE Movie_Name LIKE ‘%No-1’;
(D) SELECT Movie_Name FROM MOVIE WHERE Movie_Name LIKE ‘No-1%’;
Q.14 Which Constraint not allow to enter repeated values in the table? 1
(A) PRIMARY KEY (B) UNIQUE (C) BOTH A and B (D) None of
above
Q.15 COMMIT command is belongs to 1
(A) DDL Command (B) DML Command (C) TCL Command (D) None of the above
Q.16 Which function is used to create a cursor in Python – SQL connectivity? 1
(A) fetch() function (B) execute() function (C) connect() function (D) curse()
function
Q.17 Assertion (A):- In stack, program should check for Underflow condition, before executing the pop 1
operation.
Reasoning (R):- In stack, underflow mean there is no element available in the stack or stack is an
empty stack.
Q.18 Assertion (A):- The readlines() method in python reads all lines from a text file. 1
Reasoning (R):- The readlines() method returns the tuple of lines(string).
SECTION-B
Q.19 A student has written a code to print a pattern of even numbers with equal intervals. His code is 2
having errors. Rewrite the correct code and underline the corrections made.
def pattern(start=0, end, interval):
for n in range(start: end, interval):
if(n%2==1):
print(n)
else
pass
x=int(input("Enter Start Number: "))
y=int(input("Enter End Number: "))
z=int(input("Enter Interval: "))
pattern(x,y,z)
Q.20 (A) line="T-20 Cricket World Cup 2022" 2
x=line[::-1]
print(a[0:4:1][::-1])
(B)
India={"Animal":"Tiger","Bird":"Peacock","Flag":"Tri-Color"}
India["Capital"]="New Delhi"
print(India.values())
Q.21 Find and write the output of the following python code: 2
def Alter(P=15,Q=10):
P=P*Q
Q=P/Q
print(P,"#",Q)
return Q
A=100
B=200
A=Alter(A,B)
print(A,"$",B)
B=Alter(B)
print(A,"$",B)
Q.22 Write full form on given abbreviation 2
(i) URL
(ii) SMTP
Q.23 Explain the difference between webpage and website with examples of each. 2
OR
What is the difference between Packet Switching and Circuit Switching?
Q.24 What is the role of connect() and rowcount() methods in python. 2
Q.25 What is the importance of UNIQUE constraints in a table? Give a suitable example. 2
OR
Explain the terms degree and cardinality with example in reference to table.
SECTION-C 2
Q.26 Write a method COUNT_WORDS() in Python to read text file ‘STUDENT.TXT’ and display the
total number of Words in the file which start with ‘S’ and end with ‘R’.
your output should shown like given below:
No. of word found: …….
Q.27 Write definition of a function How_Many(List, elm) to count and display number of times the value 3
of elem is present in the List. (Note: don’t use the count() function)
For example :
If the Data contains [205,240,304,205,402,205,104,102] and elem contains 205
The function should display 205 found 3 Times
Q.28 Write PUSH_CITY(cities) and POP_CITY(cities) methods/functions in Python to add new city name 3
and delete city name from a List of cities, considering them to act as push and pop operations of the
Stack data structure.
OR
Write a function in Python PUSH_VAL(val), where val is a list of numbers. From this list push all
odd numbers into a stack implemented by using a list. Display the stack if it has at least one element,
otherwise display appropriate messages.
Q.29 Consider the following tables SCHOOL and ADMIN and answer this question :
Give the output the following SQL queries :
(A) SELECT TEACHER, SUBJECT, GENDER FROM SCHOOL , ADMIN

WHERE SCHOOL.CODE=ADMIN.CODE
AND 1
SCHOOL.EXPERIENCE<5 ;
(B)
(i) Select Designation Count (*) From Admin Group By Designation Having Count (*) <2;
(ii) SELECT max (EXPERIENCE) FROM SCH-OOL;
(iii) SELECT TEACHER FROM SCHOOL WHERE EXPERIENCE >12 ORDER BY
TEACHER;
(iv) SELECT COUNT (*), GENDER FROM AD-MIN GROUP BY GENDER;
Q.30 Write a output for SQL queries (i) to (iii), which are based on the table: SCHOOL and ADMIN given below: 3
TABLE: SCHOOL
(a) SELECT SUM (PERIODS), SUBJECT FROM SCHOOL GROUP BY SUBJECT;

b) SELECT TEACHERNAME, GENDER FROM SCHOOL, ADMIN WHERE DESIGNATION = ‘COORDINATOR’
AND SCHOOL.CODE=ADMIN.CODE;
c) SELECT COUNT (DISTINCT SUBJECT) FROM SCHOOL;
SECTION-D
Q.31 Excel Public School, Coimbatore is setting up the network between its different wings of school campus. 5
There are 4 wings namely SENIOR(S), JUNIOR (J), ADMIN (A) and HOSTEL (H).
Distances between various wings are given below:
Wing A to Wing S 100m
Wing A to Wing J 200m
Wing A to Wing H 400m
Wing S to Wing J 300m
Wing S to Wing H 100m
Wing J to Wing H 450m
Number of Computers installed at various wings are as follows:
Wings Number of Computers
Wing A 20
Wing S 150
Wing J 50
Wing H 25
(a) Suggest the best-wired medium and mention the topology or layout to connect various
wings of Excel Public School, Coimbatore.
(b) Name the most suitable wing to house the server. Justify your answer.
(c) Suggest placement of HUB/SWITCH in the network of the School.
(d) Suggest a device that can provide wireless Internet access to all smartphone/laptop users
in the campus of Excel Public School, Coimbatore.
(e) What should be the Network Topology among all blocks of the organization :
(a) LAN (B) MAN (c) WAN (IV) Any of these
Q.32 (A). Write the output of following Python code. 2
def change(): +
Str1="WORLD-CUP2022" 3
Str2=""
I=0
while I<len(Str1):
if Str1[I]>="A" and Str1[I]<="M":
Str2=Str2+Str1[I+1]
elif Str1[I]>="0" and Str1[I]<="9":
Str2=Str2+ (Str1[I-1])
else:
Str2=Str2+"*"
I=I+1
print (Str2)
change():
(B). The code given below extract the following record in from the table Emp whose salary is more
than Rs. 50000:
EmpNo – integer
EmpName – string
Age– integer
Salary – integer
∙ Username is root
∙ Password is tiger
∙ The table exists in a MYSQL database named BIG_COMPANY.
∙ The details (EmpNo, EmpName, EmpAge and EmpSalary) are to be accepted from the user.
Statement 1 – To create the cursor object
Statement 2 – To execute the command that extract the records of those employees whose salary is
greater than Rs. 50000.
Statement 3 -- To store records from cursor to an object named EmpRecord.
import mysql.connector as cntr
def Emp_Big_Company():
con=cntr.connect(
host="localhost",
user="root",
password="tiger",
database="big_company")
EmpCursor=________________________________ # Statement 1
print("Display Employee whose salary is more than Rs. 50000:")
__________________________________________ # Statement 2
EmpRecord=______________________________________ #Statement 3
for record in EmpRecord:
print(record)
Q.33 (A) Write any two difference between text file and binary file?
(B) Write a Program in Python that defines and calls the following user defined functions:
Add_Book():
To accept data of new book and add to ‘library.csv’ file. The record of book consists
book_id, book_name and book_price in form of python list.
Show_Book():
To read the records of books from ‘library.csv’ file and display the record of books which
price is more than Rs. 500.
SECTION-E
Q.34 Lovepreet is a senior clerk in a MNC. He creates a table salary with a set of records to keep ready for 4
tax calculation. After creation of the table, he has entered data of 5 employees in the table.
Based on the data given above answer the following questions

(i) Identify the most appropriate Attribute, which can be considered as Primary key. Also
mention the degree and cardinality of above table.
(ii) Write SQL Command to drop primary key from emp_id attribute of table.
(iii) Write SQL Command to Increase the HRA by 1% of respective basic salary of all employees.
(iv) Write SQL Chand to Display the Employee Name and their designation whose basic salary is
between 50000 and 80000.
Q.35 Tarun is a student, who wants to make a python program for Sports Department . He is using binary 4
file operations with the help of two user defined functions/modules.
(A) New_Entry() to create a binary file called SPORTS.DAT containing sports related material
information- item_id, item_name and item_qty.
(B) Show_Item() to display the item _name and item_qty of items which item_qty less than 5. In
case there is no item available that which quantity is less than 5 the function displays message.
He has abled to write partial code and has missed out certain statements, so he has left certain queries
in lines. You as an expert of Python have to provide the missing statements and other related queries
based on the following code of Tarun.
Answer any four questions (out of five) from the below mentioned questions.
import pickle
def Add_New_Product():
fopen=________________________________ #1 statement to open the binary file to write
data
while True:
Prod_id = int (input (“Enter Product ID: ”) )
Prod_name = input (“Enter Product Name: ”) )
Prod_price = float (input(“Enter Product Price: ”))
record = [sid, name , age]
______________________________ #2 statement to write the list record into the file
Choice = input(“Are hou wants to Enter more Records(y/n): ” )
if (Choice.upper() =='N'):
break
fopen.close( )
def Show_Product():
Total = 0
Count_rec = 0
Count_price = 0
with open(“ PRODUCTS.DAT”, “ rb”) as F:
while True:
try:
Rec=______________________ #3 statement to read from the file
Count_rec = Count_rec+1
Total = Total+Rec[2]
if Rec[2] ____ : #4statement product which Prod_price<100
print (Rec[1],“ price is :”,Rec[2])
Count_price+ = 1
except:
break
if Count_price = =0 :
print(“No such product found which price iss less than Rs. 100”)
Add_New_Product()
Show_Product()
SAMPLE PAPER SET 13
------------------------------------------------------------------------------------------------------------------------------------------
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c
only.
SECTION-A
1. Name the Python library module needed to be imported to invoke following functions: 1
a. floor ( )
b. randomint ( )
2. To use function of any module, we have to use ____________ (command) before the use 1
of function of a module
3. Identify the key and values from the dictionary given below? 1
a. D = {“Rohan”:{“Manager”:427, “SBI”, 05884 } }
4. Which of the following is/are not assignment operator? 1
a) **= b) /= c) == d) %=
5. Find the output of the code: 1
num = 7
def func ( ) :
num = 27
print(num)
6. Which statement is used to retrieve the current position within the file: 1
a. fp.seek( ) b. fp.tell( ) c. fp.loc d. fp.pos
7. Clause used in select statement to collect data across multiple records and group the 1
results by one or more columns:
a. order by
b. group by
c. having
d. where
8. Which keyword eliminates redundant data from a SQL query result? 1
9. What does the following code print to console? 1
if True:
print(50)
else:
print(100)
a. True b. False c.50 d.100
No. of rows in a relation is called ………………….. .
(a) Degree b. Domain c. Cardinality d. Attributes
11. Which of the following is not a correct Python statement to open a test file “Students.txt” 1
to write content into it :
a. f= open(“Students.txt”, ‘a’)
b. f= open(“Students.txt”, ‘w’)
c. f= open(“Students.txt”, ‘w+’)
d. f= open(“Students.txt”, ‘A’)

The ………………. clause, places condition with aggregate functions .
a. HAVING b. WHERE c. IN d.BETWEEN
13. Write the full forms of: 1
a. PPP
b. VOIP
14. Find the output: 1
tuple1 = (10,12,14,16,18,20,22,24,30)
print( tuple1[5:7] )
15. Which of the following is not an aggregate function? 1

a. AVG b. MAX c. JOIN d.COUNT
16. Name the module used to establish a MySQL database connection with a python program. 1
17. Assertion(A): Dictionaries are enclosed by curly braces { } 1
Reason(R): The key-value pairs are separated by commas ( , )
18. Assertion(A): The random module is a built-in module to generate the pseudo-random 1
variables.
Reason(R): The randrange() function is used to generate a random number between the
specified range in its parameter.
SECTION-B
19. Yuvika has to complete her computer science assignment of demonstrating the use of if-else 2
statement. The code has some error(s). Rewrite the correct code underlining all the
corrections made.
marks = int(“enter marks”)
temperature = input(“enter temperature”)
if marks < 80 and temperature >= 40
print(“Not Good”)
else
print(“OK”)
20. Write a short note on web hosting. 2
OR
What is work of TCP / IP explain.
21. Write the output after evaluating he following expressions: 1
a) k= 7 + 3 **2 * 5 // 8 – 3
print(k)
b) m= (8>9 and 12>3 or not 6>8)
print(m) 1
22. What do you understand by table constraint in a table? Give a suitable example in support 2
of your answer.
23. Expand the following terms: 2
a. PAN b. HTML c. URL d. POP
def func(n1 = 1, n2= 2):
n1= n1 * n2
n2= n2 + 2
print(n1, n2)
func( )
func(2,3)
OR
Predict the output of the Python code given below:

T= [“20”, “50”, “30”, “40”]
Counter=3
Total= 0
for I in [7,5,4,6]:
newT=T[Counter]
Total= float (newT) + I
print(Total)
Counter=Counter-1
25. Rohit wants to increase the size of the column FeeAmount by 5, which is possible 2
category out of DML / DDL of command he has to use to:
(Write DDL or DML alongwith command / query)
Display the structure of table (DDL or DML)
Increase the size of column FeeAmount by 5 (DDL or DML)
OR
Differentiate between char(n) and varchar(n) data types with respect to databases.
SECTION C
26. (a) Observe the following table and answer the question accordingly 1+2
Table:Product
Pno Name Qty PurchaseDate
101 Pen 102 12-12-2011
102 Pencil 201 21-02-2013
103 Eraser 90 09-08-2010
109 Sharpener 90 31-08-2012
113 Clips 900 12-12-2011
What is the degree and cardinality of the above table?
(b) Write the output of the queries (i) to (iv) based on the table, STUDENT given below:
S.NO NAME STIPEND SUBJECT AVERAGE DIV
1 KARAN 400 PHYSICS 68 I
2 DIWAKAR 450 COMP Sc 68 I
3 DIVYA 300 CHEMISTRY 62 I
4 REKHA 350 PHYSICS 63 I
5 ARJUN 500 MATHS 70 I
6 SABINA 400 CHEMISTRY 55 II
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
(i) Select MIN(AVERAGE) from STUDENT where SUBJECT=”PHYSICS”;
(ii) Select SUM(STIPEND) from STUDENT WHERE div=’II’;
(iii) Select AVG(STIPEND) from STUDENT where AVERAGE>=65;
(iv) Select COUNT(distinct SUBJECT) from STUDENT;
27. Write a definition of a function calculate () which count the number of 3

digits in a file “ABC.txt”.
OR
Write a function count( ) in Python that counts the number of “the” word present in a text
file “STORY.TXT”.
If the “STORY.TXT” contents are as follows:
This is the book I have purchased. Cost of the book was Rs. 320.
Then the output will be : 2
28. (a)Write the outputs of the SQL queries (i) to (iii) based on the tablesEmp: 3
EmpCode Ename Salary JoinDate

E001 Raman 55000 2019-10-11
E002 Neha 65000 2019-11-20
E003 Priya 60000 2020-01-28
E004 Raghav 58000 2020-02-16
(i) Select ename, salary from emp where name like ‘_r%’
(ii) Select count(salary) from emp where joindate>’2019-11-28’
(iii) Select max(joindate), min(joindate) from emp
(b) Write the command to list all the databases in MySQL.
29. Write definition of a Method MSEARCH(STATES) to display all the state names from a 3
list of STATES, which are starting with alphabet M.
For example:
If the list STATES contains[“MP’,”UP”,”MH”,”DL”,”MZ”,”WB”]
The following should get displayed
MP
MH
MZ
30. Write a function in Python push(S,item), where S is stack and item is element to be 3
inserted in the stack.
OR
Write a function in Python pop(S), where S is a stack implemented by a list of items. The
function returns the value deleted from the stack.
SECTION-D
31. A software organization has to set up its new data center in Chennai. It has four blocks of
buildings – A, B, C and D.
Distance Between Blocks No. of Computers
Block A to Block B 50m Block A 25

Block B to Block C 150m Block B 50
Block C to Block D 25m Block C 125
Block A to Block D 170m Block D 10
Block B to Block D 125m
1
Block A to Block C 90m 1
(i) Suggest a cable layout of connection between the blocks (Diagram).
1
(ii) Suggest the most suitable block to host the server along with the reason.
1
(iii) Where would you place Repeater devices? Answer with justification.
1
(iv) The organization is planning to link its front office situated in the city
in a hilly region where cable connection is not feasible, suggest
an economic way to connect it with reasonably high speed.
(v) Where would you place Hub/Switch? Answer with justification.
32. (a) Find and write the output of the following python code: 2+3
def change(s):
k=len(s)
m=" "
if(s[i].isupper()):
m=m+s[i].lower()
elif s[i].isalpha():
m=m+s[i].upper()
else:
m=m+'is'
print(m)
change('kv@onTHEtop')
(b) The given program is used to connect with MySQL abd show the name of the all the
record from the table “stmaster” from the database “oraclenk”. You are required to
complete the statements so that the code can be executed properly.
import .connector pymysql
dbcon=pymysql. (host=”localhost”, user=”root”,
=”kvs@1234”)
if dbcon.isconnected()==False
print(“Error in establishing connection:”)
cur=dbcon. ()
query=”select * from stmaster”

cur.execute( ) resultset=cur.fetchmany(3)
for row in resultset:
print(row)
dbcon.________()
OR
(a) Write output of the following code:
def func(a):
s=m=n=0
for i in (0,a):
if i%2==0:
s=s+i
elif i%5==0:
m=m+i
else:
n=n+i
print(s,m,n)
func(15)
(b) Avni is trying to connect Python with MySQL for her project. Help her to write the
python statement on the following:-
(i) Name the library, which should be imported to connect MySQL with Python.
(ii) Name the function, used to run SQL query in Python.
(iii) Write Python statement of connect function having the arguments values as:
Host name :192.168.1.101
User : root
Password: Admin
Database : KVS
33. Divyanshi writing a program to create a csv file “a.csv” which contain user id and 5
name of the beneficiary. She has written the following code. As a programmer help
her to successfully execute the program.
import #Line 1
with open('d:\\a.csv','w') as newFile:
newFileWriter = csv.writer(newFile)
newFileWriter.writerow(['user_id','beneficiary'])
newFileWriter. ([1,'xyz']) #Line2
newFile.close()
with open('d:\\a.csv','r') as newFile:

newFileReader = csv.
(ne
wFile) #Line 3
print (row) #Line 4
newFile. #Line 5
a) Name the module he should import in Line 1

b) Fill in the blank in line 2 to write the row.
c) Fill in the blank in line 3 to read the data from csv file.
d) Write the output while line 4 is executed.
e) Fill in the blank in line 5 to close the file.
OR
ANSHU is writing a program to search a name in a CSV file “MYFILE.csv”. He has
written thefollowing code. As a programmer, help him to successfully execute the
given task.
import # Statement 1
f = open("MYFILE.csv", ) # Statement 2
data = ( f ) # Statement 3
nm = input("Enter name to be searched: ")
for rec in data:
if rec[0] == nm:
print (rec)
f. ( ) # Statement 4
(a) Name the module he should import in Statement 1.

(b) In which mode, MOHIT should open the file to search the data in the file in
statement 2?
(c) Fill in the blank in Statement 3 to read the data from the file.
(d) Fill in the blank in Statement 4 to close the file.
(e) Write the full form of CSV.
SECTION-E
34. Dinesh creates a table COMPANY with a set of 06 records. 1+1+2
C_ID F_ID Cname Fees

C21 102 Grid Computing 40000
C22 106 System Design 16000
C23 104 Computer Security 8000
C24 106 Human Biology 15000
C25 102 Computer Network 20000
C26 105 Visual Basic 6000
(a)Identify the most appropriate column, which can be considered as

Primary key.
(b) If 3 columns are added and 2 rows are deleted from the table result,
what will be the new degree and cardinality of the above table?
(c) Write the statements to:
(i) delete a record which has C_ID as C24
(ii) Increase the Fee of all by 500.
OR (Option for part (C) only)
(i) Add a column PLACE in the table with datatype as varchar with
20 Characters.
(i) Query to display all the records.
35. (a) What is the difference between 'w' and 'a' modes? 1+1+2
Anshuman is a Python learner, who has assigned a task to write python
Codes to perform the following operations on binary files. Help him in writing codes to
perform following tasks (b) & (c):
(b) Write a statement to open a binary file named SCHOOL.DAT
in read mode. The fileSCHOOL.DAT is placed in D: drive.
(c) Consider a binary file “employee.dat” containing details such
as empno:ename:salary (separator ':'). Write a python function
to display details of those employees who are earning between 20000 and 30000 (both
values inclusive).
SAMPLE PAPER SET 14
------------------------------------------------------------------------------------------------------------------------------------------
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against part c only.
Question Part A Marks

No.
Select the most appropriate option out of the options given for each question.
Attempt any 15 questions from question no 1 to 21.
1 Find the invalid identifier from the following: 1
A. MyName B. true C. 2ndName D. My_Name
2 Given the lists L=[1,3,6,82,5,7,11,92],the output of print(L[2:5])is 1

A. [3,6,82] B. [6,82,5] C. [6,5,11] D. [6,82,5,7]
3 Write a statement in Python to open a text file “ABC.TXT” in reading mode. 1
4 What will be the output of: print (10>20)? 1
5 Suppose a tuple T is declared as T = (10, 20, 30, 40), 1

what will be the output of print(T*2)
6 Write the output of following code: 1
d={'amit':19,'vishal':20}
print(d.keys())
7 A tuple is declared as T = (20,5,16,29,83) What will be the problem with the code 1
T[1]=100
8 Name the built-in mathematical function / method that is used to return greatest 1
common divisor of x and y.
9 Identify the data type of X: 1
X = tuple(list( (1,2,3,4,5) ) )
Dictionary (b) string (c) tuple (d) list

10 Name the protocol that is used to upload and download files on internet 1
11 Sunita executes following two statements but got the variation in result 6 and 5 why? 1
(i) select count(*) from user ;
(ii) select count(name) from user ;
12 What is the difference between where and having in SQL. 1
13 Write a command to add new column marks in table ‘student’ data type int. 1
14 Define: 1) Field 2) Record 1
15 What is Null Value. 1
16 Patterns in SQL are described using two special wild card characters such
as ………………………. And …………………
Directions: In the following Qs, A statement of Assertion (A) is followed by a 1

statement of Reason (R). 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 correct explanation for A.
c) A is true but R is false.
d) A is false but R is true.
e) Both A and R are false
17 Assertion (A): writerow( ) function helps us to write multiple rows in a csv file at a 1
time.
Reason (R) : Writing one row at a time in a csv file is not possible, we must write
multiple rows at a time.
18 Assertion (A) : With statement can be used to open any file, be it csv file or 1
binary file and while using with statement to open any file there is no need to close the
file.
Reason (R) : With statement groups all the statements related to file handling and
makes sure to close the file implicitly. It closes the file even when any error occurs
during the execution of statements in a with statement.
Both the Case study based questions are compulsory.
Attempt any 4 sub parts from each question. Each question carries 1 mark
19 A school KV is considering to maintain their eligible students’ for scholarship’s data using SQL 4
to store the data. As a database administer, Abhay has decided that:
• Name of the database - star
• Name of the table - student
• The attributes of student table as follows:
No. - numeric
Name – character of size 20
Stipend - numeric
Stream – character of size 20
AvgMark – numeric
Grade – character of size 1
Class – character of size 3
Table ‘student’
No. Name Stipend Stream Avgmarks Grade Class
1 Karan 400.00 Medical 78.5 B 12B
2 Divakar 450.00 Commerce 89.2 A 11C
3 Divya 300.00 Commerce 68.6 C 12C
4 Arun 350.00 Humanities 73.1 B 12C
5 Sabina 500.00 Nonmedical 90.6 A 11A
6 John 400.00 Medical 75.4 B 12B
7 Robert 250.00 Humanities 64.4 C 11A
8 Rubina 450.00 Nonmedical 88.5 A 12A
9 Vikas 500.00 Nonmedical 92.0 A 12A
10 Mohan 300.00 Commerce 67.5 C 12C
A) Write query to create table.

B) Which column is suitable to be a primary key attribute.
C) What is the degree and cardinality of table student?
D) Display the details of student in ascending order of name.
E) Write query to change the grade of karan from ‘B’ to ‘A’
20 Ranjan Kumar of class 12 is writing a program to create a CSV file “user.csv” which will 4
contain user name and password for some entries. He has written the following code. As a
programmer, help him to successfully execute the given task.
import _____________ # Line 1
def addCsvFile(UserName,PassWord): # to write / add data into the CSV file
f=open(' user.csv','________') # Line 2
newFileWriter = csv.writer(f)
newFileWriter.writerow([UserName,PassWord])
f.close()
#csv file reading code

def readCsvFile(): # to read data from CSV file
with open(' user.csv','r') as newFile:
newFileReader = csv._________(newFile) # Line 3
for row in newFileReader: print (row[0],row[1])
newFile.______________ # Line 4
addCsvFile(“Arjun”,”123@456”)
addCsvFile(“Arunima”,”aru@nima”)
addCsvFile(“Frieda”,”myname@FRD”)
readCsvFile() #Line 5
(a) Name the module he should import in Line 1.
(b) In which mode, Ranjan should open the file to add data into the file.
(c) Fill in the blank in Line 3 to read the data from a csv file.
(d) Fill in the blank in Line 4 to close the file.
(e) Write the output he will obtain while executing Line 5
21 Evaluate the following expression. 2
a) 6 * 3 + 4**2 // 5 – 8
b) 10 > 5 and 7 > 12 or not 18 > 3

22 What do you mean by keyword argument in python? Describe with example. 2
OR
What is scope of a variable in python and write basic scopes of variables in Python
23 Rewrite the following code in python after removing all syntax errors. Underline each 2
correction done in the code:
Def func(a):
for i in (0,a):
if i%2 =0:
s=s+1
else if i%5= =0
m=m+2
else:
n=n+i
print(s,m,n)
func(15)
24 What possible outputs(s) are expected to be displayed on screen at the time of execution of 2
the program from the following code. Select which option/s is/are correct import random
print(random.randint(15,25) , end=' ')
print((100) + random.randint(15,25) , end = ' ' )
print((100) -random.randint(15,25) , end = ' ' )
print((100) *random.randint(15,25) )
(i) 15 122 84 2500 (ii) 21 120 76 1500
(iii) 105 107 105 1800 (iv) 110 105 105 1900
OR
Predict the output of the following code.
def swap(P ,Q):
P,Q=Q,P
print( P,"#",Q)
return (P)
R=100
S=200
R=swap(R,S)
print(R,"#",S)
25 What is the significance of connect() and execute(). 2
26 Write the steps to perform an Insert query in database connectivity application. Table 2
‘student’ values are rollno, name, age (1,’AMIT’,22)
27 Define: 2
1. Repeater 2. Router
28 Differentiate between web server and web browser. Write name of any two browsers. 2
29 Write a function listchange(Arr)in Python, which accepts a list Arr of numbers, the function 3
will replace the even number by value 10 and multiply odd number by 5. Sample Input Data
of the list is:
a=[10,20,23,45]
listchange(a,4)
output : [10, 10, 115, 225]
30 Write a Python program to find the number of lines in a text file ‘abc.txt’. 3
OR
Write a Python program to count the word “if” in a text file abc.txt’.
31 Write the outputs of the SQL queries (i) to (iii) based on the relations Client and Product given 3
below:
Client:
C_ID ClientName City P_ID
01 Cosmetic Shop Delhi TP01
02 Total Health Mumbai FW05
03 Live Life Delhi BS01
04 Pretty Woman Delhi SH06
05 Dreams Delhi TP01
Products:
P_ID ProductName Manufacturer Price Discount
TP01 Talcum LAK 40
Powder
FW05 Face Wash ABC 45 5
BS01 Bath Soap ABC 55
SH06 Shampoo XYZ 120 10
FW06 Face Wash XYZ 95
A) SELECT count(discount) FROM Product ;

B) SELECT Manufacturer, Max(Price), Min(Price) FROM Product group by manufacturer;
C) SELECT ProductName, Client.ClientName FROM Product, Client WHERE Product.P_ID =
Client.P_ID AND Client.City=” Mumbai”;
32 Write a function in python, PushEl(e) to add a new element and PopEl(e) to delete a element 3
from a List, considering them to act as push and pop operations of the Stack data structure.
OR
Write a function in Python, Push(SItem) where , SItem is a dictionary containing the details of
stationary items– {Sname:price}. The function should push the names of those items in the
stack who have price greater than 75. Also display the count of elements pushed into the
stack.
For example: If the dictionary contains the following data:
Ditem={"Pen":106,"Pencil":59,"Notebook":80,"Eraser":25}
The stack should contain:
Notebook Pen
The output should be: The count of elements in the stack is 2
33 Differentiate between a text file, a binary file and a csv file. 3

34 The code given below inserts the following record in the table Student: 3
RollNo – integer
Name – string
Clas – integer
Marks – integer

• Username is root
• Password is tiger
• The table exists in a MYSQL database named school.
• The details (RollNo, Name, Clas and Marks) are to be accepted from the user.

Statement 2 – to execute the command that inserts the record in the table Student.

def sql_data():
con1=mysql.connect(host="localhost",user="root",password="tiger",database="school")
rno=int(input("Enter Roll Number :: "))
name=input("Enter name :: ")
class=int(input("Enter class :: "))
marks=int(input("Enter Marks :: "))
values({},'{}',{},{})".format(rno,name,clas,marks)
______________________ #Statement 2
______________________ # Statement 3
35 My Pace University is setting up its academic blocks at Naya Raipur and is planning to set up a 5
network. The University has 3 academic blocks and one Human Resource Center as shown in
the diagram below:
Center to Center distances between various blocks/center is as follows:

Law Block to Business Block 40m
Law Block to Technology Block 80m
Law Block to HR Center 105m
Business Block to Technology Block 30m
Business Block to HR Center 35m
Technology Block to HR Center 15m
No of computers in each block:

Law Block 15
Technology Block 40
HR Center 115
Business Block 25
36 5
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 75. Also display number of
students scoring above 75%.
OR
A binary file “Stu.dat” has structure (rollno, name, marks). (i) (ii)
I) Write a function in Python add_record() to input data for a record and add to
Stu.dat.
II) Write a function in python Search record() to search a record from binary file
“Stu.dat” on the basis of roll number.
*****
SAMPLE PAPER SET 15
1. This question paper contains five sections – A to E
2. All questions are compulsory
3. Section A, consists of 18 questions carrying 1 marks each.
7. Section E has 02 questions carrying 04 marks each. One internal choice is given in Q35 against c part
only.
8. All programming questions are to be answered using Python Language only`
Section-A
(Each question carries 1 mark from question no. 1 to 16)
Q. NO. QUESTION MAR
KS
1 Which of the following is an invalid variable? 1
(a) hello_world_2
(b) 2_hello_world
(c) day_two
(d) _2
2 What data type is the object below? 1
L=1, 'hello',23.5
(a) List
(b) dictionary
(c) tuple
(d) array
3 Which of the following function headers is correct? 1

(a) def f(a=2,b):
(b) def f(a=3,b,c=6):
(c) def f(a=3,b=1,c=6):
(d) def f(a=3,b=1,c=6,d):
4 Which of the following random module functions generated a floating point number? 1
(a) random()
(b) randint()
(c) uniform()
(d) all of these
5 Which of the following is not a valid mode to open a file? 1
(a) wb+
(b) rw
(c) ab
(d) r+
6 What is the use of return statement in function ? 1
7 Which function in sql is used to calculate average from column ? 1

8 What will be the output of the following Python code? 1
l=[1,2,3,4,5]
l[1:2]=[7,8]
print(l)
(a) [1,2,3,4,5]
(b) [1, 7, 8, 3, 4, 5]
(c) [1, [7, 8], 3, 4, 5]
(d) Syntax error
9 In a stack, deletions take place at ___ end. 1
(a) front
(b) top
(c) rear
(d) any
10 A device that forwards data packet from one network to another is called a 1
(a) Bridge
(b) Router
(c) Hub
(d) Gateway
11 Which of the following is not a legal sub-language of SQL? 1
(a) DDL
(b) DML
(c) TCL
(d) AQL
12 _______clause of the following query must be added with keyword _____ to display the 1
fields given in the select list as per a given condition.
select id,name,salary*1.1 where instructor=10005;
(a) where, having
(b) select, from
(c) where, from
(d) where,select
13 Consider the following SQL statement. What type of statement is this? 1

insert into instructor values(10211,'Amit','Science',6600);
(a) DDL
(b) DML
(c) DCL
(d) TCL
14 The following SQL is which type of join: 1
select customer.cust_id,order.cust_id,name, order_id from customer, order
(a) Equijoins
(b) Natural join
(c) Outer join
(d) Cartesian Product
15 A database______ is a special control structure that facilitates the row by row 1
processing of records in the resultset.
(a) fetch
(b) table
(c) cursor
(d) query
16 Which of the following attributes cannot be considered as a choice for primary key? 1
(a) id
(b) License number
(c)Street no
(d) dept_id
(Assertion Reasoning type question - Each question carries 1 marks from question no.
17 to 18)
Q17: Assertion(A): The programming expression int('12.5') results in error. 1

Reason(R): The literal value for int() with base 10: '12.5' is valid.
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true, but R is not the correct explanation of A.
(c) A is true, but R is false.
(d) A is false, but R is true.
Q18: Assertion(A): To remove the middle element 3 from the list L= [1,2,3,4,5] the statement 1
L.remove (3) can be used.
Reason(R): The function remove will delete the element 4 in the list as it is placed on the
index no 3.
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true, but R is not the correct explanation of A.
(c) A is true, but R is false.
(d) A is false, but R is true.
Section-B
(Very short answer question -Each question carries 2 marks from question no. 19 to 26)
19 Write the output of the following line of code: 2

a=10
def call():
global a
a=15
b=20
print(a)
call()
print(a)
20 What is a Python module? What is its significance? 2
21 Differentiate between read() and readlines() function. 2
22 Enlist two operations performed on stacks. Why is stack called a LIFO data structure? 2
23 Expand the following terms with respect to Networking: 2

(i) MODEM
(ii) WLL
(iii) FTP
(iv) TCP/IP
24 A teacher provides “https://www.youtube.com/watch?v=90ORfh6a-kM” to his /her 2
students. Help them to identify the URL and domain Name.
25 Differentiate between Candidate Key and Alternate Key in context of RDMS. 2
26 What is wrong with the following statement? 2
Select * from employee where grade= NULL;
Write the corrected form of above SQL statement.
Section-C
(Short answer question -Each question carries 3 marks from question no. 27 to 32)
27 Write a method/ function DISPLAYWORDS() in python to read lines from a text file 3
ABC.TXT, and display those words that are greater than 5 characters.
28 Write a function that takes two numbers and return that has maximum one’s digit. 3
(for eg if 491 and 278 are passed it will return 278 as it has got maximum one’s digit)
29 Predict the output. 3
(i)L=[1,4,9,16,35,27]
l=[num/3 for num in L if num%3==0]
print(l)
(ii) [x+y for x in 'ball' for y in 'boy']
(iii) l=[1,2,5,6,7,9,10,22,38]
k=[e1*r for e1 in l if (e1-4)>1 for r in l[:4]]
print(k)
30 Write PUSH(City) and POP(City) methods in Python to add city and remove city 3
considering them to act as Push and Pop operations of data structure Stack.
31 Consider the following dept and worker tables. Find outputs for sql queries (i) to (iii): 3
i) select count(*), DCODE from WORKER group by DCODE having count(*)>1;

ii) select distinct DEPARTMENT from DEPT;
iii) select NAME, DEPARTMENT, CITY from WORKER w, DEPT d where
w.DCODE=d.DCODE and WNO<1003;
32 Which functions can be used as the group functions? What is the use of GROUP BY 3
clause? How are they useful?
Section-D
(Long answer -Each question carries 5 marks from question no. 33 to 34)
33 Write a program to get student data (rollno., name and marks) from user until user 5
wants to add data. Then search for records with roll no 12 or 14. If found display the
records else display an appropriate message.
34 (a) Give one advantage and one disadvantage of optical fibre cable. 5
(b) Differentiate between Tree and Bus topologies of network.
(c) What do email and FTP mean?
(d) Differentiate between repeater and bridge.
(e) Give full form of NFS and FTP.
Section-E
(Case –Study Questions -Each question carries 4 marks from question no. 35 to 36)
35 Rohit, a student of class 12, is learning CSV File Module in Python. During examination, 4
he has been assigned an incomplete python code (shown below) to create a CSV File
'Student.csv' (content shown below). Help him in completing the code which creates the
desired CSV File. Do any 4 out of 5.
CSV File
1,AKSHAY,XII,A
2,ABHISHEK,XII,A
3,ARVIND,XII,A
4,RAVI,XII,A
5,ASHISH,XII,A
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("Enter Class : ")
section = input("Enter Section : ")
rec = [ _____ ]#Statement-4
data.append(_____) #Statement-5
stuwriter. _____ (data) #Statement-6
fh.close()
(i) Identify the suitable code for blank space in the line marked as Statement-1.
(ii) Identify the missing code for blank space in line marked as Statement-2.
(iii) Write the function name (with argument) that should be used in the blank space of
line marked as Statement-3. OR Identify the suitable code for blank space in line marked
as Statement-4.
(iv) Identify the suitable code for blank space in the line marked as Statement-5
36 Write SQL commands for the following queries (i) to (iv) based on the relations Shoppe 4
and Accessories given below:
(i)to display name and price of all the accessories in descending order of their price.
(ii)to display id and sname of all shoppe located in nehru place.
(iii)to display minimum and maximum price of each name of accessories.
(iv) to display name, price of all accessories and their respective sname where they
are available.

XIIComp - Sc. 15 Sample Papers

Uploaded by

Copyright:

Available Formats

XIIComp - Sc. 15 Sample Papers

Uploaded by

Document Information

Original Description:

Original Title

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

XIIComp - Sc. 15 Sample Papers

Uploaded by

Copyright:

Available Formats

कें द्रीय विद्यालय संगठन

KENDRIYA VIDYALAYA SANGATHAN

क्षेत्रीय कायाालय, जम्मू, नज़दीक राजकीय विककत्सालय, गााँधी नगर

(a) Statement-1 (b) Statement-2 (c) Statement-3 (d) Statement-4

12 Fill in the blank: 1

Briefly explain HTML and HTTP.

b. Write the output of the code given below:

b. What is the use of HTTP?

25 Answer the following : 2

What is primary key in MySQL database? Give an example.

What will be the output of the following statement?

The method/function should display:

i. SELECT Department, count(*) FROM Teacher GROUP BY Department;

b. Write the command to view the schema of the table Teacher.

Write a function DeleteCustomer() to delete a Customer information from a list of

a. What is Degree and Cardinality of the above table?

import _____ # Line-1

What will be the output of the following statement?

i) SELECT PName, Average (UPrice) FROM Product GROUP BY Pname;

Expected wire distances between various locations:

As a Python expert, help him to complete the following code based on

num=int(input("Enter any integer number"))

b) Write the output of following code:

Give the Output of following SQL commands:

1 Vasant kunj 100 120 10 Shivamtravels 100000

2 Hauz Khas 80 80 10 Anand travels 85000

3 Pitampura 60 55 30 Anand travels 60000

4 Rohini 100 90 35 Anand travels 100000

5 Yamuna Vihar 50 60 20 Bhalla Co. 55000

6 Krishna Nagar 70 80 30 Yadav Co. 80000

8 Paschim Vihar 40 40 20 Speed travels 55000

9 Saket 120 120 10 Speed travels 100000

10 Jank Puri 100 100 20 Kisan Tours 95000

Number of Computers installed at various locations are as follow:

1. This question paper contains five sections, Section A to E.

(a) Column (b) Keys (c) Row (d) Entry

P ="FIRST PRE BOARD" # Statement 1 print(P) #

(a) Statement 3 b) Statement 4

10. Fill in the blank: 1

21. (a) Given is a Python string declaration: 1

T1 = (12, 22, 33, 55 ,66)

(b) Write the command to open a database “RAILWAY” in MySQL.

X [0] X[1] X[2] X[3] X[4] X[5] X[6]

32 (a) Write the output of the code given below: 2+3

Find and write the output of the following python code:

Note the following to establish connectivity between Python and MYSQL:

import ___________________ as mysql # Statement 1

Statement 1 – to form the cursor object

import mysql.connector as mysql

a) Difference between a binary file and a csv file.

Emp Name Dept Design Gend Salary City

Import ________________ #Statement 1

SAMPLE PAPER SET 5

CLASS – XII SUBJECT: Computer Science-083

Total Time- 3 Hours Total Marks- 70

1. This question paper contains five sections, Section A to E.

Q1. Which is a valid identifier in python? 1

Q5. Consider the given expression: 1