Page 17 - IPP-12-2025
P. 17

8. State whether the following statement is True or False:
                    HAVING clause in SQL is applied to filter rows before grouping data.                      [1]
                Ans. False
                  9. Which command is used to read a CSV file named test.csv into a Pandas dataframe?         [1]
                    (Note: pd is an alias for pandas)
                     (a) df = pd.read_csv('test.csv')
                     (b) df = pd.load_csv('test.csv')
                     (c) df = pd.readcsv('test.csv')
                     (d) df = pd.get_csv('test.csv')
                Ans.  (a)  df = pd.read_csv('test.csv')
                 10. What is protected under copyright law?                                                   [1]
                     (a) General ideas and concepts
                     (b) Financial and business transactions
                     (c) Tangible items like furniture
                     (d) Creative works such as books, music and software
                Ans.  (d)  Creative works such as books, music and software
                 11. Fill in the blank.                                                                       [1]
                    To  calculate  the  average  of  a  column  price  while  excluding  duplicate  values,  you  would  use
                    function.
                     (a) AVG(price)                     (b) AVG(UNIQUE price)
                     (c) AVG(DISTINCT price)            (d) SUM(price)/COUNT(price)
                Ans.  (c)  AVG(DISTINCT price)
                 12. Which of the following is a disadvantage of star topology?                               [1]
                     (a) High cabling cost              (b) Data collision issues
                     (c) Difficult to scale             (d) Dependence on a central device
                Ans.  (d)  Dependence on a central device
                 13. How do you use iloc[] to select a specific value from the third row and second column?   [1]
                     (a) df.iloc[2, 3]                  (b) df.iloc[1, 2]
                     (c) df.iloc[3, 2]                  (d) df.iloc[2,1]
                Ans.  (d)  df.iloc[2,1]
                 14. What is the main benefit of Free and Open-Source Software (FOSS)?                        [1]
                     (a) It is free to use and modify.
                     (b) It cannot be shared with others.
                     (c) It requires an annual subscription.
                     (d) It is only available to developers.
                Ans.  (a)  It is free to use and modify.
                 15. What will the empty attribute of a Pandas series return?                                 [1]
                     (a) True if the series contains all NaN values
                     (b) True if the series has no elements
                     (c) False if the series contains non-zero elements
                     (d) False if the series index is not unique
                Ans.  (b) True if the series has no elements
                 16. Match the following SQL clauses/functions with their descriptions:                       [1]

                          SQL Clauses/Functions                            Description
                      P.  COUNT()               1.  Filters groups based on a condition
                     Q.  WHERE                  2.  Returns the number of rows
                      R.  HAVING                3.  Sorts the resultset
                      S.  ORDER BY              4.  Filters rows based on a condition

                     (a) P-1, Q-2, R-3, S-4             (b) P-2, Q-1, R-4, S-3
                     (c) P-2, Q-4, R-1, S-3             (d) P-4, Q-2, R-1, S-3
                Ans.  (c)  P-2, Q-4, R-1, S-3
                                                                                    Model Test Paper         M.14
                                                                                                             33
   12   13   14   15   16   17   18   19   20   21   22