Page 16 - 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:
If the index of a Pandas series is explicitly defined, it replaces the default numeric indexing. [1]
Ans. True
2. What is the purpose of ORDER BY clause in SQL? [1]
(a) To group rows with the same values
(b) To filter rows based on a condition
(c) To create a new table
(d) To sort the data in ascending or descending order
Ans. (d) To sort the data in ascending or descending order
3. Which device forwards data packets to their destination based on IP addresses? [1]
(a) Gateway (b) Router (c) Hub (d) Switch
Ans. (b) Router
4. Identify the SQL command used to remove rows from a table based on a condition? [1]
(a) REMOVE (b) DROP (c) DELETE (d) TRUNCATE
Ans. (c) DELETE
5. Which of the following is an example of e-waste? [1]
(a) Plastic bottles (b) Discarded cardboard boxes
(c) Old newspaper (d) Used smartphones
Ans. (d) Used smartphones
6. How do you rename a column ‘OldName’ to ‘NewName’ in a dataframe df? [1]
(a) df.rename_column('OldName', 'NewName')
(b) df.rename(columns={'OldName': 'NewName'})
(c) df.rename_col('OldName', 'NewName')
(d) df.rename(['OldName', 'NewName'])
Ans. (b) df.rename(columns={'OldName': 'NewName'})
7. Which parameter is used in plt.plot() function to label the x-axis of a plot? [1]
(a) x_label (b) labelx (c) plt.xaxis (d) xlabel
Ans. (d) xlabel