Downloaded from www.tutorialaicsip.

com

Sample Paper 1 Annual Exam(Academic Year 2022-23)

Subject: Informatics Practices(065) Class 11
Time: 3:00 Hours Max. Marks: 70
General Instructions
1. This question paper has 6 pages.
2. This question paper contains five sections, Section A to E.
3. All questions are compulsory.
4. Section A has 18 questions carrying 01 mark each.
5. Section B has 07 Very Short Answer questions carrying 02 marks each.
6. Section C has 05 Short Answer type questions carrying 03 marks each.
7. Section D has 03 Long Answer type questions carrying 05 marks each.
8. Section E has 02 questions carrying 04 marks each. One internal choice is
given in Q35 against part c only.
9. All programming questions are to be answered in Python Language only.

Section –A
1 A computer along with hardware and software together is called _______
a) Hardware Unit c) Computer System
b) Software Unit d) Input Unit
2 1 ZB = ___________
a) 1024 MB c) 1024 PB
b) 1024 GB d) 1024 EB
3 The process of Fetching or retrieving deleted or corrupted and lost data from
secondary storage is known as –
a) Data Recovery c) Restoring Data
b) Data Backup d) Data Deletion
4 Which of the following acts as an interface between the device and operating
systems?
a) Language Processor c) Antivirus Software
b) Device Driver d) Operating System
5 Ansh is working in python interactive mode. He noticed this symbol >>> but forgot
what it is called? Select an appropriate option for him out of these?
a) Python Shell c) Python prompt
b) Python Script d) Python Interpreter

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 1 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

6 Which of the following is a python built-in editor popularly used to write scripts?
a) Jupyter Notebook c) Spyder IDE
b) PyCharm IDE d) CPython IDLE
7 Which of the following statement is not correct about python keywords?
a) Keywords defined by user
b) Keywords cannot be used as an identifier
c) Keywords convey a special meaning to python interpreter
d) Keywords are case-sensitive
8 Which of the following statement is used to iterate over a range of values or
sequence?
a) if c) if-elif-else
b) if-else d) for
9 Which of the following is invalid method for lists?
a) list() c) setdefault()
b) append() d) extend()
10 Which following methods are correct to add element into the dictionary object d?
d={1:’Virat’,2:’Rahul’,3:’Surya’}
a) d[4]=’Hardik’ c) Both a) and b)
b) d.setdefault(4,’Hardik’) d) None of these
11 Which of the following is not RBDMS software?
a) Oracle c) MySQL
b) MS Excel d) MS Access
12 The design of data is known as
a) Database Schema c) Data Dictionary
b) Data Constraint d) Database Instance
13 The SQL statements ends with
a) , b) : c) ; d) “
14 Shiv wants to see the table structure in MySQL. Select an appropriate command to
help him.
a) use c) desc
b) show d) display
15 Sahil wants to delete a primary key constraint from the table. Select an appropriate
command which help him.
a) Create c) Drop
b) Alter d) Delete

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 2 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

16 Rajveer wants to rename column in display result for his query. He has given he
following queries, select correct query for him:
a) select ename, salary*12 Annual Salary from emp;
b) select ename, salary*12 rename “Annual Salary” from emp;
c) select ename, salary * 12 change “Annual Salary” from emp;
d) select ename, salary*12 as “Annual Salary” from emp;
Q17 and Q18 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

(c) A is True but R is False

(d) A is False but R is True

17 Assertion(A): An intelligent machine is supposed to imitate some of the cognitive

functions of humans like learning, decision making and problem solving.
Reasoning(R): In order to make machines perform tasks with minimum human
intervention, they are programmed to create a knowledge base and make
decisions based on it.
Ans.: A
18 Assertion(A):Robots were initially conceptualised for doing repetitive industrial
tasks that are boring or stressful for humans or were labour-intensive.
Reasoning(R): Algorithms are one of the prime components of a robot.
Ans.: C

Section – B
19 What is the purpose of a software? Explain in detail.
Ans.: The purpose of a software is providing an interface between users and
hardware. It allows to work or perform certain tasks with the help of hardware. Some
software make the hardware run. Software allows to process the data from input and
display them on the screen or paper easily.
20 Shiv has written following code into python but he is not able to get the correct
output.
n=int(“Enter number”)
triple=n**3
Print(“Number three times:”,n)

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 3 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

Identify the syntax and logical errors and write the correct code. Underline each
correction.
Ans.:
n=int(input(“Enter number:”))
triple=n*3
print(“Number three times:”,triple)
OR
Do as directed:
i. Assign 5 to a variable x.
Ans.: x = 5
ii. Write statement to compute the square of given number.
Ans.: x=x**2 or x**=2 or x=x*x or
import math
x=math.pow(x,2)
21 Write any four applications of DBMS.
Ans.: Applications of DBMS are as follows:
i) Flight, Bus or Railway reservations
ii) Banking and Finance
iii) School Management
iv) Website development
22 Define the following:
i. Domain – It refers to the pool of values from which the fields can take their
values. It can be set of characters or numbers.
ii. Degree – Degree refers to the number of fields present in the relation.
23 Enlist any four basic MySQL elements and explain any one in detail.
Ans.: Four MySQL elements are as follows:
i) Database
ii) Tables
iii) Data Types
iv) Constraints
OR
Explain the following elements of SQL commands in one line each:
i. Keywords – Keywords are reserved words used to write MySQL Commands.
Example: select, create, alter etc.

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 4 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

ii. Statements – Statements are combination of keywords and user defined

variables to perform a specific task.
Example: create table students ….
iii. Clauses – Clauses starts with a keyword and contains some user defined
variables and conditions. Example: select clause, where clause etc.
iv. Arguments – Arguments are the user defined words used in the MySQL
statement. If follows certain rules and regulations to create SQL statements.
24 Dhruvee has given the following table structure and asked to create a table in

MySQL. Help her by writing create table command to accomplish her task.

Table Name: players

ColumnName datatype size

jersey_no int 2

player_name varchar 20

Matches_played int 3

Runs int 5

Ans.: create table players

(jersey_no int(2),

Player_name varchar(20),

Matches_played int(3),

Runs int(5));

25 What do you mean by constraints? Enlist the constraints supported by MySQL.

Ans.: Constraints are set of rules used for data validations in SQL tables. It ensures

data accuracy and reliability of data in SQL tables.

MySQL supports following constraints:

i) Primary Key iv) Default

ii) Foreign Key v) not null

iii) Unique Key

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 5 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

Section – C
26 Priyam is Class XI student. She is learning some basic commands. Suggest some
SQL commands to her to do the following tasks:
i. To show the lists of existing databases
Ans.: show databases;
ii. Select a database to work
Ans.: use MyDB
iii. Create a new database named Annual_Exam
Ans.: create database Annual_Exam
OR
Observe the following table and write answers for the below given questions:
Table Name: Movie
Movie_id Movie_name Category releasedate Director
M0001 Ghandhi Godse History 2023-01-26 Rajkumar Santoshi
M0002 Faraaz Action 2023-02-03 Hansal Mehta
M0003 Shehzada Drama 2023-02-10 Rohit Dhawan
M0004 Bawaal Null 2023-04-07 Nitesh Tiwari
i) Write command to add movie_id as primary key.
Ans.: alter table movie add primary key (movie_id);
ii) Write command to change the size of category column to 50 characters.
Ans.: alter table movie modify column category varchar(50);
iii) Write command to delete column releasedate
Ans.: alter table movie drop column releasedate;
27 Differentiate between Augmented Reality and Virtual Reality.
Ans.:
Augmented Reality Virtual Reality
The superimposition of computer Virtual Reality (VR) is a three-
generated perceptual information over dimensional, computer-generated
the existing physical surroundings is situation that simulates the real world.
called as Augmented Reality (AR).
It adds components of the digital world to The user can interact with and explore
the physical world, with the associated that environment by getting immersed in
tactile and other sensory requirements it while interacting with the objects and
making environment interactive & other actions of the user.
digitally manipulable.
Location-based AR apps are major forms It found in gaming, military training,
of AR apps. medical procedures, entertainment, social
science and psychology, and engineering
etc.

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 6 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

28 Write any three advantages of DBMS over flat file system.

Ans.: Advantages of DBMS over file systems are as follows:
1) Data Retrieving : User can retrieve data any time using queries easily.
2) Data Redundancy: DBMS reduces duplicate data with the help of primary key.
3) Data Inconsistency: DBMS can maintain same data in different places and
changes can be done in a single file.
29 Define following:
i) Database Schema : The design/skeleton of database that represents the
structure of database, the type of data each column contains, constraints and
relationships among tables is known as database schema.
ii) Database Instance: Once data has been inserted into the database the while
loading data, the state or snapshot of the database is known database instance.
iii) Database Engine: Database engine is the underlying component or set
of programs used by a DBMS to create database and handle various queries
for data retrieval and manipulation.
30 Explain the range() function with its parameters and example.

Ans.: The range() function is used to create a sequence of numbers from the given

start and stop values with an interval of step value. The stop value excludes the last

number. By default start is 0 and step is 1. All parameters for range must be integers.

The step parameter can be positive or negative.

Example: range(5) – will create sequence starting with 0 and ends with 4. Similarly

range(1,5) – will create a sequence starting with 1 and ends with 4. Same as

range(1,7,2) will create a section starting with 1 and ends with 6 with interval of 2.

OR
Write python program to find sum of odd numbers from 1 to 10.
Ans.:
s=0
for i in range(1,11):
s+=i
print(“Sum of 1 to 10 is:”,s)

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 7 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

Section – D
31 Given a list l=[13,14,15,112,125.7,[12,11,10,15],188], answer the following
questions:
a) Write code to print [14,112,[12,11,10,15]]
Ans.: print(l[1::2])
b) Write code to print [13,15,125.7,188]
Ans.: print(l[::2])
c) Write code to print [14,125.7]
Ans.: print(l[1::3])
d) Write code to print [12,11,10,15]
Ans.: print(l[5])
e) Write code to print [188,125.7,15,13]
Ans.: print(l[::-2]) or l[-1::-2]
OR
Write a program to accept n number of elements into the list and print only
palindrome numbers from the list.
Ans.:
#Take input for how many numbers
n=int(input("Enter no. of elements: "))

#Create empty list

l=[]

#Take input elements and append to the list

for i in range(n):
v=int(input("Enter value to add:"))
l.append(v)

print("Palindrome numbers from lists are:")

for i in l:
# Reverse the current number
t=i
rev = 0
while t > 0:
rev = rev * 10 + t % 10
t = t // 10
# compare reverse number with the current number
if rev == i:
print(i)

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 8 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

32 Consider the following dictionary:

od={1:’One’,3:’Three’,5:’Five’,7:’Seven’,9:’Nine’}
Perform the below mentioned operations in the dictionary:
i) Write command traverse a dictionary and print key value in this manner
1 – One
3 – Three
5 – Five
7 – Seven
9 – Nine
Ans.:
od={1:'One',3:'Three',5:'Five',7:'Seven',9:'Nine'}
for i in od:
print(i,"-",od[i])
ii) Write command to print only keys of dictionary
Ans.:
print(d.keys())
iii) Write command to print only the values which doesn’t contain ‘n’
Ans.:
for i in od:
if 'n' not in od[i]:
print(od[i])
iv) Write command to print the corresponding value to the key 7
Ans.: print(d[7])
v) Write command to delete the last element of dictionary
Ans.: od.popitem() or od.pop(list(od)[-1]) or
lk= list(od)[-1]
del od[lk]
OR
Write a program to create a dictionary with rollno, name and marks of n no. of
students and display names of students who have scored more than 90 marks in
any subject.
Ans.:
n=int(input("Enter no. of elements for a dictionary:"))
d={}
for i in range(n):
rn=int(input("Enter roll number:"))
name=input("Enter Name:")
ma=float(input("Enter Marks:"))
d[rn]=[name,ma]
#d={'RollNo':rn,'Name':name,'Marks':ma}
print(d)
for i in d:
if d[i][1]>90:
print(d[i][0])

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 9 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

33 Explain the following with example with respect to MySQL:

i) Putting text into query output
Ans.: Putting text into query output is quite simple task. The text should be written
inside quotes and put comma in between the text.
Example :

ii) Using column aliases

Ans.: Column alias name can be provided by using the keyword AS after column
name in select clause or written directly after the columns enclosed in quotes.
Example:

iii) Perform simple computation in query results

Ans.: Simple calculation can be done in query results directly by using arithmetic
operators into the query.
Example:

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 10 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

iv) Handling null values

Ans.: MySQL provides is and is not operator to handle null values. When null value
is required to be listed in query result, is operator is used. Similarly, if values
except null are required, is not operator will be used.
Example: select * from emp where comm is null or select * from emp where
comm is not null
v) Pattern matching
Ans.: Pattern matching operators are used with like keyword in MySQL. The _ and
% helps to get the desired result. _ specifies the characters and fix position of
particular character where as % specifies any character before % or after %.
Example:
Select * from emp where ename like ‘_m%a’;
This query will return names having second letter m and ends with a such a Smita,
Amita etc.
OR
Consider the below given table and write queries for (i) to (iii) and output of (iv) –
(vii):
Table Name: Pet
Name Owner Species Gender Age
Monty Aditya Dog M 4
Badal Dev Horse M 4
Moti Motisingh Dog M 3
Mittu Harsh Parrot M 2
Pinky Kartvya Cat F 1
Sweety Vyas Cat F 2
i) Display name, owner and gender for all dogs.
Ans.: select name, owner, gender from pet where species=’Dog’;
ii) Display Name, owner and age of all pets whose age is more 2 years.
Ans.: select name, owner, age from pet where age>2;
iii) Display name, owner, gender, and age in double for all pets.
Ans.: select name, owner, gender, age*2 “doubled” from pet;
iv) select name, owner from pet where owner like ‘%ya’;
Ans.:
name owner
----------- --------------
Monty Aditya
Pinky Kartvya

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 11 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

v) select name, age from pet where species = dog and age between 1 and 3;
Ans.:
name age
---------- --------------
Moti 3
vi) select * from pets where species in (‘horse’,’parrot’);
Ans.:
Name Owner Species Gender Age
Badal Dev Horse M 4
Mittu Harsh Parrot M 2
vii) select name, owner, species from pets where gender =’M’ or gender = ‘F’
Ans.:
Name Owner Species
Monty Aditya Dog
Badal Dev Horse
Moti Motisingh Dog
Mittu Harsh Parrot
Pinky Kartvya Cat
Sweety Vyas Cat
34 Kavya is writing a code to compute area of circle. He is not able to complete the
code hence the impartial code he has written looks like following. Fill in the given
blanks and complete the code:
import __________ # Write module name
r=________________ # Write function name to accept value of radius
area= ____________ # Write formula of area of circle with respect to python
______________ # Write message like – “Area of Circle is:”,_________
i) math
ii) int(input(“Enter Radius”))
iii) math.pi*r**2
iv) print(“Area of Circle is:”,area)
35 Convert the following into kilobytes:
a) 30 MB = 30 * 1024 = 30720 KB
b) 40 GB = 40 * 1024 * 1024 = 41943040 KB
c) 1.5 TB = 1.5 * 1024 * 1024 * 1024 = 1610612736 KB
or
2048 Bytes = 2048/1024 = 2 KB

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 12 of 13 www.tutorialaicsip.com

 Downloaded from www.tutorialaicsip.com

Follow this link for more sample papers:

Download sample papers for IP class 11

Facebook|Youtube|Instagram - @ TutorialAICSIP Page 13 of 13 www.tutorialaicsip.com