MBOSE Class 11 Question Paper 2022 for Informatics Practices

Total No. of Printed Pages ––8 (2)
HS/XI/A.Sc.Com./IP/22
(ii) is a new universal coding standard
developed by the Unicode Consortium
2022
(a) ASCII
INFORMATICS PRACTICES
(b) ISCII
( Theory )
(c) UNICODE

Full Marks : 70 (d) None of the above.

Time : 3 hours
(iii) What will be the output of the following :

The figures in the margin indicate full marks for the questions a=2

General Instructions : a, b = a + 2, a + 4
Print (a)
(i) Write all the answers in the Answer Script.
Print (b)
(ii) Attempt all the Questions. (a) 4, 6
(b) 0, 8
(c) 2, 4
1. Choose the correct answer from the following 1 6  6 (d) 4, 3

(i) NumPy Arrays come in forms
(iv) What will be the output for the following code
(a) One
S=pd.Series [‘Jan’, ‘Feb’, ‘March’, ‘April’, ‘May’,
(b) Two ‘June’] print S[1:3]

(c) Three (a) Jan
Feb
(d) Four
(b) Feb

(3) (4)

(c) March (iii) Define a Tupule?
April
(iv) Create a series ‘A’, having values
(d) Jan [42, 46, 7.2, A]
(v) How can you detect missing values in a
Dataframe?
(v) Which of the following is not a cybercrime
(vi) What is the purpose of the Unique Key
(a) Cyber trolls Constraint?

(b) Phishing
3. Answer the following 2 4  8
(c) Cyber stalking
(i) What are Software Libraries? Name the libraries
(d) Social Networking
that is supported by Python.

(ii) Differentiate between Mutable and Immutable
(vi) Which of the following is false for SQL statements/ types in Python.
commands.
(iii) Give the output for the following code
(a) SQL statements are case sensitive
a, b, c = 4, 2, 6
(b) Keywords cannot be abbreviated or split d = a+b*c/b
across lines
Print (d)
(c) SQL statements can be on one or more lines
(iv) N = int (input (‘Enter number’)).
(d) A command can be written in full or only Sum = 0
first four characters.
i =1
While i < = N:
Sum = Sum + i
2. Answer the following 1 6  6
i=i+2
(i) What is CDMA? Print (sum)

(ii) Name the string types supported by Python. What will be the output if the input value is 5?

(5) (6)

4. Answer the following: 33  9 6. Answer the following questions with (10-15) words:
23  6
(i) Differentiate between a calculator and a computer.
(i) Briefly explain the different data structures in
(ii) Write a Python Program to reverse the objects of Pandas.
a List [ 3, 4, 7, – 6, 4, 3.2 ] and find their sum.
(ii) How do you create a series from a dictionary.
(iii) Draw a flowchart to check if a given number is
zero, positive or negative.
(iii) Considering the series

>>> S =pd. Series ([2, 4, 6, 8, 10])
5. Answer the following:
Find the output of the statements:
(i) What are tokens? Explain with examples the (i) >>> S [1 : 3 ], (ii) >>> S.head (2)
different types of tokens in Python. 4

(ii) Write Python code to generate Fibonacci Series
till 10. 4 7. Answer the following: 32  6
Or (i) What is a CVS File? How can we read a CVS file
with specific columns. Give examples.
Write down True or False for the following
statements. (ii) Considering the following dataframes. Explain
add ( ), sub ( ) and rsub ( ) function.
(a) Cache memory is faster than main memory. 1
dfB1 dfB2
(b) The memory unit that communicates directly First Second Third First Second Third
with the CPU is called Auxillary Memory. 1
0 10 4 40 0 12 14 20
(c) BIOS is responsible for low level system task 1 20 5 70 1 14 15 35
when the computer boots up. 1 2 30 6 80 2 20 17 40
3 40 7 65 3 17 19 45
(d) Mobile Operating System uses voice User
Interface. 1

HS/XI/A.Sc.Com./IP/22 HS/XI/A.Sc.Com./IP/22

(7) (8)

8. Answer the following : 10. Create the following tables: 4
1 4  4
A dictionary ‘Section’ contains the following data Cust_No. Cust_Name Address
Section = {‘Name’ : [‘Amanda’, ‘Grace’, ‘Amy’, Order_No. Cust_No. Order_item Order_date
‘Jyoti’, ‘Healther’],
‘Class’: [ ‘6A’, ‘6B’, ‘6C’, ‘6D’, ‘6E’]}
With constraints specified below:
Write down the statements for the following
(i) Primary keys : Order_No., Cust_No.
(i) Create a Dataframe called Sec.
Foreign key : Cust_No.
(ii) Find the output of Sec. iloc [0:3] (ii) Insert at least two records in each table
(iii) Add a column called ‘Address’ with the values
[‘Malki’, ‘Laban’, ‘Donbosco’, Nongrim’, ‘None’]
11. Answer the following:
(iv) Delete the 2nd and 4th rows.
(i) What is a Firewall? 2

9. Considering the given relations, answer the following: (ii) What are the damages caused by Adware? 2
2 2  4
R. No. Name Section Marks (iii) What is Digital Footprint? 2
100 Annie A 70 (iv) What is Private Browsing? What are the different
101 Sophia B 65 ways in which you can use the internet without
102 Clarin C 40 revealing your search history and data. 1+2=3

103 Manisha D 80
104 Andrea A 95
105 Sania B 85 

1. Write SQL Commands to list student details
belonging to section A.

2. Which column should be considered most
appropriate as Primary key.

HS/XI/A.Sc.Com./IP/22 HS/XI/A.Sc.Com./IP/22