Page 30 - IPP-12-2025

21. Assertion (A): DataFrame is a two-dimensional data structure. [1]
Reasoning (R): Series is a one-dimensional data structure.
SECTION B (7 x 2 = 14 Marks)
22. List any two features of NumPy. [2]
Or
Differentiate between series and list in Python.
23. List any four online etiquette tips. [2]
24. Consider the string ‘Data Analytics’. Write suitable SQL queries for the following: [2]
(a) Convert the entire string to uppercase.
(b) Extract and display first 4 characters.
25. What is VoIP? [2]
Or
Define the terms—
(a) Denial-of-Service
(b) Identity Theft
26. Differentiate between CHAR and VARCHAR data types in SQL. [2]
27. How can parents prevent their children from being victims of cyberbullying? [2]
28. Mayra is trying to create a dictionary and convert it into a dataframe using Pandas but her code contains
mistakes. Identify the errors, rewrite the correct code and underline the corrections made. [2]
import panda as pd
info = {Name: ['John', 'Asha'], 'Age': [25, 22]} df = pd.Dataframe(info)
print(Dataframe)

Or
Complete the given Python code to get the required output as:
import as
stat_item = ['Pen', 'Pencil', 'Eraser', 'Sharpener']
qty = [50, 30, 20, 10]
s = ps.Series( , index= )
print(s)
SECTION C (4 x 3 = 12 Marks)
29. A company disposed of electronic devices improperly. [3]
(a) What harm can it cause?
(b) Suggest a safer alternative.
(c) Name two harmful elements found in e-waste.
30. Write a Python program to create the following dataframe using a dictionary of lists: [3]

Devices Price Units
USB 300 120
MOUSE 500 80
HDMI 700 60
Or

Practice Paper P.3