Page 16 - IPP-12-2025
P. 16

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
   11   12   13   14   15   16   17   18   19   20   21