Page 29 - IPP-12-2025
P. 29

10.  Which of the following types of hackers are individuals who use their skills and knowledge for the common
                 good?                                                                                     [1]
                 (a)  Grey Hat Hackers               (b)  White Hat Hackers
                  (c)  Black Hat Hackers             (d)  Red Hat Crackers
             11.  Fill in the blank.                                                                       [1]
                 To calculate the total price of stationery items in column ‘Price’, you would use     function.
                 (a)  SUM(Price)                     (b)  COUNT(Price)
                  (c)  TOTAL(Price)                  (d)  ADD(Price)
             12.  Which of the following is an advantage of bus topology?                                 [1]
                 (a)  Easy to add new devices        (b)  High security
                  (c)  Fault isolation is easy       (d)  Requires central hub
             13.  How do you retrieve second row and third column of df1 using iloc?                      [1]
                 (a)  df1.iloc[2,3]                  (b)  df1.iloc[3,2]
                  (c)  df1.iloc[1,2]                 (d)  df1.iloc[2,1]
             14.  Which of the following is an online fraud?                                              [1]

                 (a)  Installing firewall            (b)  Creating phishing websites
                  (c)  Blocking pop-ups              (d)  Encrypting emails
             15.  Which of the following attributes is used to display dimensions of a dataframe?         [1]
                 (a)  df.shape                       (b)  df.size
                  (c)  df.count                      (d)  df.index
             16.  Match the following SQL functions with their descriptions:                              [1]
                     SQL Function                        Description
                  A.  COUNT(*)                        1.  Returns the current date and time
                  B.  INSTR()                         2.  Returns the argument raised to the specified power
                  C.  POW()                           3.  Returns the position of the first occurrence of the substring
                  D.  NOW()                           4.  Returns the total number of rows including NULL values
                 (a)  A-4, B-3, C-2, D-1             (b)  A-3, B-2, C-4, D-1
                  (c)  A-1, B-3, C-2, D-4            (d)  A-2, B-4, C-1, D-3
             17.  Which method is used to add a new column to a Pandas DataFrame?                         [1]
                 (a)  insert_column()                (b)  add_column()
                  (c)  df[new_column] = values  (d)      append_column()
             18.  What is the purpose of plt.legend() in a plot?                                          [1]
                 (a)  To add gridlines               (b)  To add labels to axes
                  (c)  To display the plot           (d)  To show the label of the plotted data
             19.  Infrared  communication  (like  used  in  TV  remotes)  is  an  example  of  which  of  the  following  network
                 types?                                                                                   [1]
                 (a)  WAN                            (b)  LAN
                  (c)  PAN                           (d)  MAN
            Questions 20 and 21 are Assertion and Reasoning Based Questions. Mark the correct choice as:
              (a)  Both Assertion (A) and Reason (R) are true and R is the correct explanation for A.
              (b)  Both Assertion (A) and Reason (R) are true but R is not the correct explanation for A.
              (c)  Assertion (A) is true but Reason (R) is false.
              (d)  Assertion (A) is false but Reason (R) is true.

             20.  Assertion (A): SQL WHERE clause filters records.                                        [1]
                 Reasoning (R): SQL ORDER BY filters records.


              P.2        Informatics Practices with Python–XII
   24   25   26   27   28   29   30   31   32   33   34