MBOSE Class 11 Question Paper 2020 for Informatics Practices

Total No. of Printed Pages ––9 (2)
HS/XI/A.Sc.Com./IP/20
(ii) What will be the output of the following
expression?
2020
a = 10
INFORMATICS PRACTICES b=4

( Theory ) c=a%b

(a) 2.5
Full Marks : 70
(b) 2.0
Time : 3 hours
(c) 2

The figures in the margin indicate full marks for the questions (d) 3.0

General Instructions :
(iii) The head ( ) function is used to fetch first _______
(i) Write all the answers in the Answer Script. rows from Pandas Series object.

(a) 2
(ii) Attempt all the Questions.
(b) 3

(c) 4
1. Choose the correct answer from the following 1 6  6
(d) 5
(i) A ________ is a special type of a computer software
that can translate the source code into an object
code or machine code. (iv) A _______ is a pandas data structure which stores
data in two-dimensional way.
(a) Utilities
(a) List
(b) Language processor
(b) Series
(c) Application software
(c) Dictionary
(d) Packages.
(d) DataFrame.

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

(3) (4)

(v) Which of the following key is used to represent (v) What is a database system?
the relationship between two tables?
(vi) What is the significance of Pandas Library?
(a) Primary Key

(b) Foreign Key
3. Answer the following questions in brief: 2 4  8
(c) Alternate Key

(d) Candidate Key (i) What are operators in Python script? What are
their function?

(vi) _______ is a small piece of data sent from a website (ii) What is system software? What role does it play
and stored in a user’s web browser while a user in the functioning of the computer?
is browsing a Website.
(iii) What will be the output of the following
(a) spam
expression?
(b) viruses
(a) “MYSTRY” [:4]
(c) cookies

(d) Digital Footprint (b) “pine” in “Pineapple”

(iv) How are individual elements of Dictionaries
accessed?
2. Answer the following questions in not more than two
sentences: 1 6  6
(i) What is GPU?
4. Answer the following: 33  9
(ii) What are literals in Python?
(i) What are language processors? Differentiate
(iii) What are Python Lists? between Interpreter and Compiler.
(iv) Write the statement to create a series for the given
list : (ii) What are the built-in core data types of Python?
What are Numeric types? How many numeric
L=[3, 4, 5,] data types does Python provide?

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

(5) (6)

(iii) Write the output of the following code fragments: 6. Answer the following questions : 23  6
x = 15 (i) What is the purpose of head ( ) and tail ( ) of
y=5 Series object? 2
while x>y : (ii) How is Series data structure different from a
Print (x, y) dataframe data structure? 2
x=x–2
(iii) Write the syntax to add a column to the
y=y+2 dataframe. Give one example. 2
Or

Write a program that asks the user to input a 7. Answer the following: 32  6
year and to find out whether it is a leap year or
not. (i) Write Python code to create a series object TEMP1
that stores maximum temperatures of seven days
in it. Take any random Seven temperatures. 3
5. Answer the following: 42  8
Or
(i) What is the difference between append ( ) and Consider following Series objects. 3
insert ( ) methods of list. Explain with examples.
S1 S2
Or
0 4 0 5
Write a Python program to input three integers 1 10 1 2
and find out the largest integer.
2 5 2 20
3 7 3 4
(ii) Draw a block diagram depicting organization of a
4 20 4 3
mobile system.

Or (a) What will be the result of S1**2
(b) What will be the result of S1 + S2
Explain get ( ) and update ( ) methods of Dictionary
(c) What will be the result of S1 – S2
with examples.

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

(7) (8)

(ii) How do you read/load a CSV file in a database. 9. Answer the following: 22  4
Give one example. 3
(i) What is Primary Key? What is Primary Key constraint? 2
Or
(ii) Write the purpose and example of each MYSQL
Write code segment to display the following from function. 2
a dataframe namely students. 3
(a) Upper( )
(a) Display only column ‘Name’
(b) NOW( )
(b) Display rows from 3 to 7

(c) Display the mark of 5th student, ‘Marks’
column. 10. What is NOSQL database? What are its main features?
List name of four types of NOSQL Databases. 1 + 2 + 1 = 4
8. Answer the following : 4 Or

Write a Python script to create a DataFrame Consider the following TEACHER table and write SQL
namely Teacher storing ‘Name’ and ‘Department’. commands for the following queries. 4
Teacher’s ID Number form the index of the
DataFrame. Add a column to the DataFrame TNO TNAME SALARY DEPT DOJ
namely ‘Salary’. Display the modified DataFrame.
T01 VARUN 25000 PHYSICS 2000/01/01
Or SHARMA
If City is Series type object having the name of T02 RUPAK 25700 COMPUTER 1999/01/05
25 states then, what will be the output of the DAS SCIENCE
following statements. 4
T03 MITALE 30000 COMPUTER 2001/10/01
(a) print (City.head(4))
BARUA SCIENCE
(b) print (City.tail( ))
T04 SHYAMA 24000 CHEMISTRY 2000/02/07
(c) print (City[2:5]) DUTTA

(d) City[9] = ‘Meghalaya’. (a) Display all records from the table TEACHER.

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

(9)

(b) Display all records whose SALARY is more than
25000.

(c) Display the NAME and SALARY of the teachers
whose DEPT is COMPUTER SCIENCE.

(d) Insert a new row in the TEACHER table with
following data:

T05, SUMAN SINHA, 25200,
CHEMISTRY, 2001/04/01.

11. Answer the following questions:
(i) What is Cyber bullying? 2

(ii) What are Super Cookies? 2

(iii) What is phishing? How is pharming different from
phishing? 2

(iv) What are different types of threats to computer
security? Explain any one of them. 1+2=3



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