ANGELS’ ACADEMY SENIOR SECONDARY SCHOOL
QUESTION BANK – ANNUAL EXAMINATION (2023-24)
SUBJECT: INFORMATICS PRACTICES (065)
CLASS: XI
1. Who has developed Python programming Language? In which year it was developed?
2. On what basis python has been named?
3. Explain any three merits of Python.
4. Explain any three demerits of Python.
5. Why Python is called a cross-platform language?
6. Give full form of Python’s IDLE.
7. What do you mean by IDE? Explain.
8. Name a few Python IDEs.
9. Why Python is called an interpreted language?
10. Does Python support UNICODE?
11. What are tokens? List all tokens in Python.
12. What are keywords? Explain. List a few keywords available in Python.
13. What do you mean by identifiers? Give any four rules to define an identifier.
14. What are literals? List all literals in Python.
15. How do you form string literals in Python?
16. Explain how you can use single line and multiline strings in Python.
17. What do you mean by complex literal? How will you write a complex value, explain with an example?
18. List Boolean literal?
19. What is “None”?
20. What do you mean by comments? How will you add inline, single line or multiline comments in Python?
21. What is a block in python? How is a block created in Python, explain with example?
22. How many spaces are used to define an indentation level?
23. Define variable in Python? How a variable does created?
24. What will happen if variable holding a value of integer type assigned another value of string type?
25. What do you mean by lvalue and rvalue? Give an example.
26. Give an example each of following:
i. Assigning same value to multiple variables.
ii. Assigning multiple values to multiple variables.
27. What is dynamic typing?
28. What is Database?
29. Why Database System is better than traditional file system. Give two reasons.
30. Write one similarity and one difference between UNIQUE and PRIMARY KEY constraints.
31. Write one similarity and one difference between CHAR and VARCHAR data types.
32. Write the UPDATE command to increase the commission (Column name : COMM) by 500 of all the Salesmen who
have achieved Sales (Column name : SALES) more than 200000. The table’s name is COMPANY.
33. Is it possible to have primary key and foreign key in one table? Justify your answer.
34. A table can have maximum how many primary keys and foreign keys?
35. Write two examples of DBMS software.
36. How is NULL value different from 0 (zero) value ?
37. Sharmila wants to make the database named ‘COMPANY’ active and display thenames of all the tables in it. Write
command for it.
38. Give two characteristics of Primary Key.
39. Explain the purpose of DDL and DML commands used in SQL.
40. What is the Purpose of Drop Table command in SQl?How is it different form Delete Command?
41. What is the use of UPDATE statement in SQL ? How is it different from ALTER statement ?
42. What is significance of Joins in Sql?
Page 1 of 6
43. What is EquiJoin ?
44. What is advantage of DBMS?
45. What is Relation in RDBMS?
46. What is Other name of ROW and Column in RDBMS?
47. What is Degree and Cardinality of a Relation in RDBMS.
48. Write syntax for create table in Sql.
49. Define the termsi) DDL ii) DML
50. Write short notes on relational model
51. Define tuple and attribute, relation, Domain.
52. What do you mean by keys? What are the various kinds of keys in a relational database? Explain them.
53. Consider the following tables MobileMaster and MobileStock and answer (bl) and (b2) parts of this question:
Write SQL commands for the following statements:
a) To create the table MobileMaster with the Primary key as M_Id.
b) To create the table MobileStock with Primary Key as S_Id and foreign key as M_Id referring to
MobileMaster(M_Id).
c) Insert the first row into Table MobileMaster.
d) Insert the first row into MobileStock.
e) To display all records of table MobileMaster
f) To display all records of table MobileStock.
g) To display Company name, mobile name, manufacturing date and supplier name from the tables.
h) To display name of the mobiles and their prices which are manufactured after “01-01-2015”.
i) To update the supplier name for the mobile “Unite3” as “New Horizon”.
j) To display all the details of mobile company in ascending order of their mobile manufacturing date.
k) Delete an entry from MobileMaster Table for items having price greater than 5000.
l) Delete an entry from MobileStock Table for supplier name “The Mobile”
m) Delete the table MobileMaster.
n) Delete the table MobileStock.
54. Explain the use of input() function with an example.
55. List some of the cloud-based services that you are using at present.
56. What do you understand by the Internet of Things? List some of its potential applications.
57. Write a short note on the following:
(a) Cloud computing
(b) Big data and its characteristics
58. Explain the following along with their applications.
(a) Artificial Intelligence
(b) Machine Learning
Page 2 of 6
59. Differentiate between cloud computing and grid computing with suitable examples.
60. Justify the following statement-
‘Storage of data is cost effective and time saving in cloud computing.’
61. What is on-demand service? How it is provided in cloud computing?
62. Write examples of the following:
(a) Government provided cloud computing platform
(b) Large scale private cloud service providers and the services they provide
63. A company interested in cloud computing is looking for a provider who offers a set of basic services such
as virtual server provisioning and on-demand storage that can be combined into a platform for deploying
and running customized applications. What type of cloud computing model fits these requirements?
(a) Platform as a Service
(b) Software as a Service
(c) Infrastructure as a Service
(d) Application as a Service
64. Which is not one of the features of IoT devices?
(a) Remotely controllable
(b) Programmable
(c) Can turn themselves off if necessary
(d) All of the above
65. If Government plans to make a smart school by applying IoT concepts, how can each of the following be
implemented in order to transform a school into IoT enabled smart school?
(a) e-textbooks
(b) Smart boards
(c) Online tests
(d) Wi-Fi sensors on classrooms doors
(e) Sensors in buses to monitor their location
(f) Wearables (watches or smart belts) for attendance monitoring
66. Five friends plan to try a start-up. However, they have a limited budget and limited computer
infrastructure. How can they avail the benefits of cloud services to launch their start-up?
67. Governments provide various scholarships to students of different classes. Prepare a report on how block
chain technology can be used to promote accountability, transparency and efficiency in distribution of
scholarships?
68. How IoT and WoT are related?
69. What type value is returned by input() function? If the integer or float values are to be input write an
example statement how will you use input() function?
70. Identify the types of following literals:
i. 23.789 ii. False iii. “True” iv. 34.71E-4 v. None vi. 4+3j 3 25
71. Identify valid or invalid identifiers:
i. True ii. Student-Name iii. IF iv. PRINT v. 1stAge vi. Number1
72. Find out the error in following code:
Salary= input(“Salary :”)
Bonus=10/100 * Salary
Print (“Bonus”, Bonus)
73. What is dictionary?
74. What will be output of the following code:
d1={1:2,3:4,5:6}
d2=d1.get(3,5)
print(d2)
75. Write the output of the code given below:
d = {"name": "Akash", "age": 16}
d['age'] = 27
d['city'] = "New Delhi"
print(d.items())
Page 3 of 6
76. How is clear() function different from del statement?
77. What will be the output of the following python dictionary operation?
data = {'A':2000, 'B':2500, 'C':3000, 'A':4000}
print(data)
78. What is a key-value pair with reference to Python dictionary?
79. Write the output of the code given below:
80. What are the characteristics of Python Dictionaries?
81. Write the two ways to construct an empty dictionary.
82. Write a Python program to input ‘n’ names and phone numbers to store it in a dictionary and to search
and print the phone number of that particular name.
83. Write a statement in Python to declare a dictionary whose keys are 1, 2, 3 and values are Jan, Feb and
Mar respectively.
84. Write the output of following code:
x = {1:10, 2:20, 3:30}
x[2]=25
print(x)
85. Write the output of following code:
x = {1:10, 2:20, 3:30}
x[4] = 20
print(x)
86. Write the output of following code:
d = {'x': 1, 'y': 2, 'z': 3}
for k in d:
print (k, '=', d[k])
87. Write the output of following code:
d = {'x': 1, 'y': 2, 'z': 3}
for k in d.keys():
print (k, '=', d[k])
88. Write a program to enter names of employees and their salaries as input and store them in a dictionary.
89. Write the output for the following codes.
A= (10:1000,20:2000,30:3000,40:4000, 50:5000}
print A.items()
print A.keys()
print A.values()
90. Write 3 methods to import a module with an example.
91. Predict the output:
Page 4 of 6
92. Write a program to read 6 numbers and create a dictionary having keys EVEN and ODD. Dictionary's value
should be stored in list. Your dictionary should be like:
{'EVEN':[8,10,64], 'ODD':[1,5,9]}
93. Write a program to input roll numbers and their names of students of your class and store them in the
dictionary as the key-value pair. Perform the following operations on the dictionary:
a) Display the Roll numbers and name for all students.
b) Add a new key-value pair in this dictionary and display the modified dictionary
c) Delete a particular student's record from the dictionary
d) Modify the name of an existing students.
94. Give the output of the following code:-
list=['p','r','o','b','l','e','m']
list[1:3]=[]
print(list)
list[2:5]=[]
print(list)
95. Give the output of the following code:-
l1=[13,18,11,16,13,18,13]
print(l1.index(18))
print(l1.count(18))
l1.append(l1.count(13))
print(l1)
96. WAP in python to create a list of natural numbers from 1 to 50 using for loop.
97. WAP in python to take two lists of same size and create a third list of same size with adding elements at
the same location of 1st & 2nd list. E.g. if A=[1,2,3], B= [4,5,6], then C[5,7,9].
98. WAP in Python to accept any ten numbers from the user in a list and display the maximum number along
with its position.
99. WAP in Python to calculate & display the factorial of an integer list.
100. Predict the output of the following code in python:
T1=(1,)*3
T1[0]=2
print(T1)
101. Predict the output of the following code in python:
TupleA=’m’,’n’
TupleB=(‘m’,’n’)
print(TupleA==TupleB)
102. WAP in Python to create a phone dictionary for your ten friends and then print them in format:
name of friend : mobile number
103. Predict the output of the following code in python:
Fruit ={ }
L=*‘Orange’,’Apple’,’Grapes’+
for index in L:
If index in Fruit:
Fruit[index]+=1
else:
Fruit[index]=1
print(len(Fruit))
print(Fruit)
104. WAP to display sum of even numbers up to number n entered by user.
Page 5 of 6
105. T1=(100,200,”global”,3,3.5,”exam”,*1,2+,(30,40),3,5,3))
Consider the above tuple T1 and answer the following question:
(a) t1[-8:-4] (b) 20 not in T1 (c) T1.index(5) (d)T1[2]*2 (e) T1[5:]
106. What is malware? Explain virus, worms and Trojans.
107.
(i) This email is an example of which cyber-crime?
(ii) What may happen if user will reply to email?
(iii) Is this mail is a spam?
(iv)What is cyber-crime?
(v)Give any one tip that help in preventing these type of attacks.
108. Differentiate between using example:
1) if / else 2) for / while 3) break /continue
109. What is the difference between compiler and interpreter?
110. What is the difference between mutable and immutable? Explain with example.
111. What is a cross-platform software?
112. Write the following operators according to the precedence rule : or, and, not, <>, *, **, ()
113. What will be the output produced by following code?
a = 5-4-3
b=3**2**3
print(a)
print(b)
114. Start with the list[8,9,10].
Do the following using list functions
(a) Set the second entry (index 1) to 17
(b) Add 4, 5 and 6 to the end of the list.
(c) Remove the first entry from the list.
(d) Sort the list.
(e) Double the list.
(f) Insert 25 at index 3
115. State the differences between Iteration and Recursion.
Page 6 of 6
