Page 28 - IPP-12-2025
P. 28

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
   23   24   25   26   27   28   29   30   31   32   33