SESSION ENDING EXAMINATION 2026 (Theory)
Class – XI
Informatics Practices (Code No. 065)
Session: 2025-26
Time allowed: 3 Hours Maximum Marks: 70
General Instructions
- All questions are compulsory.
- This question paper contains five sections – Section A to Section 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 questions (33 to 34). Each question carries 4 marks.
- Section E consists of 3 questions (35 to 37). Each question carries 5 marks.
- There is no overall choice. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions.
- All programming questions are to be answered using Python Language only.
- In case of MCQ, write the option number along with the text of the correct answer.
Section A (21 × 1 = 21 Marks)
| Q. No. | Question | Marks |
|---|---|---|
| 1 | “You are employed as a data recovery expert in an IT support company. A customer reports that their USB flash drive holding important financial records has been accidentally formatted, and they require immediate data restoration. During your preliminary evaluation, you must collect relevant details from the customer to handle the situation efficiently.” Specify any one measure you would adopt to obtain essential details from the customer regarding the formatted USB flash drive. | 1 |
| 2 | 1 KB = ______ bytes (i) 512 (ii) 1024 (iii) 2048 (iv) 4096 | 1 |
| 3 | The part of the processor that carries out mathematical calculations (such as multiply, divide) and logical comparisons (such as greater than, equal to) is called: (i) Control Unit (ii) ALU (iii) Cache Memory (iv) Accumulator | 1 |
| 4 | Determine the category of software in this case: “A boutique fashion store is looking for a specialized application to track daily sales, manage stock levels of different clothing items, handle customer loyalty points, and prepare daily revenue reports exclusively for retail clothing businesses.” (i) Application Software (ii) System Software (iii) Generic Software (iv) Specific Purpose Software | 1 |
| 5 | When choosing a name for an identifier in Python, which of these should you not do? (i) Using meaningful descriptive words (ii) Starting the identifier with a digit (iii) Separating words using underscores (iv) Using all lowercase letters | 1 |
| 6 | Which option shows the correct Python statement to find the mean (average) of marks obtained in Physics, Chemistry, and Biology? (i) mean = (phy + chem + bio) / 3 (ii) mean = phy + chem + bio / 3 (iii) mean = phy + chem + bio * 3 (iv) mean = (phy + chem + bio) * 3 | 1 |
| 7 | Choose the option that correctly represents the syntax of a simple if statement in Python: (i) if score >= 40 { print(“Pass”) } (ii) if score >= 40; print(“Pass”) (iii) if score >= 40: print(“Pass”) (iv) If score >= 40 print(“Pass”) | 1 |
| 8 | Which of the following is true regarding NULL in MySQL? (i) NULL is treated as 0 in numeric expressions. (ii) NULL behaves exactly like an empty string in string operations. (iii) NULL signifies that the value is missing or not applicable. (iv) NULL can be used directly in mathematical calculations without error. | 1 |
| 9 | A student is attempting to add 95 to the “Score” column in the “Exam” table but gets a syntax error. Rewrite the incorrect INSERT statement correctly. INSERT INTO Exam (95) VALUES (Score); | 1 |
| 10 | State True or False: An attribute in a relation can hold values of only one specific data type (domain). | 1 |
| 11 | In MySQL, to modify the structure of an existing table (for example, to change the data type of a column), which type of command is used? (i) DML (ii) DDL (iii) DQL (iv) TCL | 1 |
| 12 | A student executes the following SQL command to create a table for storing student details but receives a syntax error: CREATE TABLE Students ; Point out the error in the statement. | 1 |
| 13 | In the table Product (ProductCode, ProductName, Price), which option best represents a suitable domain for the ProductName attribute? (i) Numeric digits only (ii) Letters (A–Z, a–z) and spaces (iii) Only uppercase letters (iv) Letters combined with symbols like %, &, * | 1 |
| 14 | A relation “Employee” is defined with fields: (EmpID, Name, Dept, Salary). Originally, it has 5 rows and 4 columns. Later, 3 more rows are added to it. Determine the degree and the cardinality of the relation after these additions. | 1 |
| 15 | A coaching institute needs a ready-to-use online attendance, test-conducting, and result-sharing application that requires no installation or server management, and is accessible via web browser with automatic updates provided by the vendor. Which cloud computing service model best fits this need? (i) Platform as a Service (ii) Infrastructure as a Service (iii) Software as a Service (iv) Network as a Service | 1 |
| 16 | Identify the area of Artificial Intelligence that deals with enabling machines to perceive, understand, and interact with the visual world through images and videos. (i) Robotics (ii) Computer Vision (iii) Natural Language Processing (iv) Big Data Analytics | 1 |
| 17 | True/False: Secondary memory is non-volatile. | 1 |
| 18 | Which one is an example of application software? a) Ubuntu b) Antivirus program c) Motherboard driver d) Bootloader | 1 |
| 19 | The storage component with the quickest read/write access time is: a) RAM b) Hard Disk Drive c) Optical Disk d) USB Flash Drive | 1 |
| 20 | Assertion (A): Dictionaries in Python are ordered collections and support indexing using integer positions (like lists). Reason (R): Since Python 3.7, dictionaries maintain insertion order, so elements can be accessed using positive and negative indices. Mark the correct choice: i) Both A and R are true and R is the correct explanation of A ii) Both A and R are true but R is not the correct explanation of A iii) A is true but R is false iv) A is false but R is true v) Both A and R are false | 1 |
| 21 | Assertion (A): A primary key in a relational table uniquely identifies each tuple (row). Reason (R): The primary key constraint ensures that no two tuples in a relation can have the same value for the primary key attribute(s) and that the primary key value cannot be NULL. Mark the correct choice: i) Both A and R are true and R is the correct explanation of A ii) Both A and R are true but R is not the correct explanation of A iii) A is true but R is false iv) A is false but R is true v) Both A and R are false | 1 |
Section B (7 × 2 = 14 Marks)
| Q. No. | Question | Marks | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22 | What will be printed by the following code segment?count = 0
k = 3
while k <= 12:
count = count + k
k = k + 3
print(count) | 2 | ||||||||||||||||||||||||
| 23 | Locate the syntax and logical errors in the following code fragment. Rewrite the corrected program and underline the corrections:sum = 0
count == 5
while count > 0
sum = sum + count
count = count - 1
print("Sum is" sum) | 2 | ||||||||||||||||||||||||
| 24 | Evaluate the following: (i) 5 ** 2 // 4 + 13 % 5 * 6 (ii) (45 - 3 * 5) / 5 == 6 and (9 + 6) * 2 <= 32 OR Consider the following code fragment and answer the following: p = 15
sum_val = 0
for x in range(p, 2, -3):
sum_val += x
print(x)
print(sum_val)a) How many iterations will the above loop execute? b) What will be the value of the variable sum_val after the code is executed? | 2 | ||||||||||||||||||||||||
| 25 | a. Neha wants to increase the size of the 'Description' column in the Product table to hold up to 100 characters. She wrote an incorrect SQL statement. Rewrite the following SQL statement after correcting the errors.ALTER Product TABLE CHANGE Description VARCHAR(100);b. Neha executed the following incorrect command: UPDATE Product SET Category = "Electronics" WHERE ProdID = 5, Price > 20000;She actually wants to change the category to "Electronics" for all products whose ProdID is less than 100 and Price is greater than 15000. Help her write the correct SQL query. OR Consider the following tables: Table1: (BookID, Title, AuthorID) Table2: (AuthorID, AuthorName, Country) Table3: (MemberID, MemberName, BookID) Table4: (CountryCode, CountryName, Continent) Group the tables which are related to each other. Justify your answer. | 2 | ||||||||||||||||||||||||
| 26 | Consider the table Product : (a) Write a query which will produce the following output. Make sure the changes should get reflected in the original table. (b) Suggest an alternate query to generate the same output as given in part (a), such that, the changes will not be reflected in the original table. OR Based on the Table LibraryBook given below. Identify the Primary Key, Candidate keys, and Alternate keys.
| 2 | ||||||||||||||||||||||||
| 27 | Ananya receives the error below when she tries to run queries on her recently created database named Hospital: ERROR 1046 (3D000): No database selected a) Help her by writing the correct SQL command(s) to select and use the Hospital database so that the error is resolved. b) Provide the SQL statement that Ananya must have used to create the Hospital database. | 2 | ||||||||||||||||||||||||
| 28 | (a) Rewrite the given while loop using a for loop:count = 5
while count <= 25:
print(count)
count += 5(b) Determine the number of times the above loop will execute. | 2 |
Section C (4 × 3 = 12 Marks)
| Q. No. | Question | Marks | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 29 | Predict the output of the given code segment:scores = [45, 78, 32, 65, 90]
count = len(scores)
print("Number of scores:", count)
index_val = scores.index(65)
print(scores[:index_val + 1])
scores.sort(reverse=True)
print("Descending order:", scores) | 3 | ||||||||||||||||
| 30 | Consider the table Employee with the following fields: Employee: (EmpID, Name, Salary)
a) The manager wants to increase the salary of every employee by ₹5000. Write the appropriate MySQL command. b) Display what the table would look like after executing the command from part (a). c) Provide the reason behind the output shown in part (b). OR Fill in the blanks: Each blank should be replaced by one single word to form a valid SQL Command. a) SELECT * FROM Employee WHERE Salary ________ 30000 ________ 40000; b) ________ databases; c) ________ table Employee; | 3 | ||||||||||||||||
| 31 | a) Consider the table Employee given below:
What will be the output of the query: SELECT Salary > 50000 FROM Employee;b) Mention two benefits of using SQL in database management. | 3 | ||||||||||||||||
| 32 | Match each description to the correct emerging technology field. Options: AI, ML, NLP, IoT, Cloud Computing, Blockchain. a) Chatbot that can understand and respond to customer queries written in everyday language on a website. b) Smart bulbs that turn on/off automatically when someone enters or leaves the room, connected via Wi-Fi. c) A system used by banks to record transactions in a secure, tamper-proof distributed ledger. | 3 |
Section D (2 × 4 = 8 Marks)
| Q. No. | Question | Marks | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33 | a) Match the items in Column A with the most appropriate category in Column B:
b) Identify each of the following as an input device or an output device: Webcam, Headphones, Touchscreen, Mouse, LED Display, OCR Scanner | 4 | ||||||||||
| 34 | a) Determine the output of the given dictionary manipulation code:marks = {"Ankit": 45, "Priya": 72, "Rahul": 88, "Sneha": 60}
old = marks["Ankit"]
marks["Ankit"] = marks["Sneha"]
print(marks)
marks["Sneha"] = old
marks["Rahul"] = marks["Priya"]
print(marks)b) A library issues temporary membership cards using token numbers stored in a list. When a member leaves early, their token is removed from a specific position. What will be printed by the following code? members = [201, 202, 203, 204, 205] members.append(206) print(members) del members[3] print(members) | 4 |
Section E (3 × 5 = 15 Marks)
| Q. No. | Question | Marks | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | Consider the table Bike given below and write appropriate SQL queries for the following:
a) Display the Model Names of all the black-coloured bikes. b) Add a column Mileage in the table Bike. c) Display BikeID of Apache bike from the table Bike. d) Change the ModelName in the table "Bike" to "Classic 350" which has EngineCC of 350. e) Display Brand of the bike whose EngineCC is more than 200. | 5 | ||||||||||||||||||||||||||||||
| 36 | Consider the table Library given below:
Write the output of the following SQL commands: a) SELECT BookTitle FROM Library WHERE Copies > 10; b) SELECT Subject FROM Library WHERE NOT Subject = 'Computer'; c) SELECT BookID FROM Library WHERE Publisher = 'Pearson' AND Publisher = 'Wiley'; d) SELECT Publisher FROM Library WHERE Copies BETWEEN 10 AND 20; e) SELECT Copies + 5 FROM Library WHERE Subject = 'Science' AND Copies > 5; OR Consider the table Employee (EmpID, EmpName, JoinDate, Salary) (a) Write MySQL commands for the following: (i) Create a table Employee with suitable datatypes. (ii) Remove the column JoinDate. (iii) Increase size of the column EmpName to 70. (b) The HR wants to replace NULL values with 0 in the Salary column. Write the suitable SQL command for the same. | 5 | ||||||||||||||||||||||||||||||
| 37 | A music playlist manager organizes songs by Genre. Each Genre maps to one representative song title. Example:playlist = {
"Rock": "Bohemian Rhapsody",
"Pop": "Shape of You",
"Jazz": "Take Five"
}Write Python statements to perform the following: a) Display the song title for the "Pop" genre. b) Delete the "Jazz" genre entry from the dictionary. c) Print the number of genres currently in the playlist. d) Print all song titles present in the playlist. e) Add a new genre ‘Classical’ with song title - "Moonlight Sonata". OR Consider the following list: FRUITS = ["APPLE", "BANANA", "CHERRY", "DATE", "ELDERBERRY", "FIG"] Write Python statements to perform the following operations: a) Access the word “DATE” from the given list. b) Replace the element at position 1 (0-based index) with the word “MANGO”. c) Reverse the order of the list. d) Insert the word “GRAPE” after “CHERRY” in the list. e) Display the slice of the list from index 2 to 5 (inclusive). | 5 |