ROLL NUMBER SUBJECT CODE: 083

COIMBATORE & MADURAI SAHODAYA SCHOOLS COMPLEX

COMMON EXAMINATION
DECEMBER 2020
Grade: XII COMPUTER SCIENCE Max. Marks: 70
Date: 14.12.2020 (SET – B) Time: 3 hrs
General Instructions:
1. Reading time : 9.15 am to 9.30 am
2. Writing time: 9.30 am to 12.30 pm
3. This question paper contains two parts A and B. Each part is compulsory.
4. Both Part A and Part B have choices.
a. Section – I is short answers, to be answered in one word or one line.
b. Section – II has 2 case study questions. Each case study has 4 case-based sub parts.
An examinee is to attempt any 4 out of the 5 subparts.
5. Part B is Descriptive Paper.
6. Part B has 3 sections.
a. Section – I is short answer questions of 2 marks each in which 2 question have internal options.
b. Section – II is long answer questions of 3 marks each in which 2 questions have internal options.
c. Section – III is very long answer questions of 5 marks each in which one question has internal
option.
6. All programming questions are to answered using Python Language only.

Question Part A Marks

No. allocated

Section I

Select the most appropriate option out of the options given for
each question. Attempt 15 questions from question no 1 to 21.

What is a Primary key? Give an example.

1. 1

1
 Consider L=[0.5 * x for x in range (0,4)]
2. 1
and write the contents of the list L.

What will be the result of the following statements?

3.
a) bool(int(‘0’)) b) type(“hello”)
1

Which of the following creates a tuple?

4.
a) tuple1=(“a”,”b”) b) tuple[1]=(“a”,”b”)
1
c) tuple1=(5)*2 d) None of the above

Evaluate the following expression.

5.
35+5 and 23%3<=89 or True or False and 35/4 1

Consider the following statement.

6.
Dict = { “Teena”:18,”Riya”:12, “Aliya”:22}
1
How will you remove “Riya” from Dict?

Name the built in function to check if a string contains only digits

7. 1
in a string or not.

Identify the data type and write mutable/immutable against them.

8. 1
a) [10,20,30] b) (‘a’,’e’,’I’,’o’,’u’)

Which device is called as Intelligent Hub?

9. 1

2
 Which operator performs pattern matching in SQL?
10. 1

By default the ORDER BY clause in SQL lists the results in

11. 1
___________ order.

Avg() is a _____________function in MYSQL.

12. 1
a) math b) text
b) aggregate d) numeric

Riju wanted to find the subject in which she has scored highest
13. 1
marks. Suggest a function in SQL to find the highest mark?

Which of the following is not a valid string operation in Python?

14. 1
a) ‘abc’ + ‘abc’ b) ‘abc’*3
c) ‘abc’+3 d) ‘abc’.lower()

Mr. Ramesh wishes to connect his electronic devices within the

15. 1
distance of 5 to 10 metres. Suggest him the best wireless mode of
connection among the devices

______________is a network device that connects dissimilar

16. 1
networks.

What will be the output of the following code snippet?

17. 1
Value=[2**x for x in range (10) if x>5]

A tuple is declared as
18. 1
T=(12,23,34,45)
What will be the value of T.index(34)

3
19. 1
Number of tuples in a relation is called as_________.

The traditional telephone system follows ____________switching

20. 1
technique.

In SQL, write a query to display all the details from the table
21. 1
ACADEMICS .

Section II
Both the case study based questions are compulsory. Attempt
any 4 sub parts from each question. Each question carries 1
mark.
Jey International School has stored the details of teachers in a table
22.
“DATA” of the database “TEACHER”
Attributes of the table are:
Name - Character (20)
Age - Numeric
Department - Character(20)
Salary - Numeric
Gender - Character
Based on the table given answer the queries given below.
Name Age Department Salary Gender
Jugal 34 Computer 20000 M
Sangeetha 32 Maths 30000 F
Rakesh 42 Maths 25000 M
Shalakha 33 Physics 23000 F
Shyam 50 Physics 32000 M

a) List the names of teachers who belong to Maths department. 1

b) Identify the degree and cardinality of the table.
1

4
 c) Display the number of male and female teachers in the 1
school.
d) Delete the records of teachers whose age is more
1
than 30.
e) Display the unique departments in the school.
1
Legend sports wanted to store the number of prizes for each sport
23.
as a SPORTS.CSV file.
As a programmer help them to complete the task successfully.
import _______________ #Line 1
fh=___________________ # Line 2
swriter = ______________(fh) #Line 3
ans=’y’
i=1
while ans==’y’:
print(“Record”,i)
sport=input(“Sport name”)
prizes=int(input(“Enter prizes won”))
________________ # Line 4
i=i+1
ans=input(“Want to enter records”)
fh._________________#Line 5
a) Name the module to be imported in Line 1. 1
b) Fill in line 2 to open the CSV file.
1
c) Write the correct statement to write the datas into file in line 3
1
d) Write the statement to write the records given as input from user
in line 4. 1
e) Write a statement to close the file. 1

5
 PART B
SECTION I

Differentiate between Star topology and Ring topology.

24. 2
OR
Differentiate between 3G and 4G mobile technologies.

What is Intelluctual Property?

25.
2
OR
What are cookies?

Write the type of literal for the following:

26.
2
i) “school” ii) None iii) True iv)0x998

Find the output of the following Python program.

27.
2
def f3(a,b):
global x,y
x=a+b
a,y=a+x,a*x
print(a,b,x,y)
f3(5,10)
print(f3(b=x,a=y))

What is the significance of GROUP BY clause in SQL query?

28.
2
Give an example.

What are the possible outcome(s) executed from the following

29.
2
code? Also specify the maximum and minimum values that can be
assigned to the variable NUM.
import random
NAV=[“LEFT”,”FRONT”,”RIGHT”,”BACK”]
6
 NUM=random.randint(1,3)
NAVG=””
for C in (NUM,1,-1):
NAVG=NAVG+NAV[C]
print(NAVG)
i) BACKRIGHT ii) BACKRIGHTFRONT
iii) BACK iv) LEFTFRONTRIGHT

Rewrite the following code in Python after removing all syntax

30.
2
error(s). Underline each correction done in the code.
DEF increment(n)
Append([4]
L=[1,2,3,]
M=increment(l)
print L,M

Find and write the output of the following code.

31.
2
FACT1=”WoNdERFUL”
FACT2=”DayLigHT”
FACT3=””
for I in range(0,len(FACT2)+1):
if FACT1[I]>=’A’ and FACT1<=’F’:
FACT3=FACT3+FACT1[I]
elif FACT1[I]>=’N’ and FACT1[I]<=’Z’:
FACT3=FACT3+FACT2[I]
else:
FACT3=FACT3+”*”
print(FACT3)

7
 Write the SQL command to do the following tasks.
32.
2
i) To see the list of tables in a database
ii) To insert a new record in the table.
.
What is the purpose of connect(), cursor() and execute() function 2
33.
in executing a SQL query.

SECTION II

Write a function in Python that copies a text file “source.txt” into

34.
3
“target.txt” barring the lines starting with a “@” sign.
OR
Write a function in Python to count the number of lines in a text
file “POEM.TXT” which starts with an upper case character.
Given a nested list tuple1=((1,2),3,4.15,5.15),(7,8,12,15)). Write a
35.
3
program that displays the means of individual elements of tuple
tup1 and then display the mean of these computed means.
Output should be like the one given below.
Mean element1:1.5 Mean element3:10.5
Mean element2: 4.1 Mean of means:5.3666
Write the outputs of the SQL queries (i) to (iii) based on the
36.
relations PERSONAL and DETAILS
RELATION: PERSONAL
INO PNAME ADDRESS
501 RIDDHI CHENNAI
502 RITHVIK BANGALORE
503 IRFAAN CHENNAI
504 SIDDHESH DELHI
505 KUNAL HYDERABAD

8
 RELATION: DETAILS
DNO INO AMOUNT TYPE DOT
D001 501 2500 Withdraw 2017-12-21
D002 503 3000 Deposit 2017-06-01
D003 502 2000 Withdraw 2017-05-12
D004 503 1000 Deposit 2017-10-22
D005 502 12000 Deposit 2017-11-06
i) SELECT INO,INAME FROM PERSONAL WHERE
1
ADDRESS NOT IN(‘CHENNAI’)
ii) SELECT INO,COUNT(*),MIN(AMOUNT) FROM 1

DETAILS GROUP BY INO HAVING COUNT(*)>1

iii) SELECT PERSONAL.NAME,PERSONAL.ADDRESS,

1
DETAILS.DOT FROM PERSONAL,DETAILS WHERE
PERSONAL.INO =DETAILS.INO
Write a function in Python PUSH(Arr) where Arr is the list of
37.
numbers. From the list push all numbers divisible by 5 and 20 into
3
a stack implemented by using list. Display the stack if it has one
element otherwise display appropriate message.
(OR)
Write a function POP(Arr) , where Arr is a stack implemented by a
list of numbers The function returns the value deleted from the
stack.

SECTION III

Consider the following definition of dictionary SCHOOL. Write a

38.
method in Python to read the contents of the file
5
“STUDENT.DAT” and search and display all the content in the

9
 pickled file STUDENT.DAT, where ROLL NO key of the
dictionary is matching with the value 1201.
SCHOOL={‘ROLL NO’:____,’NAME’:_______,’MARKS’;____}
(OR)
Write a method RECCOUNT() to read the content of binary file
“NAMES.DAT” and display the number of records (each name
occupies 20 bytes in file) in it and also display the number of
records where the name starts with ‘S’.

Write SQL commands for the following queries (i) to (v) based on
39.
the given relations.
RELATION : ITEM
C_ID I_NAME MANUFACTURER PRICE
PC01 Personal Computer TAL 45000
LC05 Laptop DELL 65000
PC03 Personal Computer INFO 32000
PC06 Personal Computer COMP 37000
LC03 Laptop XION 57000
RELATION: CUSTOMER
C_ID CUST_NAME CITY P_ID
01 N.Roy Delhi LC03
06 H.Singh Mumbai PC03
12 R.Pandey Delhi PC06
15 C.Sharma Delhi LC03
16 K.Agarwal Bangalore PC01
i) Display the details of item whose price is in the range of
40000 to 70000. 1
ii) Display the name and city of the customers who have
1
purchased laptop.

10
 iii) Display the item name , price and deduction. Deduction 1
is 10% of price.
1
iv) Display the customer name, city, item name, price from
table item, with their corresponding I_ID.
v) Display the highest and lowest price of Personal 1
computer.
Xcelencia Edu Services Ltd. is an educational organisation. It is
40.
planning to set up its campus in Hyderabad with its head office at
Delhi. The Hyderabad campus has 4 main buildings-ADMIN,
SCIENCE, BUSINESS and ARTS. You as a network expert has to
suggest the best network related solutions for their problems raised
in questions (i) to (iv) keeping in mind the distances between the
buildings and other given parameters.

Shortest distances between various buildings:

ADMIN to SCIENCE 65 m
ADMIN to BUSINESS 100 m
ADMIN to ARTS 60 m
SCIENCE to BUSINESS 75 m
SCIENCE to ARTS 60 m
BUSINESS to ARTS 50 m
DELHI Head Office to
HYDERABAD Campus 1600 km

11
Number of computers installed at various buildings are as follows:
ADMIN 100
SCIENCE 85
BUSINESS 40
ARTS 12
DELHI Head Office 20
1

i) Suggest the most appropriate location of the server inside

the Hyderabad campus (out of the 4 buildings) to get the
best connectivity for maximum n umber of computers.
1
Justify your answer.
ii) Suggest and draw the cable layout to efficiently connect
various buildings within the Hyderabad campus for 1
connecting the computers.
iii) Which hardware device will you suggest to be procured
by the company to be installed to protect and control the 1

Internet uses within the campus?

iv) Which of the following will you suggest to establish the
online face-face communication between the people in
the Admin Office of Hyderabad campus and Delhi Head
Office?
a) E-mail b) Text Chat
1
b) Video conferencing d) Cable TV
v) Suggest the placement of Repeater in the network with
justification.

12
13