Page 36 - IPP-12-2025

Time Allowed: 3 hrs Maximum Marks: 70

General Instructions:
• Please check this question paper contains 37 questions.
• All questions are compulsory. However, internal choices have been provided in some questions. Attempt
only one of the choices in such questions.
• The paper is divided into 5 Sections—A, B, C, D and 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 case study type questions (33 to 34). Each question carries 4 Marks.
• Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
• All programming questions are to be answered using Python Language only.
• In case of MCQ, text of the correct answer should also be written.

Section A (21 × 1 = 21 Marks)
1. State whether the following statement is True or False: [1]
If a series has no explicitly defined index, it automatically assigns a string index.
2. What does HAVING clause do in SQL? [1]
(a) Filters all the records before grouping them
(b) Filters all the records after grouping them
(c) Sorts records in descending order
(d) Specifies conditions for column aliases
3. Which device is used to connect two different types of networks and translate protocols? [1]
(a) Gateway (b) Hub
(c) Router (d) Repeater
4. Identify the SQL command that is used to modify an existing table structure. [1]
(a) UPDATE (b) ALTER TABLE
(c) MODIFY TABLE (d) CHANGE TABLE
5. Which one is the best practice for managing e-waste? [1]
(a) Dumping it in landfills (b) Recycling and proper disposal of components
(c) Burning it to reduce volume (d) Ignoring e-waste altogether
6. Which of the following commands is used to drop column ‘col_name’ from dataframe df? [1]
(a) df.drop(columns=['col_name'])
(b) df.remove('col_name')
(c) df.delcolumn('col_name')
(d) df.dropcol('col_name')
7. Which parameter is used in plt.hist() function to specify the number of bins in a histogram? [1]
(a) intervals (b) bins
(c) divisions (d) steps
8. State whether the following statement is True or False: [1]
In SQL, ALTER TABLE statement can be used to delete rows from a table.