Page 28 - 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 read_csv() method automatically takes the first row of the csv file and assigns it as the dataframe
header.
2. Which of the following SQL clauses is used to retrieve pattern-based records? [1]
(a) UNIQUE (b) DISTINCT
(c) LIKE (d) BETWEEN
3. Which of the following network devices is used to regenerate the signals? [1]
(a) Switch (b) Repeater
(c) Router (d) Hub
4. Which of the following SQL commands is used to view the structure of the table? [1]
(a) VIEW (b) ALTER TABLE
(c) UPDATE (d) DESCRIBE
5. Which of the following is an environmentally safe method for disposing of old keyboards? [1]
(a) Burning (b) Throwing in trash
(c) Donating or recycling (d) Burying
nd
6. How do you access 2 row of a DataFrame using iloc? [1]
(a) df.iloc[1] (b) df.iloc[2]
(c) df.loc[1] (d) df.loc[2]

7. Which of the following methods is used to plot a horizontal bar chart? [1]
(a) bar() (b) plot()
(c) hist() (d) barh()

8. State whether the following statement is True or False: [1]
SELECT command of SQL can retrieve specific columns from a table.
r
9. What does df.head(3) eturn? [1]
(a) First 3 columns (b) Last 3 rows
(c) First 3 rows (d) Random 3 rows