Page 20 - IPP-12-2025
P. 20

Section C (4 × 3 = 12 Marks)
             29. A local community is replacing its outdated street lamps with energy-efficient LED lights and disposing of
                 the old lamps improperly.                                                                 [3]
                 (a) What environmental hazards could result from the improper disposal of old street lamps?
                 (b) Suggest one responsible way for proper disposal of old street lamps.
                 (c) Why is it crucial to properly dispose of the lighting equipment to safeguard wildlife and human health?
            Ans.  (a)  Improper disposal of old street lamps can result in mercury contamination, heavy metal pollution and
                     cause harm to soil, water and air quality.
                 (b) They can donate or sell old street lamps to organizations that specialize in upcycling or repurposing
                     electronic waste.
                 (c) Proper  disposal  of  lighting  equipment  is  crucial  to  safeguard  wildlife  and  human  health  because
                     it  prevents  the  release  of  hazardous  materials  such  as  mercury  and  heavy  metals  which  can
                     contaminate the environment.
             30. Write a Python program to create the following dataframe using a dictionary of lists:     [3]
                                                   Product       Price     Quantity
                                            0   Chair         1500           100
                                            1   Table         3000           50
                                            2   Lamp          500            200
                                            3   Sofa          5000           20
                                                           Or
                 Write a Python program to create a Pandas series, as shown below, using a dictionary. Note that the left
                 column indicates the indices and the right column displays the data.
                                                 Dog               13 years
                                                 Cat               15 years
                                                 Elephant          60 years
            Ans. import pandas as pd
                 f_data = {
                      "Product": ["Chair", "Table", "Lamp", "Sofa"],
                      "Price": [1500, 3000, 500, 5000],
                      "Quantity": [100, 50, 200, 20]
                 }
                 df = pd.DataFrame(f_data)
                 print(df)
                                                           Or
                 import pandas as pd
                 data = {"Dog": "13 years", "Cat": "15 years", "Elephant": "60 years"}
                 series_animalifespan = pd.Series(data)
                 print(series_animalifespan)
             31. (a)  Write an SQL statement to create a table named VEHICLES with the following specifications:
                                                                                                      [2+1=3]
                                        Column Name       Data Type           Key
                                      VehicleID        Numeric             Primary Key
                                      Make             Varchar(50)
                                      Model            Varchar(35)
                                      Year             Numeric
                                      Price            Numeric
                 (b) Write an SQL query to insert the following data in VEHICLES table:
                     101, 'Toyota', 'Honda', 2022, 4800000



            M.17         Informatics Practices with Python–XII
            36
   15   16   17   18   19   20   21   22   23   24   25