(SET 1)

Computer Science (083)

PRE BOARD EXAMINATION 2023-24

Maximum Marks: 70 Time Allowed: 3 hours

General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 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. State True or False 1
“Dictionaries in python are mutable.”
2. Which of the following is an invalid identifier 1
a)myname b)p9tv c)def d)_new

3. Which one of the following is the function to get list of keys from a dictionary 1
dict in python?

a. dict.getkeys()
b. dict.getvalues()
c. dict.keys()
d. None Of These

4. Consider the given expression: 1

True OR NOT False AND True
Which of the following will be correct output if the given expression is
evaluated?

(a) True
(b) False
(c) NONE
(d) NULL

5. Select the correct output of the code: 1

Str=”I will Succeed”

1
 lis=str.split(“ “)
print(lis[-1])

(a) I
(b) will
(c) Succeed
(d) ”I will Succeed”

6. Which of the following methods will give the current position of the file 1
pointer?

(a)seek() (b)tell() (c)getloc() (d) None of the above

7. Fill in the blank: 1

Command is used to change the structure of the table in SQL.

(a)update (b)remove (c)alter (d)drop

8. Which of the following commands will delete the row of the table from 1
MYSQL database?
(a) DELETE
(b) DROPTABLE
(c) REMOVETABLE
(d) ALTERTABLE

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

executing the following code?

T=(8,9,7,6) # Statement 1
print(T) # Statement2
T=(7,9,7,6) # Statement3
T[1]=8 # Statement4
T=T+(1,2,3) # Statement5

(a) Statement3
(b) Statement4
(c) Statement5
(d) Statement 4 and5

10. Fill in the blank: 1

is an attribute or set of attributes eligible to become primary

key.
(a) PrimaryKey
(b) ForeignKey
(c) CandidateKey

2
 (d) Alternate Key

11. The default mode of opening a file in pyhton 1

(a) append
(b) read
(c) write
(d) both b and c
12. Which of the following can be used as command to get the structure of a table in 1
mysql

(a) DESCRIBE
(b) UNIQUE
(c) DISTINCT
(d) NULL
13. Fill in the blank: 1
Is the protocol used for server to server mail transfer?

(a)VoIP (b)SMTP (c)PPP (d)HTTP

14. What will the following expression be evaluated to in Python? 1

print(2**3**2//8)

(a)64.0 (b)64 (c)8 (d)None Of These

15. Which clause is used to apply conditions with GROUP BY 1

(a) WHERE
(b) HAVING
(c) LIKE
(d) None Of These

16. Which function is used to establish connection between python and SQL 1
database?

(a) connection
(b) connect
(c) getconnection
(d) getconnect

Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct
choice as
(a) Both A and R are true and R is the correct explanation for A

3
 (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):-Functions in a program increases the modularity and readability 1
of the program
Reasoning (R):-Usage of Functions increases the execution speed of the
program

18. Assertion (A): If a file is opened in binary mode its contents are viewed as a 1
sequence of bytes.
Reason (R): A text file also can be opened in binary mode

SECTION B
19. Rahul has written a code to input a number and return its reverse. His code is 2
having errors. Rewrite the correct code and underline the corrections made.

def reverse()
n=int(input("Enter number :: ")
rev=0
while(num>0):
r=num%10
rev=rev*10+r
num=num//10
return rev

20. What do you mean by protocol? Give two examples 2

OR

What is a MODEM? Explain its use?

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

Mystr=”I will win”

Write the output of: print(Mystr[2:6])

(b) Write the output of the code given below:

dictcount={“age1”:26,”age2”:32,”age3”:40} 1
sum=0
for key in dictcount:
sum=sum+dictcount[key]
print(sum)

22. Explain the use of ‘Primary Key’ in a Relational Database Management 2

System. Give example to support your answer.

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

(i) FTP (ii)TCP

4
 (b) What is the use of POP3?

24. Predict the output of the Python code given below: 2

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

OR

Predict the output of the Python code given below:

tuple1 = (33, 24, 44, 42, 54 ,65)
list1 =list(tuple1)
new_list = []
for i in list1:
if i>40:
new_list.append(i)
new_tuple = tuple(new_list)
print(new_tuple)

25. Explain the use of DISTINCT keyword in python with appropriate example 2
OR

What is called DDL commands in mysql?Give examples?

SECTION C

26. a)Consider the following tables -Product and Supplier: 1+2

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

(i)SELECT DISTINCT deptid from Employee;

(ii)SELECT deptid,count(*),min(salary) from employee GROUP BY deptid
HAVING count(deptid)>2;
(iii)SELECT empname FROM employee WHERE salary>14000 ORDER BY
empname;
(iv)SELECT SUM(SALARY) FROM Employee WHERE SALARY
BETWEEN 15000 AND 18000;

27. Write a method COUNTLINES() in python to read lines from text file 3
MYSTORY.TXT and display the count of lines which are starting with letter T
Example:if the file content is as follows:
Trees are the precious
We should protect trees
This way we can serve nature

The COUNTLINES() function should display output as:

The number of lines starting with letter T :2

OR

Write a function COUNTOWEL() IN PYTHON which should read each

character of a text file CHARACTER.TXT and display the count of vowels

Example:

If the file content is as follows:

Exam is going on well

The COUNTOWEL() function should display the output as:

7

28. (a) Write the outputs of the SQL queries (i) to (iv) based on the 3
relations Teacher and Placement given below:

6
 BOOK

Book_id Book_name Price Qty Author_id

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

AUTHOR

Author_id Author_name Country

201 William Hopkins Australia
202 Anita India
203 Anna Roberts USA
204 Brain Brooke Italy

(i) SELECT Author_id, avg(price) from BOOK GROUP BY

Author_id;
ii) SELECT MAX(price),MIN(price) from BOOK;
ii) SELECT Book_name,Author_name,country from BOOK B,
AUTHOR A WHERE B.Author_id = A.Author_id AND price>300;
iv) SELECT Author_name from AUTHOR WHERE Author_name LIKE
“A%”;
29. Write a function EVEN_LIST(L), where L is the list of elements passed 3
as argument to the function. The function returns another list named ‘even list’
that stores even numbers in the list.
For example:

If L contains [1,2,3,4,5,6,7,8]

The even list will have - [2,4,6,8]

30. A list contains following record of a student: 3

[student_name, age, hostel]

Write the following user defined functions to perform given operations on the
stack named ‘stud_details’:
(i) Push_element() - To Push an object containing name and age of
students who live in hostel “Ganga” to the stack
(ii) Pop_element() - To Pop the objects from the stack and display
them. Also, display “Stack Empty” when there are no elements in the
stack.
For example:
If the lists of customer details are:

[“Barsat”,17,”Ganga”]
[“Ruben”, 16,”Kaveri”]
[“Rupesh”,19,”Yamuna”]
The stack should contain
7
 [“Barsat”,17,”Ganga”]
The output should be:
[“Barsat”,17,”Ganga”]
Stack Empty

OR

A list named as Record contains following format of for students:

[student_name, class, city].
Write the following user defined functions to perform given operations on the
stack named ‘Record’:
(i) Push_record(Record) – To pass the list Record = [ ['Rahul', 12,'Delhi'],
[‘Kohli',11,'Mumbai'], ['Rohit',12,'Delhi'] ] and then Push an object containing
Student name, Class and City of student belongs to ‘Delhi’ to the stack Record
and display and return the contents of stack
(ii) Pop_record(Record) – To pass following Record [[“Rohit”,”12”,”Delhi”]
[“Rahul”, 12,”Delhi”] ] and then to Pop all the objects from the stack and at last
display “Stack Empty” when there is no student record in the stack. Thus the
output should be: -
[“Rohit”,”12”,”Delhi”]
[“Rahul”, 12,”Delhi”]
Stack Empty

SECTION D

31
Hi-tech Training center, a Mumbai based organization is planning to
expand their training institute to Chennai. At Chennai compound,
they are planning to have three different blocks for admin, training
and accounts related activities. As a network consultant you have to
suggest some network related solutions to the organization

Shortest distance between the blocks Number of computers installed

are given below: in each block are as follows:
Admin  Accounts 300 meters Training 150
Block
Accounts 150 meters Accounts 30
training block
8
 I Admin  Training 200 meters Admin Block 20
Mumbai  1300 KM
Chennai office

i) Suggest the most suitable block to house the server at Chennai block for 1
best and effective connectivity.
Suggest the type of network for the new training institute and draw
ii) 1
the cable layout for the Chennai office
Suggest a hardware/software that would provide the data security for entire network of Chennai
1
iii) region.
Suggest a device that shall be needed to provide wireless internet access to all smart
1
iv) phones/laptop users in Chennai office.
Suggest the protocol used for video conferencing between Chennai
1
v) office and Mumbai office

32. (a) Write the output of the code given below: 2+3
val=4
def findval(m,n=10):
val=0
val=val+m*n
a=10
b=20
findval(a,b)
print(val,end="-")
findval(a)
print(val,end="-")

(b) The code given below inserts the following record in the table
Employee:

Empid – integer Name – string salary-float

Note the following to establish connectivity
between Python and MYSQL:
Username is root
Password is tiger
The table exists in a MYSQL database named Empolyee.
The details (Empid, Name, salary) are to be accepted from
the user.
Write the following missing statements to
complete the code:
Statement 1 – to form the cursor object
Statement 2 – to execute the command that
inserts the record in the table Employee.
Statement 3- to add the record permanently in
the database
9
import mysql.connector
from mysql.connector import Error
connection = mysql.connector.connect(host='localhost',
database='Employee',
user='root',
password='tiger')

cursor=_______________________#STATEMENT1
empid=int(input("enter Empid"))
name=input("enter name")
salary=float(input("ENTER SALARY"))
result = __________________________#STATEMENT2
___________________________________#STATEMENT3

OR

(a) Predict the output of the code givenbelow:

s="PREboardCS*2022!"
j=2
for i in s.split('*'):
k=i[:j]
if k.isupper():
j=j+1
elif k.isdigit():
j=j+2
else:
j=j+3
print(s [ j : : j ] )

(b) The code given below reads the following record from the table
named Employee and displays only those records who have Salary
greater than 25000:

Note the following to establish connectivity between Python and

MYSQL:
 Username is root
 Password is tiger
 The table exists in a MYSQL database named Employee.

Write the following missing statements to complete the code: Statement 1 – to

form the cursor object
Statement 2 – to execute the query that extracts records of those
Employees who have salary greater than 25000.
Statement 3- to read the complete result of the query (records whose
salary greater than 25000) into the object named records, from the table
Employee in the database.

import mysql.connector
10
 connection = mysql.connector.connect(host='localhost',
database='Employee',
user='root',
password='tiger')
cursor=________________________#STATEMENT1
_________________________________________#STATEMENT2
records = _____________________________#STATEMENT3
for row in records:
print("Empid",row[0],end=" ")
print("name",row[1],end=" ")
print("salary",row[2],end=" ")
print()

33. What is a csv file? 5

Write a Program in Python that defines and calls the following user defined
functions:

(i) INSERT() – To accept and add data of a student to a CSV file

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

OR

What is the purpose of delimiter?

Write a Program in Python that defines and calls the following user defined
functions:

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

‘product.csv’. Each record consists of a list with elements as
pid, pnameand priceto storeproduct id, product name and
pricerespectively.
(i) search()- To display the records of the products whose price is
more than5000.

SECTION E

34. Rahul created following table TRAVEL to store the travel details 1+1+2

11
 Based on the data given above answer the following questions:

(i) Identify the most appropriate column, which can be considered as

Primary key.
(ii) If 3 columns are added and 1rows are deleted from the table TRAVEL,
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
110 BIMAL 28-11-2022 200 VOLVO BUS 40

b. Increase KM travelled by 10 if the VTYPE is VOLVO.

OR (Option for part iii only)

(iii) Write the statements to:

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

(i) Which module should be imported in the program? (Statement1) 1

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

13