AGARWAL VIDYA VIHAR, SURAT

ANNUAL EXAMINATION (2023-24)

Class : XI Subject :Informatics Practices Marks : 70

Date :11-03-2024 RE-EXAM Duration:3 hrs.
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 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 Long Answer type questions carrying 05 marks each.
8. All programming questions are to be answered using Python Language only.

Section – A
1. Identify the interface that allows user to run program or give instructions to the
computer in the form of icons, menus and other visual options.
(a) Graphical User Interface
(b) Character User Interface
(c) Touch Based Interface
(d) Voice Based Interface
2. Nimish has joined an organization which uses only Open Source Software. Help him to
identify which software he cannot use in his organization.
(a) Python (b) Libre Office (c) JAVA (d) Tally
3. Which of the following is not the part of a Processor?
(a) Arithmetic Logic Unit (b) Cache
(b) Control Unit (d) None of these
4. Collection of 4 bits is called ___________.
(a) Bit (b) Kilo byte (c) Byte (d) Nibble
5. What is the minimum possible length of an identifier?
(a)16 (b)1 (c) 64 (d) 8
6. Which of the following is not an example of cloud storage?
(a)Google Drive (b)Microsoft Access (c) iCloud (d) All of these
7. Smallest unit of python programming language is called?
(a) Literal (b) Token (c) Identifier (d) Operator
8. Which of the following commands will create a list?
(a) list1 = list( ) (b) list1 = [ ]
(c) list1 = list([True, False, True]) (d) All the mentioned
9. Which of the following searches for an element in a list and returns its frequency?
(a) search( ) (b) count( ) (c) index( ) (d) lsearch( )

1
10. dict1 = {'A':95,'C':89,'D':92,'E':85}
dict1['B'] = 78
print( dict1)
The result is-
(a) {'A': 95, 'B': 78,'C': 89, 'D': 92, 'E': 85} (b) {'A': 95, 'C': 89, 'D': 92, 'E': 85, 'B': 78}
(c){'B': 78,'A': 95, 'C': 89, 'D': 92, 'E': 85} (d) {'A': 95, 'C': 89, 'D': 92, 'E': 85},{'B': 78}
11. Choose the incorrect statement related to Where clause:
(a) It is used to filter records
(b) It is used to retrieve data that meet some specified conditions
(c) It is used with SELECT statements as well as with INSERT statements
(d) It is used with arithmetical as well as logical operators.
12. A student wants to delete a tuple from a table in MYSQL, which of the following
categories of MYSQL helps him in doing the same:
(a) DML (Data Manipulation Language)
(b) DDL (Data Definition Language)
(c) DCL (Data Control Language)
(d) TCL (Transaction Control Language)
13. Ms. Ruchi has developed a web application using MySQL and Python. To run this
application online, she availed a pre-configured Apache server from cloud having
MySQL and Python pre-installed. Which type of cloud computing model she has used:
(a) IaaS (b) PaaS (c) SaaS (d) DaaS
14. Consider the following SQL statement, What type of statement is this?
ALTER TABLE Employee MODIFY Name VARCHAR(25) ;
(a) DML (b) DDL (c) DCL (d) TCL
15. “Imagine what if our bulbs, fans and refrigerator also become a part of LAN or Internet.
Think about of the advantages and tasks that can be accomplished if all these devices
with smart connectivity features are able to communicate amongst themselves and we
are also able to communicate with them using computers or smart phones.”
In your opinion, which feature are we talking about in the above context?
(a) AR (b) VR (c) WoT (d) IoT
16. Mr. Malhotra is working on MySql table named Student with the following table
schema:

Which of the following command is used to get the above output:

(a) Create (b) Describe (c) Show (d) Alter

2
Q17 and Q 18 are ASSERTION and REASONING based questions. Mark the correct choice
as
(a) Both A and R are true and R is the correct explanation of A.
(b) Both A and R are true and R is the not correct explanation of A.
(c) A is true but R is false.
(d) A is false but R is true.

17. Assertion (A): Dictionary is an example of ordered collection.

Reason (R): Keys are used to retrieve values from a dictionary.

18. Assertion (A): A database can have multiple tables in MySql.

Reason (R): If a piece of data is stored in two places in the databases, then storage space
is wasted.

Section –B
19. Write down the type of memory needed to do the following:
i) To execute the program
ii) To store the instructions which cannot be overwritten.
20. Suggest the corresponding Python Statement of the following:
i) Assign 30 to a variable length and 40 to a variable breadth.
ii) Assign multiplication of length and breadth to a variable area
OR
Rewrite the following code in python after removing all syntax error(s). Underline each
correction done in the code.
25 = To
WHILE Number<=100:
if Number=>75
print (Number)
Number=Number+10
else
print( Number*2)
Number=Number+50

21. Name the SQL command used to

(a) Physically delete a table from a database.
(b) Display the structure of a table.
22. Differentiate between Degree and Cardinality of a realtion.
23. What is NULL value in MySQL? Explain with an example.
OR
DAV Sports Management Committee has decided to conduct cricket matches between
students of class XI and Class XII. Students of each class are asked to join any one of the
four teams — Team Titan, Team Rockers, Team Magnet and Team Hurricane. During
summer vacations, various matches will be conducted between these teams. Help your
sports teacher to do the following:
3
Create a table “TEAM” in MySQL with following considerations:
i) It should have a column TeamID for storing an integer value between 1 to 9, which
refers to unique identification of a team.
ii) Each TeamID should have its associated name (TeamName), which should be a string
of length not more than 10 characters.
iii) It should have a column MatchDate.
iv) It should have a column of number of participants namely, TeamParticipants.
24. Write command to create table STOCK with the following structure:
Name of ItemID Item_Name Price Supplier_ID
Column
Type Number(4) Varchar(30) Float(9,2) Varchar(10)
Ensure the following specification in created table:
 ItemID should be declared as Primary Key
 Supplier_ID must not remain Blank
 Price must be grater than zero.
25. Define the following terms : (a) Alternate Key (b) Order By Clause

Section –C
26. Consider the following table- Employee
EmpNo EName DOJ Job Salary Gender
101 Raj Kumar 1998-08-17 Clerk 34000.00 M
102 Bina Rai 1997-11-24 Manager 75000.99 F
103 Amir Khan 1991-02-27 Salesman 30000.00 M
104 Kuldeep Dutta 1997-01-23 Salesman 28999.99 M
105 Jatin jain 1998-12-31 Accountant 55000.00 M
106 Mita Singh 2001-01-01 Clerk 27000.00 F
107 Vimal Jain 2001-10-31 Manager 85000.00 M
(i)Write SQL Queries for the following:
a) To display all jobs available in the table whose salary is 30000.00.
b) To display details of all female employee who are manager.
c) To display details of all names end with ‘a’.
OR
Write SQL commands for the following:
Table : Books
BID Bname Price Publisher Author
1001 Starts with Python 300 Sultan Chand Preeti Arora
1002 The Hunger Games 550 Scholastic Suzanne Collins
1003 Mahashweta 350 Penguin Books India Sudha Murthy

1. Write primary key for the table ‘Books’.

2. Increase the Price for BID as 1002 by 200 Rs.
3. Change the data type for Publisher to varchar(30).

4
27. (i) Name any two areas where the concept of block chain technology can be useful.
(ii) Differentiate between Virtual Reality and Augmented Reality.

28. What is the difference between selective statement and iterative statement? Explain
through example.
OR
Write a python program to print sum of following series :
1+x+x2+x3+x4+……..+xn

29. What do you mean by data inconsistency and data redundancy?

30. (i) Give any two examples of RDBMS software.

(ii) Write MySQL command, which is used to open an already existing database
“Alumni”.
(iii) Ms. Mansi has created a database, a month ago, but he is not sure whether
the database still exists or not. Write the command to help her.
Section – D
31. Imagine you are a graphic designer who relies on software like Photoshop for your
work. One day, you are assigned a project to create a series of advertisements for a
client's new product launch. As you start working on the designs, you realize that the
software is not functioning properly and is constantly crashing.
How do you handle this situation? Do you try troubleshooting the software on your
own, or do you seek help from IT support? How do you ensure that the project is
completed on time despite the technical difficulties? What strategies do you implement
to prevent this situation from happening again in the future?

32. Carefully go through the code given below and answer the questions based on it
L=[ 2, 3, 4, 5, 6, 7]
print(L)
L.__________(4) #line1
x=L.________(3) #line2
print(“Deleted element from list is”, x)
print(34 in L) #line3
print(L.sort( )) #line4
L1=L*2
print(L1)

1. Which of the following function is used to return the index value from the list in line 1.
A. index( ) B. append( ) C. add( ) D. insert( )

2. Which of the following functions is used to delete an element from the list in line 2?
A. pop ( ) B. del C. remove( ) D. del( )

3. What will be the output of the expression given in line 3?

A. No Output B. False C. True D. Error
5
4. What will be the output of the expression given in line 4?
A. [2,3,4,5,6,7] B. [2,4,5,6,7] C. [7,6,5,4,3,2] D. None

Section – E
33. Write a program to input n numbers in a list and insert those numbers in another list
which are divisible by 3 and 5 both. Print both lists.
OR
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) Increse the value of commission by 5000.
iii) Change value of product from Laptop to Tablet
iv) Delete Commission from the list.
v) Print minimum sale
34. Consider the following dictionary:
states={‘D’: ‘Delhi’ , ‘K’ : ‘Kerala’ , ‘T’ : ‘Tamil Nadu’ , ‘B’ : ‘Bihar’}
Write Python statements for the following:
i) To insert (‘M’ : ‘Mumbai’) in the dictionary states.
ii) To return the value corresponding to the key ‘T’
iii) To return the length of the dictionary states.
iv) To delete the item from the dictionary corresponding to the key ‘K’
v) To delete the dictionary ‘states’

35. Consider the table ‘Teacher_Details’ given below and write suitable SQL queries of the
following:
Table: Teacher_Details
T_ID T_Name T_DOJ T_Subject Num_of_Periods
1001 Bharti 2018-10-15 Hindi 27
1002 Pratima NULL NULL 32
1003 Savitri 2012-11-13 Hindi 29
1004 Aashna 2020-02-24 English 28
i) Display the T_Name and Num_of_Periods by increasing the number of
periods each by 1.
ii) Display T_Name of all those teachers whose date of joining is after 1st Jan
2019.
iii) Display T_ID and T_Name of all those teachers whose number of periods are
in the range of 25 to 30. (both values included )
iv) Display the details of all those teachers who have not assigned any subject.
v) Display the details of all those teachers whose subject is either Hindi or
Science
OR
6
i) A relation ‘Order’ has the following attributes:
(Order_No, Order_Name, Order_date, Order_Qty, Order_price)
a) Write a command to insert a single row in the table mentioned above.
(Assume appropriate values)
b) Name the attribute which should be taken as the Primary Key?
ii) Ms. Nia wants to retrieve values in descending order from the attribute ‘Order_price’
from the table ‘Order’ mentioned in Q(i). Which clause should she use to
retrieve the same?
iii) Is Null same as ‘ ‘ (a blank space in quotes) in MySql? Write reason to support your
answer.
iv) % and _ are used with _____________ operator in MySQL.