BILLABONG HIGH INTERNATIONAL SCHOOL

ANNUAL EXAM-2023-2024
GRADE: XI – A3 Subject: Informatics Practices (065) MARKS: 70
Marks

General Instructions:

1. This question paper contains five sections, Section A to E.

2. All questions are compulsory.
3. Section A has 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each,
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 02 questions carrying 04 marks each.
7. Section E has 03 questions carrying 05 marks each.
8. All programming questions are to be answered using Python Language only.

Section-A
Section A consists of 18 questions of 1 mark each.

1. In …………… memory, once the program or data is written, it cannot be changed?

(A) EEPROM (B) PROM
(C) EPROM (D) None of these

2. The Describe command:

(A) Creates a table (B) Shows structure of a table
(C) Adds a record (D) Deletes a record

3. The superimposition of computer generated perceptual information over the existing physical surroundings is
called as
(A) Immersive Experiences (B) Virtual Reality
(C) Augmented Reality. (D) Machine Learning.

4. A ………….. is an unmanned aircraft which can be remotely controlled or can fly autonomously through
software-controlled flight plans in their embedded systems, working in conjunction with onboard sensors and
GPS.
(A) Drone (B) Cyborg
(C) Humanoids (D) None of the these

5. Which of the following statement is used to iterate over a range of values or sequence?
(A) if (B) if-else
(C) if-elif-else (D) for

6. What will be the output of the following code : 82%7+ 127-16**0.5

(A) 271.0 (B) 128.0
(C) 391.0 (D) 145.0

7. A condition or check applicable on a field or set of fields

(A) Constraint (B) Keyword
(C) Clause (D) None of these

8. To remove duplicate rows from the results of an SQL SELECT statement, the …………… included.
(A) UNIQUE (B) DISTINCT (C) ONLY (D) SINGLE

1|Page
 9. Which property of a relation is used to represent number of columns?
(A) Key (B) Attribute (C) Degree (D) Cardinality

10. You don’t have to pay for Python and you can view its source code too. It means Python is ………….
(A) Free and open source (B) Freeware
(C) Open source (D) Shareware

11. Sahib wants to delete a primary key constraint from the table. Select an appropriate command which help him
(A) Create (B) Alter (C) Drop (D) Delete

12. The design of data is known as

(A) Database Schema (B) Data Constraint
(C) Data Dictionary (D) Database Instance

13. What will the output after execution of the following code?
a=11
b=5
if(a%b==0):
print("greater")
if(a//b==0):
print("Example")
else:
print("Soo Sorry")

(A)Example (B)Soo Sorry (C)greater (D)Type Error

14. The format for time in MySQL is

(A) MM:HH:SS (B) HH:MM:SS
(C) SS:MM:HH (D) SS:DD:HH

15. Select the functions performed by a DDL

(A) It should specify the proper data types.
(B) It may define the length of the data items.
(C) It may specify the means of checking the errors in the data. .
(D) All of these

16. Which of the following can be used as valid variable identifiers in python?
(A) Total (B) >sumNum
(C) l Question (D) Addition-2

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): Random Access Memory is volatile and stores data currently in used.
Reason (R): RAM is storage medium that retains its contents ever after the supply of electricity turned off.

18. Assertion (A): Python data structures cannot have duplicate items and do not support ordering.
Reason (R): A statement is an instruction that a Python interpreter can execute.

2|Page
 Section-B
Section B consists of 7 questions of 2 marks each.

19. What are literals? Name the types of literals?

20. Find the errors in following code:
(i) marks = 90 (ii) a = 20
print mark b = a + 10
print a and b
21. Write a program that takes a number and checks whether the given number is odd or even.
22. What is DISTINCT statement? How is it used?
23. Give the difference between virtual reality and augmented reality?
24. Write the full form of : (A) SRAM B) DRAM C) HDD D)CD-RW
25. What will be the output of the following statements?
(i) list1 = [12,32,65,26,80,10] (ii) list1 = [1,2,3,4,5,6,7,8,9,10]
list1.sort( ) list1[::-2]
print (list1) list1[1:3] + list1[3:]

Section-C
Section C consists of 5 questions of 3 marks each.

26. How a computer does works?

27. Write a Python program to enter two lists and merge them. Also display merged list.
28. Write the output for the following Codes:
Employee={"Name":"Raghav","Dept":"Accountant","Salary":3600}
print(Employee.keys())
print(Employee.values())
print(Employee.items())

29. Predict the output of the following:

list1 = ['Delhi', 'Meerut', 'Hapur', 'Agra']
list2 = list1
list3 = list1[:]
list2[1] = 'Mumbai'
list3[3] = 'Chandigarh'
sum=0
for i in (list1,list2,list3):
if i[1] == 'Mumbai':
sum += 5
if i [3] == 'Chandigarh':
sum += 10
print(sum)

3|Page
 30. Write queries with respect to the table Hospital given below :

TABLE : HOSPITAL
Patient_Id Patient_Name Department Charges
P01 Amit ENT 5600
P02 Sunil Ophthal 7000
P03 Rina Ortho 2500
P04 Akash Ortho 9000
P05 Amitabh ENT 4000
P06 Preeti Ortho 5000

(i) Display details of “Ortho” department patient in descending order of names.

(ii) Add a new colmn Docname varchar(20) to the table.

(iii) Delete records of patients whose name starts with “A”

Section-D
Section D consists of 2 questions of 4 marks each.

31. Write output of the following code snippets.

list1 = [123, 'xyz']

list2 =[456, 'abc']
list1.extend(list2)
print("Extended list:",list1) #Statement1
print(list1. index(456)) #Statement2
list1.insert (3, 'Hello')
print(list1) #Statement3
del list1 [2]
print(list1) #Statement4

32. Write SQL queries for (i) to (iv) on the basis of table College-Students :

(i) To display Name, Fee, Gender, Join Year about the College-Students, who have joined before 2010.

(ii) To display the names of College-Students, who are paying Fee more than 30000.

4|Page
 (iii) To display the names of all College-Students in ascending order of their joinyear.

(iv) To display the Name and Fee of Male college-students.

Section-E
Section E consists of 3 questions of 5 marks each.

33. Write the Following mathematical equation as Python Expressions.

x+ y+ z
a) 3x3 + 4x2 + 5x +7 (b)w =
3 √
(c)z= 7 a3 −12ab +6 b2

1
d) w= ( a+ b )x h (e) a x x a y = a(x + y)
2

34. Write a Python program to input ‘n’ names and phone numbers to store it in a dictionary and
to input any name and to print the phone number of the particular name.

35. Write SQL query for the questions that follow based on given table Worker [5]

(i) To display Name and joining date of workers whose salary is greater than 10000.

(ii) To display details of those workers whose name started with ‘N’.

(iii) To display all workers details from worker table order by Name ascending.

(iv) To display Name and Salary of those workers who work in ‘HR’ or ‘Admin Department.

(v) To display the total number of workers who work in Accountant department.

5|Page
 ************ May good fortune smile upon you as you take on this new challenge. ************

6|Page