Page 38 - IPP-12-2025
P. 38

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 Reason (R) is the correct explanation for Assertion (A).
                     (b) Both  Assertion  (A)  and  Reason  (R)  are  true  but  Reason  (R)  is  not  the  correct  explanation  for
                         Assertion (A).
                     (c) Assertion (A) is true but Reason (R) is false.
                     (d) Assertion (A) is false but Reason (R) is true.
                 20. Assertion (A): Data in a Pandas dataframe can be modified by assigning new values to specific rows or
                    columns.                                                                                  [1]
                    Reasoning (R): Pandas dataframes are immutable, so once created, modifications are not allowed.
                 21. Assertion (A): In SQL, INSERT INTO is a Data Definition Language (DDL) Command.          [1]
                    Reasoning (R): DDL commands are used to create, modify and remove database structures such as tables.

                                                   Section B (7 × 2 = 14 Marks)
                 22. Can a Pandas series contain multiple data types? Give a suitable example to support your answer.  [2]
                                                               Or
                    How can we check if dataframe ‘df’ has any missing value?
                 23. What do you mean by cyber ethics and why are they important for us?                      [2]
                 24. Consider the  string  Artificial  Intelligence  and  Machine  Learning  and  write  suitable  SQL  queries  for the
                    following:                                                                                [2]
                     (a) Extract and display the last 7 characters from the string.
                     (b) Convert the string into uppercase and display the result.
                 25. Differentiate between Website and Web Page.                                              [2]
                                                               Or
                    What is URL? Explain with the help of an example.
                 26. Differentiate between char and varchar data type in SQL by giving suitable examples.     [2]
                 27. List at least three emotional and physical symptoms of internet addiction.               [2]
                 28. Kabir  is  creating  a  dataframe  from  a  list  of  tuples  but  his  code  contains  mistakes.  Identify  the  errors,
                     rewrite the correct code and underline the corrections made.                             [2]
                    import Pandas as pd
                    data = [('John', 25), ('Sana', 22), (Zara, 28)]
                    columns = ('Name', 'Age')
                    df = pd.Dataframe(data, column=columns)
                    print(df)
                                                               Or
                    Complete the given Python code to get the required output (ignore the dtype attribute) as:
                    Output:
                    Physics       80
                    Math          90
                    Chemistry  85
                    Code:
                    import             as pd
                    data = [80, 90, 85]
                    index = ['Physics', 'Math',                   ]
                    s = pd.Series(data, index=                 )
                    print(           )

                                                    Section C (4 × 3 = 12 Marks)
                 29. A local office is upgrading its printers and has decided to dump the old ones at a nearby ground.  [3]
                     (a) What toxic substances could leach into the soil or water due to improper disposal of printers?
                     (b) Suggest a better way to dispose of or repurpose old printers.
                     (c) Highlight the significance of proper e-waste management for future generations.



                                                                                       Practice Paper        P.11
   33   34   35   36   37   38   39   40   41   42   43