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