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