GRADE:XII MARKS:70

SUBJECT: COMPUTER SCIENCE [7-12-23] TIME: 3 HRS

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.

S.NO SECTION-A MARKS

1 Find the invalid identifier from the following
(a) name (b) classes (c) section (d) 1
2 break State true or false:
for ( ) is also a module function. 1

3 What is the output of the following

code? a=[1,2,3,4,5]
for i in range(1,5):
a[i-1]=a[i] 1
for i in range(0,5):
print(a[i],end=" ")
(a) 5 5 1 2 3 (b) 5 1 2 3 4 (c) 2 3 4 5 1 (d) 2 3 4 5 5
4 Given the Python declaration s1=”Hello”. Which of the following
statement will give an error? 1
(a) print(s1[4]) (b) s2=s1 (c) s1=s1[4] (d) s1[4]=”Y”
5 Identify output of the following Python statement:
s=”Good morning”
print(s.title( ), end=”!”) 1
(a) Good Morning
(b) Good morning
 (c) good Morning!
(d) Good Morning!
6 What is the output of the functions shown below? 1
print(min(max(False,-3,-4),2,7))
(a) -3 (b) -4 (c) True (d) False
7 Suppose the context of “Rhymes.txt”
is Hickory Dickory Dock 1
the mouse went up the clock
What will be the output of the following Python code?
f=open(“Rhymes.txt”)
l=f.readlines()
x=[“the”,”ock”
] for i in l:
for w in
i.split(): if w
in x:
print(w,end=”*”)
(a) the* (b) the*the* (c) Dock*the*clock* (d) error
8 Which of the following statement is not correct?
(a) We can write content into a text file opened using ‘w’ mode
(b) We can write content into a text file opened using ‘w+’ mode
(c) We can write content into a text file opened using ‘r’ mode
(d) We can write content into a text file opened using ‘r+’ mode 1
9 is a protocol that allows to send/upload email message from 1
local computer to an email server.
10 What will the following code do?
dict={“Phy”:94,”Che”:70,”Bio”:82,”Eng”:95}
dict.update({“Che”:72,”Bio”:80}) 1
(a) It will create new dictionary as dict={“Che”:72,”Bio”:80} and old dict
will be deleted
(b) It will throw an error as dictionary cannot be updated
(c) It will simply update the dictionary as
dict={“Phy”:94,”Che”:72,”Bio”:80,
“Eng”:95}
(d) It will not throw any error but it will not do any changes in dict
11 Command to remove the row(s) from table student is 1
(a) drop table stud; (b) drop from student;
(c) remove from student; (d) delete from student;
12 Which SQL command is used to add a new attribute in a existing table? 1
(a) Add (b) update (c) alter d)None of the above
13 The following SQL command is which type of join: 1
SELECT customer, cust_id, order, cust_id, name, order_id FROM
customer, order;
(a) Equi-join (b) Natural join (c) Outer join (d) Cartesian product
14 In order to open a connection with MySQL database from within Python 1
using mysql.connector package, function is used.
 (a) open( ) (b) database( ) (c) connect( ) (d) connected( )
15 Select aggregate functions from the following: 1
a) total() (b) average() (c)max() (d) None of the above
16 function counts only those rows that contain a value; it ignores 1
all null values in the field.
(a) count(*) b) count(fieldname) (c) sum() (d) All of these
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): The readline( ) method reads one complete line from a text 1
file.
Reason(R): The readline( ) method reads one line at a time ending with a

newline(\n). It can also be used to read a specified number (n) of

bytes of data from a file but maximum up to the newline
character(\n)
18 Assertion(A): Keyword arguments are related to function calls. 1
Reason(R): keyword argument is a kind of function type.

S.NO SECTION- MARKS

B
19 Rewrite the following Python program after removing all the errors (if 2
any), underlining each correction:
x=input(“Enter a number”))
if x % 2==0:
print (x, “is even”)
else if x<0:
print (x, “should be positive” )
else;
print (x “is odd”)
20 What are the advantages of using network?(any 4 points)
(OR) 2
How is Coaxial cable different from Optical Fibre?
21 Find the output generated by the following code: 2
a=5
b=10
a+=a+b
b*=a+b
print(a,b
)
 22 What is the similarity and difference between candidate key and PRIMARY 2
KEY constraints?
23 (a) What is the difference between BUS and Tree Topology? 2
(b) Expand the following: SMTP, PPP
24 Determine the output of the following code fragments:
def determine(s):
d={“UPPER”:0, ”LOWER”:0}
for c in s:
if c.isupper( ):
d[“UPPER”]+=1 2
elif c.islower( ):
d[“LOWER”]+=1
else:
pass
print(“Original String:”,s)
print(“Upper case count:”, d[“UPPER”])
print(“Lower case count:”, d[“LOWER”])
determine(“These are HAPPY Times”)
(OR)
Write the output of the following Python code:
def fun(s):
k=len(s)
m=” ”
for i in range(0,k):
if (s[i].isupper( )):
m=m+s[i].lower( )
elif s[i].isalpha( ):
m=m+s[i].upper( )
else:
m=m+’bb’
print(m)
fun(‘school2@com’)

25 Write the full forms of DDL and DML. Write any two commands of DML 2
in SQL.
(OR)
What is the use of GROUP BY clause? Give example.

SECTION-C
26. Consider the following tables: CONSIGNOR and CONSIGNEE 3
Table: CONSIGNOR
27 Write a function Show_words( ) in python to read the content of a text file 3
‘NOTES.TXT” and display the entire content in capital letters.
Example if the file contains:
“This is a test file”
Then the function should display the output as:
THIS IS A TEST FILE
(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.
For example if the file “DATA.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”
28 Consider the following tables WORKER and PAYLEVEL and answer the following 3
parts of this question:
Table: WORKER
CODE NAME DESIG PLEVEL DOJ DOB
11 Radhe Shyam Supervisor P001 13-09-2004 23-08-1981
12 Chander Nath Operator P003 22-02-2010 12-07-1987
13 Fizza Operator P003 14-06-2009 14-10-1983
15 Ameen Ahmed Mechanic P002 19-12-2005 13-03-1983
18 Sanya Clerk P002 19-12-2005 09-06-1983
Table: PAYLEVEL
PLEVEL PAY ALLOWANCE
P001 26000 12000
P002 22000 10000
P003 12000 6000
 Give the output for the following SQL queries:
(i) SELECT COUNT(PLEVEL), PLEVEL FROM WORKER GROUP BY PLEVEL;
(ii) SELECT MAX(DOB), MIN(DOJ) FROM WORKER;
(iii) SELECT Name, Pay FROM WORKER W, PAYLEVEL
P
29 WHERE 3
W.PLEVEL=P.PLEVEL AND W.CODE<13;
30 Write a function stats( ) to read all the lines except that line start with 3
“M” form f1.Txt file and copies into f2. Txt file . Give sample output also.
Write Addnew(Book) and Remove(Book) functions in python to add a
new book and remove a book from a List of books, considering them to
act as PUSH and POP operations of the data structure Stack.
(OR)
Write a function called letter_freq(my_list) that takes one parameter, a list
of strings(mylist) and returns a dictionary where the keys are the letters
from mylist and the values are the number of times that letter appears in the
mylist, e.g.,if the passed list is as:
S.N wlist=list(“aaaaabbbbcccdde”) then it should return a dictionary MARKS
O as{‘a’:5,’b’:4,’c’:3,’d’:2,’e’:1} 5
31 SECTION-D
Learn Together is an educational NGO. It is setting up its new campus at
Jabalpur for its web-based activities. The campus has four compounds
as shown in the diagram below:

Centre to centre distance between various compounds as per architectural

drawing (in m) is as follows:
BLOCK DISTANCE
Main Compound to Resource Compound 110 m
Main Compound to Training Compound 115 m
Main Compound to Finance Compound 35 m
Resource Compound to Training Compound 25 m
Resource Compound to Finance Compound 135 m
Training Compound to Finance Compound 100 m
Expected number of computers in each compound are as follows:
BLOCK NO.OF COMPUTERS
Main Compound 5
Resource Compound 15
Training Compound 150
 Finance Compound 20
(i) Suggest a cable layout of connections between the compounds.
(ii) Suggest the most suitable place (i.e. compound) to house the server for
this NGO. Also, provide a suitable reason for your
suggestion.
(iii) Suggest the placement of the following devices with justification:
(a) Repeater (b) Hub/Switch
(iv) The NGO is planning to connect its international office situated in
Mumbai, which out of the following wired communication link, will
You suggest for a very high-speed connectivity?
(a) Telephone analog line (b) Optical fibre (c) Ethernet cable.
(v) Suggest a device / software to be installed in the Jabalpur campus to
take care of data security.
32 (a) Write the output of the code given below:
def evn(l):
enum=” “
for n in range(len(l)):
if n%2==0:
enum+=l[n]
elif n%3==0:
enum+=l[n].upper( )

return enum
print(evn([‘a’,’b’,’r’,’a’,’c’,’a’,’d’,’a’,’b’,’r’,’a’]))

(b)Consider a file, SPORT.DAT, containing records of the following structure:

[SportName, TeamName, No_Players]
Write a function, copyData(), that reads contents from the file
SPORT.DAT and copies the records with Sport name as “Basket Ball” to
the file named BASKET.DAT. The function should return the total number
of records copied to the file BASKET.DAT.
(OR)
(a) Predict the output of the code given
below: a=10
b=20
def change( ):
global b
a=45
b=56
change( )
print(a)
print(b)
(b) Write a Python program to search a particular roll no form the binary file
“strec.dat”. Binary file contains the following filed.
[ Roll no, sname, age]
33 (a) Write a function in Python that counts the number of “Me” or “My” 5
words present in a text file “STORY.TXT”.
If the “STORY.TXT” contents are as follows:
My first book was Me and My family.
It gave me chance to be known to the world.
The output of the function should be:
Count of Me/My in file: 3

(b) Give one point of difference between a readline() and read().

(OR)
(a) What are functions? Give its advantages.
(b) Write a function in Python PUSH(Arr), where Arr is a list of numbers.
From this list push all numbers divisible by 8
into a stack
implemented by using a list. Display the stack if it has at
least one
element, otherwise appropriate error message.

S.N SECTION-E MARKS

O In a database High sports there are two tables: students and sports with the 4
34 instances given below:
Table: STUDENTS
ADMNO NAME CLASS GRADE RNO ADDRESS PHONE
1211 MEENA 12A D 4 A-26 3245678
1212 VANI 10A D 1 B-25 5456789
1213 MEENA 12B A 1 NULL NULL
1214 KARISH 10B B 3 AB-234 4567890
Table: SPORTS
ADMNO GAME COACHNAME GRADE
1215 CRICKET MR.RAVI A
1213 VOLLEYBALL MR.AMANDEEP B
1211 VOLLEYBALL MR.GOVARDHAN A
1212 BASKETBALL MR.TEWARI B
Write the SQL queries for the following statements with output:
(i) To display name and game of those students whose address is
available
in students table.
(ii) To delete a column phone from the table students.
(iii) To display names of those students who are studying in class 12
(iv) To count the number of students who studying in 10th.

35. Monish is a Python programmer working in a collage .

For the Annual Sports Event, he has created a csv file named Result.csv,
to store the
different sports events. The structure of Result.csv is :
[CSt_Id, CSt_Name, Game_Name, Result]
Where
St_Id is Student ID (integer) ST_name is Student Name (string)
Game_Name is name of game in which student is participating(string)
Result is result of the game whose value can be either 'Won', 'Lost' or 'Tie'
For efficiently maintaining data of the event, Monish wants to write the
following user defined functions:
Accept() – to accept a record from the user and add it to the file Result.csv.
The column headings should also be added on top of the csv file.
wonCount() – to count the number of students who have won any event.
As a Python expert, help him complete the task