Page 4 - IPP-12-2025

Time Allowed: 3 hrs Maximum Marks: 70

General Instructions:
• 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]
The DataFrame() function in Pandas can take a dictionary as input to create a DataFrame.
Ans. True
2. Which SQL keyword is used to eliminate duplicate rows from the output of a query? [1]
(a) ORDER BY (b) GROUP BY
(c) DISTINCT (d) LIKE
Ans. (c) DISTINCT
3. Which network device is called an intelligent hub? [1]
(a) Modem (b) Switch
(c) Router (d) Repeater
Ans. (b) Switch
4. Which SQL command is used to remove a table from the database permanently? [1]
(a) DROP (b) DELETE
(c) UPDATE (d) MODIFY
Ans. (a) DROP
5. Which of the following is a responsible way to dispose of old electronic devices? [1]
(a) Selling to scrap dealers (b) Dumping in trash
(c) Burning (d) Recycling at e-waste centres
Ans. (d) Recycling at e-waste centres

6. How do you add a new row to a DataFrame df? [1]
(a) df.insert() (b) df.new_row()

(c) df.loc[index] = [values] (d) df.append_row()
Ans. (c) df.loc[index] = [values]