[1]
Class: XII Session: 2023-24
Computer Science (083)
Sample Question Paper (Theory)
Time allowed: 3 Hours Maximum Marks: 70
General Instructions:
Please check this question paper contains 35 questions.
The paper is divided into 4 Sections- A, B, C, D and E.
Section A, consists of 18 questions (1 to 18). Each question carries 1 Mark.
Section B, consists of 7 questions (19 to 25). Each question carries 2 Marks.
Section C, consists of 5 questions (26 to 30). Each question carries 3 Marks.
Section D, consists of 2 questions (31 to 32). Each question carries 4 Marks.
Section E, consists of 3 questions (33 to 35). Each question carries 5 Marks.
All programming questions are to be answered using Python Language only.
Que
s No
Question
Marks
SECTION A
1
State True or False:
“In a Python program, if a break statement is given in a nested loop, it
terminates the execution of all loops in one go.”
1
2
In a table in MYSQL database, an attribute A of datatype varchar(20)
has the value “Keshav”. The attribute B of datatype char(20) has value
“Meenakshi”. How many characters are occupied by attribute A and
attribute B?
a. 20,6
b. 6,20
c. 9,6
d. 6,9
1
3
What will be the output of the following statement:
print(3-2**2**3+99/11)
a. 244
b. 244.0
c. -244.0
d. Error
1
4
Select the correct output of the code:
1
[2]
Options:
a. PYTHON-IS-Fun
b. PYTHON-is-Fun
c. Python-is-fun
d. PYTHON-Is -Fun
5
In MYSQL database, if a table, Alpha has degree 5 and cardinality 3, and
another table, Beta has degree 3 and cardinality 5, what will be the degree
and cardinality of the Cartesian product of Alpha and Beta?
b. 8,15
d. 15,8
1
6
Riya wants to transfer pictures from her mobile phone to her laptop. She
uses Bluetooth Technology to connect two devices. Which type of network
will be formed in this case?
a. PAN
b. LAN
c. MAN
d. WAN
1
7
Which of the following will delete key-value pair for key = “Red” from a
dictionary D1?
a. delete D1("Red")
b. del D1["Red"]
c. del.D1["Red"]
d. D1.del["Red"]
1
8
Consider the statements given below and then choose the correct output
from the given options:
pride="#G20 Presidency"
print(pride[-2:2:-2])
1
[3]
Options:
a. ndsr
b. ceieP0
c. ceieP
d. yndsr
9
Which of the following statement(s) would give an error during execution of
the following code?
tup = (20,30,40,50,80,79)
print(tup) #Statement 1
print(tup[3]+50) #Statement 2
print(max(tup)) #Statement 3
tup[4]=80 #Statement 4
Options:
a. Statement 1
b. Statement 2
c. Statement 3
d. Statement 4
1
10
What possible outputs(s) will be obtained when the following code is
executed?
Options:
a.
1
[4]
RED*
WHITE*
BLACK*
b.
WHITE*
BLACK*
c.
WHITE* WHITE*
BLACK* BLACK*
d.
YELLOW*
WHITE*WHITE*
BLACK* BLACK* BLACK*
11
Fill in the blank:
The modem at the sender’s computer end acts as a ____________.
a. Model
b. Modulator
c. Demodulator
d. Convertor
1
12
Consider the code given below:
1
[5]
Which of the following statements should be given in the blank for
#Missing Statement, if the output produced is 110?
Options:
a. global a
b. global b=100
c. global b
d. global a=100
13
State whether the following statement is True or False:
An exception may be raised even if the program is syntactically correct.
1
14
Which of the following statements is FALSE about keys in a relational
database?
a. Any candidate key is eligible to become a primary key.
b. A primary key uniquely identifies the tuples in a relation.
c. A candidate key that is not a primary key is a foreign key.
d. A foreign key is an attribute whose value is derived from the primary
key of another relation.
1
15
Fill in the blank:
In case of _____________ switching, before a communication starts, a
dedicated path is identified between the sender and the receiver.
1
16
Which of the following functions changes the position of file pointer and
returns its new position?
a. flush()
b. tell()
c. seek()
d. offset()
1
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
[6]
(c) A is True but R is False
(d) A is false but R is True
17
Assertion(A): List is an immutable data type
Reasoning(R): When an attempt is made to update the value of an
immutable variable, the old variable is destroyed and a new variable is
created by the same name in memory.
1
18
Assertion(A): Python Standard Library consists of various modules.
Reasoning(R): A function in a module is used to simplify the code and
avoids repetition.
1
SECTION B
19
(i) Expand the following terms:
POP3 , URL
(ii) Give one difference between XML and HTML.
OR
(i) Define the term bandwidth with respect to networks.
(ii) How is http different from https?
1+1=
2
20
The code given below accepts a number as an argument and returns the
reverse number. Observe the following code carefully and rewrite it after
removing all syntax and logical errors. Underline all the corrections made.
2
[7]
21
Write a function countNow(PLACES) in Python, that takes the
dictionary, PLACES as an argument and displays the names (in
uppercase)of the places whose names are longer than 5 characters.
For example, Consider the following dictionary
PLACES={1:"Delhi",2:"London",3:"Paris",4:"New
York",5:"Doha"}
The output should be:
LONDON
NEW YORK
OR
Write a function, lenWords(STRING), that takes a string as an argument
and returns a tuple containing length of each word of a string.
For example, if the string is "Come let us have some fun", the
tuple will have (4, 3, 2, 4, 4, 3)
2
22
Predict the output of the following code:
2
23
Write the Python statement for each of the following tasks using BUILT-IN
functions/methods only:
(i) To insert an element 200 at the third position, in the list L1.
(ii) To check whether a string named, message ends with a full stop
/ period or not.
1+1=
2
[8]
OR
A list named studentAge stores age of students of a class. Write the
Python command to import the required module and (using built-in
function) to display the most common age value from the given list.
24
Ms. Shalini has just created a table named “Employee” containing
columns Ename, Department and Salary.
After creating the table, she realized that she has forgotten to add a primary
key column in the table. Help her in writing an SQL command to add a
primary key column EmpId of integer type to the table Employee.
Thereafter, write the command to insert the following record in the table:
EmpId- 999
Ename- Shweta
Department: Production
Salary: 26900
OR
Zack is working in a database named SPORT, in which he has created a
table named “Sports” containing columns SportId, SportName,
no_of_players, and category.
After creating the table, he realized that the attribute, category has to be
deleted from the table and a new attribute TypeSport of data type string
has to be added. This attribute TypeSport cannot be left blank. Help Zack
write the commands to complete both the tasks.
2
25
Predict the output of the following code:
2
[9]
SECTION C
26
Predict the output of the Python code given below:
3
27
Consider the table CLUB given below and write the output of the SQL
queries that follow.
CID
CNAME
AGE
GENDER
SPORTS
PAY
DOAPP
5246
AMRITA
35
FEMALE
CHESS
900
2006-
03-27
1*3=
3
[10]
4687
SHYAM
37
MALE
CRICKET
1300
2004-
04-15
1245
MEENA
23
FEMALE
VOLLEYBALL
1000
2007-
06-18
1622
AMRIT
28
MALE
KARATE
1000
2007-
09-05
1256
AMINA
36
FEMALE
CHESS
1100
2003-
08-15
1720
MANJU
33
FEMALE
KARATE
1250
2004-
04-10
2321
VIRAT
35
MALE
CRICKET
1050
2005-
04-30
(i) SELECT COUNT(DISTINCT SPORTS) FROM CLUB;
(ii) SELECT CNAME, SPORTS FROM CLUB WHERE
DOAPP<"2006-04-30" AND CNAME LIKE "%NA";
(iii) SELECT CNAME, AGE, PAY FROM CLUB WHERE
GENDER = "MALE" AND PAY BETWEEN 1000 AND
1200;
28
Write a function in Python to read a text file, Alpha.txt and displays
those lines which begin with the word ‘You’.
OR
Write a function, vowelCount() in Python that counts and displays the
number of vowels in the text file named Poem.txt.
3
29
Consider the table Personal given below:
Table: Personal
P_ID
Name
Desig
Salary
Allowance
P01
Rohit
Manager
89000
4800
1*3=
3
[11]
P02
Kashish
Clerk
NULL
1600
P03
Mahesh
Superviser
48000
NULL
P04
Salil
Clerk
31000
1900
P05
Ravina
Superviser
NULL
2100
Based on the given table, write SQL queries for the following:
(i) Increase the salary by 5% of personals whose allowance is known.
(ii) Display Name and Total Salary (sum of Salary and Allowance) of
all personals. The column heading ‘Total Salary’ should also be
displayed.
(iii) Delete the record of personals who have salary greater than 25000
30
A list, NList contains following record as list elements:
[City, Country, distance from Delhi]
Each of these records are nested together to form a nested list. Write the
following user defined functions in Python to perform the specified
operations on the stack named travel.
(i) Push_element(NList): It takes the nested list as an
argument and pushes a list object containing name of the city and
country, which are not in India and distance is less than 3500 km
from Delhi.
(ii) Pop_element(): It pops the objects from the stack and displays
them. Also, the function should display “Stack Empty” when there
are no elements in the stack.
For example: If the nested list contains the following data:
NList=[["New York", "U.S.A.", 11734],
["Naypyidaw", "Myanmar", 3219],
["Dubai", "UAE", 2194],
["London", "England", 6693],
3
[12]
["Gangtok", "India", 1580],
["Columbo", "Sri Lanka", 3405]]
The stack should contain:
['Naypyidaw', 'Myanmar'],
['Dubai', 'UAE'],
['Columbo', 'Sri Lanka']
The output should be:
['Columbo', 'Sri Lanka']
['Dubai', 'UAE']
['Naypyidaw', 'Myanmar']
Stack Empty
SECTION D
31
Consider the tables PRODUCT and BRAND given below:
Table: PRODUCT
PCode
PName
UPrice
Rating
BID
P01
Shampoo
120
6
M03
P02
Toothpaste
54
8
M02
P03
Soap
25
7
M03
P04
Toothpaste
65
4
M04
P05
Soap
38
5
M05
P06
Shampoo
245
6
M05
Table: BRAND
BID
BName
M02
Dant Kanti
M03
Medimix
M04
Pepsodent
M05
Dove
1*4=
4
[13]
Write SQL queries for the following:
(i) Display product name and brand name from the tables PRODUCT
and BRAND.
(ii) Display the structure of the table PRODUCT.
(iii) Display the average rating of Medimix and Dove brands
(iv) Display the name, price, and rating of products in descending order
of rating.
32
Vedansh is a Python programmer working in a school. For the Annual
Sports Event, he has created a csv file named Result.csv, to store the
results of students in different sports events. The structure of Result.csv
is :
[St_Id, St_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, Vedansh 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.
4
SECTION E
[14]
33
Meticulous EduServe is an educational organization. It is planning to setup
its India campus at Chennai with its head office at Delhi. The Chennai campus
has 4 main buildings – ADMIN, ENGINEERING, BUSINESS and MEDIA
Block to Block distances (in Mtrs.)
From
To
Distance
ADMIN
ENGINEERING
55 m
ADMIN
BUSINESS
90 m
ADMIN
MEDIA
50 m
ENGINEERING
BUSINESS
55 m
ENGINEERING
MEDIA
50 m
BUSINESS
MEDIA
45 m
DELHI HEAD
OFFICE
CHENNAI
CAMPUS
2175 km
Number of computers in each of the blocks/Center is as follows:
ADMIN
110
ENGINEERING
75
BUSINESS
40
MEDIA
12
DELHI HEAD
20
a) Suggest and draw the cable layout to efficiently connect various blocks of
buildings within the CHENNAI campus for connecting the digital devices.
1*5=
5
[15]
b) Which network device will be used to connect computers in each block to
form a local area network?
c) Which block, in Chennai Campus should be made the server? Justify your
answer.
d) Which fast and very effective wireless transmission medium
should preferably be used to connect the head office at DELHI with the
campus in CHENNAI?
e) Is there a requirement of a repeater in the given cable layout? Why/
Why not?
34
(i) Differentiate between r+ and w+ file modes in Python.
(ii) 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
(i) How are text files different from binary files?
(ii) A Binary file, CINEMA.DAT has the following structure:
{MNO:[MNAME, MTYPE]}
Where
MNO – Movie Number
MNAME – Movie Name
MTYPE is Movie Type
Write a user defined function, findType(mtype), that accepts mtype
as parameter and displays all the records from the binary file
CINEMA.DAT, that have the value of Movie Type as mtype.
2+3=
5
35
(i) Define the term Domain with respect to RDBMS. Give one example
to support your answer.
1+4=
5
[16]
(ii) Kabir wants to write a program in Python to insert the following record
in the table named Student in MYSQL database, SCHOOL:
rno(Roll number )- integer
name(Name) - string
DOB (Date of birth) – Date
Fee – float
Note the following to establish connectivity between Python and
MySQL:
Username - root
Password - tiger
Host - localhost
The values of fields rno, name, DOB and fee has to be accepted from
the user. Help Kabir to write the program in Python.
OR
(i) Give one difference between alternate key and candidate key.
(ii) Sartaj has created a table named Student in MYSQL database,
SCHOOL:
rno(Roll number )- integer
name(Name) - string
DOB (Date of birth) – Date
Fee – float
Note the following to establish connectivity between Python and
MySQL:
Username - root
Password - tiger
Host - localhost
[17]
Sartaj, now wants to display the records of students whose fee is more than
5000. Help Sartaj to write the program in Python.