SAMPLE2 CBSE Code :083

PAPER

COMPUTER SCIENCE
Class XI
Time 3 hours Max. Marks : 70

General Instructions
1. This question paper contains two parts A and B. Each part is compulsory.
2. Both Part A and Part B have choices.
3. Part-A has 2 sections
(a) Section-I is short answer questions, to be answered in one word or one
line.
(b) Section-II has two case studies questions. Each case study has 4
case-based sub-parts. An examinee is to attempt any 4 out of the 5
sub-parts.
4. Purt-B is Descriptive Paper.
5. Part-B has three sections
(a) Section-Iis short answer questions of 2 marks each in which two
have internal options question
(6) Section-II is long answer questions of 3 marks each in which two
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 be answered
using Python Language only

Part-A
SECTION-I
Select the most
appropriate option out of the options given for each
question. Attempt any 15
questions from question no. 1 to 21.
1. To specify list of
(a) in
a
values.. Operator is used.
...

1
b) like
(c) between (d) Is
2. SELECT
(a) FORD
UPPER(LOWER FORD")) will display the output.
(c) ford (b) Ford
3. In the (d) fORD
following MySQL command how many rows will be 1
UPDATE person updated:
SET Iname='s,
Fname "'p',
WHERE person_id =
1;
ta) Single row person_id is a primary key *
c) No row (b) Double row
(d) None of the mentioned
d Sraits Co COMPUTER SCIENCE (Class X)

ement is used to delete

Which an
existing row from the 79
DELETE
(b) WHERE
e) MODIFY

(d) None of the table?

data can be stored
C h a r a c t e r

Fixed length string

as
mentioned
(b)
c) Either Fixed or Variable length Variable length string
d None of the mentioned string
. Expand IDLE.
the two modes
are
What of Python. Name
8.
der following Python code:
the foi
Consider the them. 1

Python to insert>>>print"Hello World")

1
Write statement in
a
a 1
. Identify the type of constants of "Hello"comment for the above.
10. A collection of
computers that shares
11. set of rules followed by the all information is called
12. The most popular network www communicating
stands
devices are called 1
3,Which is the smallest network for World W w
14. The structure / Physical (LAN/WAN/PAN/MAN)
layout of any network is called
15. Given the lists
16. Identify the valid L=[1,3,6,82,5,7,11,92],
write the output of
1

(a) 9
arithmetic operator in Python from print(L{2:3)) 1
(b)< the following. 11
(c)** (d) and
17. Write statement in Python to declare a
a
3 and
values are Monday, dictionary whose keys
are 1. 2.
18. Name the built-in
Tuesday and Wednesday
respectively.
an absolute
mathematical function / method that is used to return
value of a number.
19. A tuple is
declared as
abc (3,4,6,9,8)
What will be the value of sum(abc)?
20. If the
following code is executed, what will be the output of the following
code?
name="ComputerSciencewithPython" print(name[3:10))
21.
Rearrange the following terms in increasing order of data transfer rates.
Gbps, Mbps, Tbps, Kbps, bps
SECTION-II
Both the Case study based questions are compulsory. Attempt any 4
8ub-parts from each question. Bach question carries 1 mark.
table :
Consider the following
Table : HOSPITAL
PNo
Name Age Department Date of Adm Charges
1. SandeepP 65 Surgery 23/02/98 300
L2 Ravina_ 24 Orthopedic 01/01/98 200
Check Se COMPUTER
SCAEN Ca
45 Orthopedic 19/02/98
Karan
12 Surgery (91/01/98 2
Tarun
36 ENT 12/01/98
.
7aubin
16 ENT 24/02/98 2
6Ketaki
ge
age for male,
for male
patient's
name,
charges,
patients only
only
1.To displaythe number of patientswith age > 20

II.To count various

departments.

I1 To display patients in each departme.

display the number of
IV. To
names and
charges ot ENT department,
V. To display a record in
is written to update file opened with
a

23. Following code

followingcode # line 1
import
fin=_(stu.dat',, 'rb+) # line 2

try
while true:
#line 3: store file pointer
=fin.tell()
reading the record
position beton
stu=pickle.load(fin)
if stul'marks] in|92,93,94]:
stu marks]+=3
fin. # line 4: place the tile pointer at the next
location of the record

dump(stu,fin) # line 5
Fill in the blanks in line 1, line 2, line 3, line 4 to complete the code.

Part-B
SECTION-1
24. What
is the difference between read() and readlines() funetrou
25. Differenciate MAC
address and IP address.
OR
Explain the network with its
26. goal.
Explain Microwave transmission.
27. Rewrite the
for=20
following programs after removing syntactieal erro
forl=50:
for3-forfor1+for2
prinfor3)
OR
Write a
ingle loop to
"ilet

after
removing leading display all the contents
and trailing
itents ofa
o
text

whitespae
SCIENCE (Class XIl)
MPUTER
81
ython statements to create the following lists:
r e t of 5 fruit names and name it as fruit. 2
1 list
containing 3 strings and 2
II Alist integers and name it as
A 18 stored in variable name. Fill in
store
Mixed.
suitable code to
A
string

Iast 3
characters of that string. print first 3
gnd character are "
int First 3
Last 3
nt(Last
print(
characters are "-
etident1' ha
table 'student1' has 4 columns and 10
rows and 'student2' has 5
A humns and
nd 7 rows. If we take Cartesian
product of these two tables,
what is the degree and cardinality of the resultant table?
between Char vs Varchar data 2
Differentiate

t. type. 2
e the output of the following sql queries: 2
) Select round(1023.432,1);
(2) Select upper( master);
Write a program in Python to read the content of a file story.txt and
33,
count the total words in the file.
2
If file contains "A cow is a pet animal" then the Output should be 6.

SECTION- I
34. Write a fuction readLines() that will the first 5 lines of the file abc.txt
and print the number of characters in each lines. 3
35. A text file contains alphanumerie text(an.txt).write a program that reads
this text file and prints only the numbers or digits from the file. 3
OR
Write a function in python to count the number of lines in a text file
A;
Story.txt which is starting with as alphabet
write commands in SQL for (i)-(ii)
36. Table COACHING is shown below,
and outputfor (iv). (v) FEE PHONE
AGE CITY
ID NAME
34 DELHI 45000 9811076656
P1 SAMEER
35
MUMBAI 54000 9911343989
P2 ARYAN CHENNAI 9810593578
34 45000
P4 RAM
36 BHOPAL 60000 9910139987
P6 PREMLATA INDORE 34000 9912139456
36
P7 SHIKHA DELHI 60000 8110668888
33
P8 RADHA
to display
name in escending order whose age is more
(i) Write a query
than 23. is between 30000
query
details from coaching table where fee
Write
(1)
and 40000
display Te chers name, id and phone number of those teachers
ii) To
name
starts with R
whose
Check Senies MPUTER
SCIENCE
82
in Python,
MakePush(Packa
Class Xi
and Makkepop
a
function
and delete pack
37. Write new package
from
to add a ing tthem ass push and pon list
(package). h e m to act a
considering

perations
Description.
package
data structure
the stack
of OR
of characters implemented as
following stack an
Consider the array of 4
elements
STACK=["A", "J","P". "N"]
the following operation take placo:
Describe the stack
as

I. STACK>POP)

I1. STACK.append(k)
SECTION-III
its academic blocks at Nava P .
MvPace University is setting up
38. is Raipur and
planning to set up a network. The University has 3 academic
and Human Resource
Center as shown in the diagram beow blocks
one
5
Business Biock
Technology
Block

Law Block* HR Centre

Center to Center distances between various blocks/center is as follows

Law Block to business Block 40m
Law Block to business Block 80m
Law Block to HR center 105m
Business Block to technology Block 30m
Business Block to HR Center 35m
Technology blockto HR center lõm
Number of computers in each of the Blocks/Center is as follows:
LawBlock 15
Technology Block 40
HR Center 115
Business Block 25
(a) Suggest the suitable place (i.e. Block/Center) to install the server
most
of this
(D)
University with a suitable reason.
Suggest an ideal layout for
connecting these blocks/centers for a w"
connectivity.
(c) Which device will you these
suggest be
to
placed/installed n
blocks/centers to efficiently connect all the
chin these
blocks/centers. computers***
uk
Check Senies COMPUTER SCIENCE (Class XI) 83
A Suggest the placement ofa Repeater in the network with
The university
justification.
(e) is planning to connect its
admission office in Delhi,
which is than 1250km from
more
university. Which type of network
out of LAN, MAN, or WAN wiBl be formed? Justify your answer.
19, Write SQL commands on the basis of the following tables. 5
Table : PRODUCT
PID Product name Manufacturer Price
TPO1 Talcum Powder LAK 40
FW05 Face Wash ABC 45
BSO1 Bath Soap ABC 55
SHO6 Shampo00 XYZ 120
FW12 Face Wash XYZ 95
(1) Display details of those products whose manufacturer is "ABC".
(2) Display details of products whose price is in range of 50 to 100.
(3) Display Product Name and Price from table Product where product
name starts with "B".
(4) Inerease the price of all products by 10.
(5) Display details of products in ascending order of price.
40. Consider a binary file
ename: salary(seperator:).
Employee.dat containing details such as empno:
5
Write a python function to display details of those employees who are
earning between 20000 and 40000 (both values inclusive).
OR
Write a method in python to write multiple lines of text contents into a
text file daynote.txt line.
nRATO