MBOSE Class 11 Question Paper 2019 for Informatics Practics

Total No. of Printed Pages ––7 (2)
(e) What are the functional components of a digital
computer? 2
2019

INFORMATICS PRACTICES Or
( Theory )
What is the purpose of main memory in a
Full Marks : 70 computer? 2

Time : 3 hours
(f) Differentiate between a compiler and interpreter. 2
The figures in the margin indicate full marks for the questions
General Instructions : (g) What is an identifier? What are the identifier
forming rules of Python? 2
(i) Write all the answers in the Answer Script.
(ii) Answer each Unit questions together at one place. Or

What are literals? How many types of literals are
UNIT–I available in Python? 2

( Marks : 30 )
(h) How is a mutable object different from an
(Programming and Computational Thinking-PCT-1) immutable object? Give one example of each type. 2

1. Answer the following questions: (i) What will be the output of the following code
fragment: 2
(a) Define Hardware. 1
a=5
(b) What are the two categories of system software? 1 while a<8:
Print(a*2)
(c) What is a variable? 1
a=a+1
else: print (a – 2)
(d) What is a Character set? 1

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

(3) (4)

Or (n) Write a Python program to input ‘n’ numbers of
elements and store them in a tuple. 4
What will be the output of the following code
fragment: 2 Or

a, b, c = [1, 2, 3], [1, 2, 3], [6, 2, 3] What are the differences between ‘for loop’ and
x = [a, b, c] ‘while loop’? Explain with examples. 4
print (a + x)

(j) What is meant by traversing a string? 2 UNIT – II
( Marks : 20 )
(k) What is meant by a data type? What are the (Data Handling - DH1)
built-in core data types of Python? How many
numeric data types does Python provide? 3
2. Answer the following questions:
Or
(a) What is Pandas? 1
Write a Python program to swap the contents of
two variables A and B. 3 (b) What is a Pandas Series? 1

(l) Explain the if-else statement with example. 3 Or

(m) What are operators? How many types of operators What is pandas DataFrame? 1
are available in Python? Explain arithmetic
operators with examples. 4
(c) What are the key features of pandas? 2

Or
(d) How can you create a pandas series using a list? 2
Write a Python program to calculate and print
the roots of a quadratic equation. 4 (e) Explain head( ) and tail( ) function in connection
with pandas series. 2

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

(5) (6)

(f) In pandas ‘S’ is a series with following result: 2 (b) List two advantages and disadvantages of using
S=pd.Series ([10, 20, 30, 40]) database system. 2

Write a statement to assign the series index as (c) Differentiate between CHAR and VARCHAR data
a, b, c, d explicitly. types. 2

Or Or

How can you create a pandas DataFrame? 2 Explain ALTER TABLE command. 2
(g) Explain the functions sum(), mean(), and count()
in connection with DataFrame. 3 (d) How is FOREIGN KEY different from PRIMARY KEY? 2

(h) How can you add columns into an existing (e) Consider the following EMPLOYEE table and Write
DataFrame ‘df’. Explain with an example. 3 SQL commands for the given questions. 3

Or Emp_No Emp_Name Designation Date of Salary
joining
How can you add rows into an existing DataFrame 8000 Sharmistha Manager 1990-12-18 45000.00
‘df’. Explain with an example. 3 8010 Ajay Clerk 2004-10-05 15000.00
(i) Explain sorting operation in a DataFrame using 8025 Bina Analyst 1988-01-25 50000.00
example. 4 8030 Rizwan Salesman 1998-05-15 18000.00
Or 8040 Dinesh President 1980-03-02 60000.00
8045 Pankaj Vice President 1985-04-28 55000.00
How can you create a CSV(Comma Separated
value) file and read it in a DataFrame. 4 8050 Kuldeep Clerk 2006-09-17 14000.00

UNIT – III
i. Display all the records from the table
( Marks : 10 ) EMPLOYEE?

(Data Management-1) ii. Display all the records whose Designation is
‘Clerk’?
3. Answer the following questions: iii. Display all the records where the salary is
between 40000 and 55000,
(a) What is a database? 1

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

(7)

UNIT – IV

( Marks : 10 )
( Society, Law and Ethics-1 )

4. Answer the following questions:

(a) What is meant by Cyber safety? 1

Or

What is a Cybercrime? 1

(b) Explain briefly at least two Social Networking sites. 2

(c) What do you understand by identity theft? 2

Or

What measures should one take to avoid and
maintain confidentiality of personal information? 2

(d) What is a computer virus? How it can affect your
computer? 2

(e) Explain three methods to protect your network
from virus. 3

Or
Explain the terms Spyware, Phishing and Spam. 3

