MBOSE Class 11 Question Paper 2023 for Informatics Practices

Total No. of Printed Pages ––9 (2)
HS/XI/A.Sc.Com./IP/23
(ii) If a = 4, b = 3, and c = 2, what is the output of the
given code
2023
a+=b+c
INFORMATICS PRACTICES print (a)
( Theory )
(a) 8

Full Marks : 70 (b) 9
Time : 3 hours
(c) 10

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

General Instructions :
(iii) The method adds an item to the end of
(i) Write all the answers in the Answer Script. the list
(a) insert ( ) method
(ii) Attempt all the Questions.
(b) append ( ) method
(c) Join ( )

1. Choose the correct answer from the following : 1 6  6 (d) extend ( ) method.

(i) A computer memory measurements of 3 kb
(iv) Which of the following statement is not true for
is = bytes
DBMS?
(a) 3000
(a) It is a collection of interrelated data
(b) 3024
(b) It provides data management
(c) 3072
(c) It consist a set of rules that define valid data
(d) None of these.
(d) It stores all the data in one small file.

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

(3) (4)

(v) Which of the following is not SQL data types? 3. Answer the following questions 2  6  12
(a) BLOB (i) Define Cache Memory and ‘Cache hit’.
(b) DECIMAL
(ii) Give the output of the following code:
(c) STRING
a, b = 15, 3
(d) DATE. d = a%b
print (d)

(vi) Which of the following is not the application of (iii) What is data manipulation language (DML)?
Machine Learning? Name any two DML commands.

(a) Facial Recognition (iv) Explain SELECT command with Syntax.
(b) Surveilience System
(v) Write SQL statement to change the existing
(c) “Self Driving” Vehicles column name ‘ENAME’ of the table ‘Employee’
(d) Drones. to EMP_NAME.

(vi) Differentiate between public and private cloud.
2. Answer the following questions : 1 6  6
(i) Define operating system.
4. Answer the following in three or four sentences
(ii) What is the purpose of primary key in DBMS? (any two) : 3 2  6

(iii) Evaluate the expression 6.2//2 (i) What is system utilities software? Name four
commonly used utility software.
(iv) Define the term “database constraint”.

(v) Name an AI, who has been awarded as citizenship (ii) What is application software? Discuss the two
of Saudi Arabia categories of Application software.

(vi) What do yoy mean by virtual reality? (iii) Differentiate between interpreter and compiler.

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

(5) (6)

5. Answer the following questions (any four) : 3  4  12 6. Answer the following questions (any four) : 3  4  12
(i) What is Relational Operator in Python? How (a) Write SQL command for the following table
strings are compared using relational operator. (student) as directed below:
Give example.
Table : Student
St_No Class Name Activity-1 Grade-1 Activity-2 Grade-2
(ii) What will be the output for the following code: 101 7 Annu Cricket A Gardening B
x = 10 102 9 June Tennis C Dancing B
x = x + 10 103 6 Bhabok Swimming C Dancing C

x=x–5 104 8 Andrew Cricket B Cooking A
105 8 Juban Football A Singing C
print (x)
106 9 Kerlang Tennis A Gardening B
x, y = x – 2, 22
107 10 John Football B Cooking A
print (x, y)
(i) Display the names of students who are getting
grade ‘C’ in either Activity-1 or Activity-2.
(iii) Write a Python program to check a given number
whether it is positive, negative or zero. (ii) Display all the students names starts with a letter
‘A’.

(iv) What will be the output of the following code? (iii) Select all the student number “St_No”, scored
grade ‘A’ in grade-1.
List1 = [ 23,11, 3, 14, 9 ]
strlist = sorted (List 1)
(b) Create the following table
print (strlist [–1])
Sales
print (strlist [–2])
Item_No Item_Name Quantity Rate Total

(v) What are the built-in core data types of Python?

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

(7) (8)

(i) Write an SQL queries to create the given (b) What do you mean by looping control in a
table ‘sales’, with constraints specified program? Write a Python program to find the
below: multiplication table for a given number. 4
(a) Unique constraint : Item_No
OR
(b) Primary constraint : Item_Name, Rate
Write a Python program to find the sum of all
(ii) Insert two records in to the table.
even natural number and all odd natural
(c) What are the limitations of file system that can numbers separately within a given range. 4
be overcome by a relational DBMS?

(d) Differentiate between the following SQL
commands: 8. Answer the following questions: 42  8
(i) ALTER and UPDATE (a) Briefly explain the different categories of
(ii) DELETE and DROP. commands available in SQL. 4

(e) What is a constraint? What are the different OR
types of constraints?
Write the SQL statements for the following: 4

(i) List the details of those employees who have
7. Answer the following questions: 42  8 four letter name in EMPLOYEE table.
(a) Write a Python program to find the largest among
three numbers entered through Key board (ii) List the details of all employees whose
during run-time. 4 annual salary is between 25,000-40,000.
OR
Explain the following list methods: (iii) To add a column ‘mobile_no’ with data type
4
bigint in Employee table.
(i) remove ( )
(ii) append ( ) (iv) Delete the records of those employee whose
(iii) extend ( ) address is ‘Shillong’ and age is greater than
(iv) pop ( ). 60.

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

(9)

(b) What is data inconsistency? How is it related to
data redundancy? Explain with examples. 4
OR

Define the terms:

(i) Relation

(ii) Attribute

(iii) Degree

(iv) Cardinality.



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