UDAYA PUBLIC SCHOOL, AYODHYA

FINAL EXAMINATION 2023- 24

CLASS XI SUBJECT: INFORMATICS PRACTICES (065)
TIME: 3 HOURS M.M.70
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have18 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 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each.

Section A
1. 1 Byte equals to = ………………….. Bits
2. Which of the following is not an input device?
a) Keyboard b) Monitor c) Joystick d) Microphone
3. Which of the following is designed to control the operations of a computer?
a) User b) Application Software c) System Software d) Utility Software
4. Which among the following is not a keyword in Python?
a) while b) for c) if d) FOR
5. Assume a dictionary namely d = { "Guido" : "Python", "Dennis": "C"}
To obtain the number of entries in dictionary the statement used is:
a) d.size() b) len(d) c) size(d) d) d.len()
6. What is the value of x after the following code executes?
x=4
while x > 0:
x=x–1
print(x)
7. Which of the following is a type of DDL command in SQL?
(a) DESC (b) Insert Into (c) Update (d) All are correct
8. Which among the following constraint can be applied on multiple columns separately in a table?
a) Primary key b) Unique c) Both (a) and (b) d) None of these
9. Which of the following is known as membership operator in Python?
(a) > (b) not (c) or (d) in
10. A Table namely emp has 9 records and 4 columns, What will be the cardinality and degree of the table?
(a) 4, 9 (b) 9, 4 (c) 8, 4 (d) None of these
11. Which command is used to see the structure of a table/relation:
(a) Show (b) Select (c) Describe (d) Order by
12. Which operator performs pattern matching in MY SQL?
a) BETWEEN operator b) LIKE operator c) EXISTS operator d) None of these
13. IOT stands for _______.
a) Internet of Things b) Intranet of Things c) Intellectual of Things d) None of the above
14. Example of Artificial Intelligence:
a) Google Assistant b) Cortana c) Alexa d) All of the above
15. _____________ is a three-dimensional, computer-generated situation that simulates the real world.
a) Immersive experiences b) Augmented Reality c) Virtual Reality d) None of the above
16. See the below expression and choose correct option :
X=2**3**2
Statement 1: The execution of expression is according to the precedence of operators.
Statement 2: Value of X will be 512.
a) Only Statement 1 is true. b) Only Statement 2 is true.
c) Both Statement 1 and 2 are true. d) Both Statement 1 and 2 are false.
17. The input() always returns a value of type:
a) Integer b) String c) Float d) Complex
18. Choose correct option from the following:
D1={ ’A’: ’CS’, ‘B’ : ’IP’}

Page 1 of 3
Statement 1: Output of print ( D1[‘b’]) is IP.
Statement 2: Dictionary is a collection of key-value pairs. It is not a sequence.
a) Only Statement 1 is true. b) Only Statement 2 is true.
c) Both Statement 1 and 2 are true, but Statement 2 is not correct reason of Statement 1.
d) Both Statement 1 and 2 are true, but Statement 2 is correct reason of Statement 1.
Section B
19. Give one example of each of the following software’s:
(i) Spread sheet software
(ii) DBMS
(iii) Programming Language
(iv) System software
20. What is the use of Not Null constraint in MY SQL, explain with the help of an example.
21. Find Output of following code:
x = [1,5]
x.append(5)
x.append(8)
x.remove(8)
print(x)
22. Rewrite the following code in python after removing all syntax error(s). Underline each correction done
in the code.
10=N
for x in range(1,N)
if k%4 = 0:
print (K*4)
else
print (K+3)
23. Kavita has created a new table STUDENT with 5 columns and 4 rows. Two more records were added in
the table and one column is deleted. What will be the Degree and Cardinality of the table Employee after
these modifications?
24. What some characteristics of MY SQL?(Write any 4)
25. What is NLP? Write one example of NLP.
OR(QNO. 25 only)
Define the following( Any two)-
i) Cloud computing ii) Machine Learning iii) Block chain technology Grid Computing

Section C
26. An organization wants to create a table EMPLOYEE to maintain following details about its employees.
EMPLOYEE (dob, Name, Address, Department, EmployeeID)
i) Name the column of Employee, table which can be used as primary key and why.
ii) The company wants to retrieve details of employees, which command should be used?
iii) Company wants to add a new column in the employee table, Which command should be used.
27. Which Command /Clause/Operator is used to do the following -
a) Change information in the table. c) To open the database d) To give range in the query.
28. Write a program to calculate and display the sum of all the even no’s between 2 to 20.
29. Write program to get a no and check whether number is even or odd.
30.Write down SQL statement for creating table LIBRARY having following specifications:
i. BOOK_ID – int(5), primary key of the table
ii. BOOK_TITLE – char(20)
iii. AUTHOR— char(20)
iv. QTY – int(8)
v. PRICE – float(10,2)
Section D
31. Consider the table Pet and answer the following queries:

Page 2 of 3
(i) SELECT name, owner FROM pet WHERE owner LIKE “%e%”;
(ii) SELECT name, Owner FROM pet WHERE birth>=’1995-01-01’;
(iii) SELECT Owner FROM pet where Death=”1995-07-30” ;
(iv) SELECT name FROM pet WHERE Owner like “D%” and species=”Dog”;
(v) SELECT * FROM pet where birth between ‘1989-05-13’ and ‘1998-09-11’;
32. Find Output
my_dict = {'name': 'Jack', 'age': 26}
my_dict['age'] = 27
my_dict['salary']=5000
my_dict['address'] = 'Downtown'
print(my_dict.keys() ) 2
print(my_dict.items() ) 2
print( len(my_dict) ) 1
33. Look at the LIBRARY table below and answer the questions from (i) to (v) :

i) Insert the following record in the above relation:

(10009, ”Motivational Songs”, 15, 70)
ii) To display name and price of those CDs whose price is between 100 and 150.
iii) To display information of those CDs whose quantity is more than 15 and price is less than 100.
iv) To display the record of “Best Birthday Songs” CD.
v) To Display details of those CDs whose name starts with “I”.
Section E
34. Find the Correct Output
List = [1, 2, 3, 4, 5, 6, 7, 8, 9]
print(List[3:9:2])
print(List*2)
print(List[:3] )
print(List[::-1])
35. Define all the DDL and DML commands of MY SQL with example of each.

Page 3 of 3