PRE BOARD EXAMINATION

INFORMATICS PRACTICES (065)

Class: XI
Time: 3 HOURS M.M.: 70
General Instructions:
• Please check this question paper contains 37 questions.
• All questions are compulsory. However, internal choices have been provided in some
questions. Attempt only one of the choices in such questions
• The paper is divided into 5 Sections- A, B, C, D and E.
• Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
• Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
• Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
• Section D consists of 2 case study type questions (33 to 34). Each question carries 4 Marks.
• Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
• All programming questions are to be answered using Python Language only.
• In case of MCQ, text of the correct answer should also be written.

Section-A (21 x 1 = 21 Marks)

Consider the given list: L=[‘Delhi’,’Mumbai’,’Kolkata’,’Chennai’], What L[3:2] returns?
Q1. 1
a. Empty List b. [‘Chennai’,’Kolkata’] c. [‘Chennai’] d. [‘Kolkata’,’Chennai’]
The startup program that loads the operating system into primary memory, is stored in:
Q2. 1
a) RAM b) ROM c) CU d) ALU
____ are certain types of restrictions on the data values that an attribute can have.
Q3. 1
a. Data type b. Constraints c. Data Consistency d. Data Redundancy
Write output of the expression, 3 % 22?
Q4. 1
a) 3 b) 7.3 c) 22 d) None of these
Which of the following is not correct about data type in MySQL?
a. Data type indicates the type of data value that an attribute can have.
b. The data type of an attribute decides the operations that can be performed on the data of
Q5. 1
that attribute.
c. Arithmetic operations can be performed on numeric data but not on character data.
d. Data type of at least two attributes in a table should be same.
What will be the output of the following Python code?
a=[13,56,17]
[Link]([87])
Q6. [Link]([45,67]) 1
print(a)
a) [13, 56, 17, [87], 45, 67] c) [13, 56, 17, 87, 45, 67]
b) [13, 56, 17, 87,[ 45, 67]] d) [13, 56, 17, [87], [45, 67]]
Candidate key – Primary key = ____________
Q7. 1
a. Alternate Key b. Foreign Key c. Candidate Key d. Primary Key
Which for loop statement will produce first 5 odd numbers?
Q8. a) for x in range(1,9,2): c) for x in range(9, 1, -2): 1
b) for x in range(1,10,2): d) None of these

Page 1
 We can use ______ statement to remove a database permanently from the system.
Q9. 1
a. Remove b. Delete c. Drop d. Cut
Predict the output of given expression:
Q10. >>> 25 // 8 + (40%7) **3 1
a) 8 b) 128 c) 18 d) 8.125
Can we insert two records with the same roll number? Identify the most appropriate
option from the following.
a. Yes, we can if roll number is not a primary key.
Q11. 1
b. No, we can not
c. Yes, we can if roll number is a primary key.
d. No, we cannot if roll number is not a primary key
1. What is the primary goal of Big Data technology?
a) To process small datasets quickly
Q12. b) To analyze and extract insights from extremely large and complex datasets 1
c) To develop autonomous machines
d) To connect devices to the internet
The size of computer drastically reduced due to :
Q13. 1
a) Transistors b) Resistors c) Integrated Circuits d) Capacitors
Consider the given dictionary?
d={‘Dispur’:’Assam’, ‘Mumbai’ : ‘Maharasthra’, ’Indore’:’Madhya Pradesh’}
Q14. 1
What will be the output of print([Link](‘Indore’))
a. Error b. Madhya Pradesh c. 2 d. Indore
A robot vacuum cleaner that senses obstacles and cleans the floor automatically uses:
Q15. 1
a) AI and IoT b) Big Data c) Blockchain d) Cloud Computing
1. What technology enables access to computing services like storage, databases, and
Q16. processing power over the internet? 1
a) Blockchain b) Machine Learning c) Cloud Computing d) Robotics
A data analyst needs to increase the salary of all employees in the Accounts department
by 10%. The department name is stored in the DeptName column. Which SQL command
achieves this task?
Q17. a) Update Employee Set Salary = Salary + 10 Where DeptName= ‘Accounts’ ; 1
b) Update Employee Set Salary= Salary + Salary*0.10 Where DeptName = ‘Accounts’;
c) Insert Into Employee Values (Salary * 0.10);
d) Alter Table Employee Modify Salary = Salary * 0.10
What will be the output of the following code?
A={1:'Java', 2: 'Python', 3: 'C++'}
Q18. 1
print(A[2] + A[1])
a) PythonJava b) 2: ‘Python’, 1: ‘Java’ c) 21 d) Error
Predict the output of the following:
a,b,c=10,5,12
Q19. a,b,c=a+b, b+c, c%8 1
print(a,b,c)
a) 15, 17, 4 b) 10, 5, 12 c) 17, 15, 8 d) Error

Page 2
 Q-20 and Q-21 are Assertion (A) and Reason (R) Type questions. Choose the correct option 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
Q20.
Assertion (A): The input() function in Python always returns data in string form.
Reason (R): The input() function converts the user input to integer automatically. ( C)
Q21.
Assertion (A): A primary key uniquely identifies each record in a table.
Reason (R): Two records in a table can have the same primary key value. ( C)
Section-B (7 x 2 = 14 Marks)
(a) What will be the output of the following Python code?
data = {"a": 10, "b": 20, "c": 30}
data["b"] = data["b"] + 5
print(data)
{'a': 10, 'b': 25, 'c': 30}

(b) Predict an output of the following code: 1+1

Q22.
L1, L2=[2,4],[3,6] =2
L3=list(L2)
L2[1]=5
print(L2)
print(L3)
[3, 5]
[3, 6]
Differentiate between DDL and DML statements with examples

DDL (Data Definition Language) DML (Data Manipulation Language)

Changes the structure of the database Changes the content of the database
Q23. Works on database schema -tables, Works on Actual data stored in tables 2
columns, constraints, etc.
Examples ; CREATE, ALTER, DROP Examples : INSERT, UPDATE,
DELETE

"Hardware is of no use without software and software cannot be used without hardware."
Explain.

Q24. Because both are interdependent components of a computer system. 2

Hardware refers to the physical parts of a computer and Software refers to a set of
programs or instructions that tell the computer what to do. A computer without software
is just a collection of electronic parts and cannot perform operations.
Evaluate the following:
Q25. (i) 3 ** 3 // 2+ 7 % 4 * 5 28 2
(ii) (50 - 5 * 3) / 5 == 7 and (8 + 2) * 3 <= 30 True

Page 3
 Pratima wants to use the database Employee which was created yesterday, but she was
getting the following error:
No database selected
a) Help her to write the SQL commands to resolve this error.
b) Write SQL command to create the database.
Q26. 2
a) The error No database selected occurs because no database has been
chosen/opened before executing SQL commands.
b) Create Database <database name>;
Create Database Employee;
Use Employee; (to open database)
How is blockchain technology helpful in maintaining transparency?
In blockchain, data is stored across multiple computers. Every participant has access to the
same ledger, so transactions are visible to all authorized users. Once a transaction is
Q27. 2
recorded in a block and added to the blockchain, it cannot be altered or deleted.
All participants can view and verify transactions and no single authority can secretly
change data, blockchain ensures a high level of transparency.
a) Suppose there is a computer with RAM but no secondary storage. Why we are not able
to install software on that computer?
Installing software means saving programs permanently so that they can be used again
after restarting the computer. Since RAM cannot retain data permanently, any software 1+1
Q28.
loaded into RAM would disappear when the computer is shut down. =2

b) Write any two examples of application software.

Examples : MS Word, Power point, Acrobat reader, Photoshop, Spreadsheet etc.

Section-C (4 x 3 = 12 Marks)
a) Find the error of the following code:
x= int(“Enter value of x:”)
for in range [0,10]:
if x=y
print( x + y)
else:
2+1
Q29. Print( x‐y)
=3
b) What will be the output of the following Python code?
a=[13,56,17]
[Link]([87])
[Link]([45,67])
print(a)
[13, 56, 17, [87], 45, 67]
a) Write Python statement that will store marks 78 in variable ip. Increase marks by 5 and
store it in new variable newip and print it.
1+2
Q30. ip = 78 =3
newip = ip + 5
print(newip)

Page 4
 b)Write Python program to accept and character at run time and display whether it is
alphabet or number or any special character.

ch = input("Enter a character: ")

if (ch >= ‘A’ and ch<= ‘Z ’) or (ch>= ‘a’ and ch <= 'z'):
print("It is an Alphabet")
elif ch>= ‘0’ and ch <= '9':
print("It is a Number")
else:
print("It is a Special Character")

a) Mention any two applications each of AI and IoT in daily life.

Applications of Artificial Intelligence (AI) – Machine Learning, NLP,

Applications of Internet of Things (IoT) – Smart home, Smart watch, Smart lights,
CCTV
b) What is Big Data? Mention any two characteristics of Big Data.

Big data is a term that describes the large volume of data. It refers to datasets that are so
1+2
Q31. massive, fast-moving, and complex that traditional data processing software can’t handle
them. =3

Five characteristics of big data are: Volume, Velocity, Variety, Veracity, and Value.
Volume
Refers to the huge amount of data generated from sources like social media, sensors, and
online transactions.
Variety
Big Data is generated in multiple [Link] is in the form of photos, videos, and
audios and many more, making about 80% of the data to be completely unstructured

Consider the table ‘Teacher_Details’ given below and write suitable SQL queries of the
following:
Table: Teacher
T_ID TName T_DOJ Subject Periods
1001 Bharti 15-10-18 Hindi 27
1002 Pratima NULL NULL 32
1003 Savitri 13-11-12 Hindi 29
Q32.
1004 Aashna 24-02-20 English 28

a. Display the TName and Periods by increasing the number of periods each by 1.
Select TName, Periods + 1 From Teacher ;
b. Display TName of all those teachers whose date of joining is after 1st Jan 2019.
Select TName From Teacher Where T_DOJ > “2019-01-01” ;

Page 5
 c. Display T_ID and TName of all those teachers whose number of periods are in the
range of 25 to 30. (both values included )
Select T_ID, TName From Teacher Where Periods Between 25 and 30 ;
Or
Select T_ID, TName From Teacher Where Periods >= 25 and Periods <=30 ;
d. Display the details of all those teachers who have not assigned any subject.
Select * From Teacher Where Subject IS NULL ;
e. Display T_ID, TName and Periods in descending order of Periods.
Select T_ID, TName From Teacher Order By Peirods ;

Section-D (2 x 4 = 8 Marks)
Give the terms used for the following:
i. Collection of logically related records. Relation or Table
ii. A file having description about data stored into the database. Meta data
iii. A special value that can be used to hold unknown values. Null ½
Q33. iv. A field which can identifies distinct records but not a primary key. Alternate key x8 =
v. A constraint that does not allow to leave any blank cell in table. Not Null 4
vi. Name data type used to store alpha numeric values. Char /Varchar
vii. Numbers of tuples in a relation. Cardinality
viii. Name of operator used for pattern matching. Like operator
Write the output of the following Python code:
i) a,b=[1,2], [11,22]
print(a+b) Ans: [1, 2, 3, 11, 22, 33]
ii) cname=['India', 'Japan', 'China', 'Nepal']
print(cname[-1][-3])
Ans : p
iii) print([1,2,3,4]>[4])
Ans : False
iv) lst=list("Robot")
print(lst)
Ans:['R', 'o', 'b', 'o', 't']
v) d = {'a':100, 'b':200, 'c':300} ½
print(d['b'])
Q34. x8 =
Ans : 200
4
vi) d = {'x':10, 'y':20, 'z':30}
print([Link]('y'))
print([Link]('w'))
Ans: 20
None
vii) d = {'name':'Riya', 'age':17}
d['class'] = 'XII'
print(len(d))
Ans: 3
viii) d = {'x':1, 'y':2, 'z':3}
print([Link]('y'))
print(d)

Page 6
 Ans: 2
{'x': 1, 'z': 3}
Section-E (3 x 5 = 15 Marks)
Consider the following list:
MYLIST=[“LIST”, “IS”, “AN”, “ORDERED”, “OF", “DATA”]
Write python statements to perform the following operations:
a) To access the word “ORDERED” from the given list.
b) To replace the word given at position 2 by the word “MUTABLE”.
c) Reverse the list.
d) Insert a word “SEQUENCE” after “ORDERED” in the list.
Q35.
e) Display elements of the list present at the index numbers 2 to 4. 5

a) print(MYLIST[3])
b) MYLIST[2] = "MUTABLE"
c) [Link]() or MYLIST = MYLIST[::-1])
d) [Link](4, "SEQUENCE")
e) print(MYLIST[2:5])

Consider a table ‘Pet’ given below:

Table: Pet
PetID PetName Type Age OwnerName Fees
101 Bruno Dog 5 Aarav 500
102 Kitty Cat 2 Meera 300
103 Goldy Fish 1 Sarthak 150
104 Tweety Bird 3 Ria 250
105 Rocky Dog 4 Karan 550
106 Snowy Rabbit 2 Kavya 400

Q36. a. Display the PetName, Type, and Age of pets whose Type is either Dog or Cat. 5
b. Display pets whose Age is between 2 and 4 in ascending order of age.
c. Show the OwnerName and PetName, sorted by OwnerName.
d. Display all OwnerName whose name has “ar” anywhere.
e. Change the name of Owner ‘Ria’ to ‘Rya’

a. Select PetName, Type, Age From Pet Where Type IN ( ‘Dog’, ‘Cat’) ;
Or
b. Select PetName, Type, Age From Pet Where Type =‘Dog’ or Type= ‘Cat’ ;
c. Select * From Pet Where Age Between 2 and 4 Order by Age ;
d. Select OwberName, PetName From Pet Order by OwnerName ;
e. Select OwnerName From Pet where OwnerName Like “%ar%”;
f. Update Pet Set OwnerName = “Rya” Where OwnerName = “Ria” ;

Page 7
 a) The record of salesman (Name, Item Sold, sale of three quarters and Commission) is
stored in the following list:
Sale=[‘Amit’, ‘Laptop’, [35000,42000,85000],20000]
Write Python statements to retrieve the following information from the list Sale:
i. Print the sale of 2nd Quarter.
ii. Add 56000 as sale of 4th quarter.
iii. Change value of product from Laptop to Tablet
iv. Delete Commission from the list
i. print(Sale[2][1])
ii. Sale[2].append(56000)
iii. Sale[1] = 'Tablet'
iv. del Sale[3]

b) What would be the output of the following code:

d={'Aman':20,'Sumit':30,'Dinesh':50,'Suresh':80}
t=d['Aman']
d['Aman']=d['Suresh']
print(d)
Q37. d['Suresh']=t 5
d['Dinesh']=d['Sumit']
print(d)

{'Aman': 80, 'Sumit': 30, 'Dinesh': 50, 'Suresh': 80}

{'Aman': 80, 'Sumit': 30, 'Dinesh': 30, 'Suresh': 20}

c) Differentiate between pop() and del statement of Python.

pop() del statement

Removes an element from a list and Removes an element or deletes a
returns the removed element list/variable
Method of list Python statement
Returns the removed element Does not return anything
Example: Example :
[Link](2) del mylist[2]

Page 8