Page 29 - IPP-12-2025

10. Which of the following types of hackers are individuals who use their skills and knowledge for the common
good? [1]
(a) Grey Hat Hackers (b) White Hat Hackers
(c) Black Hat Hackers (d) Red Hat Crackers
11. Fill in the blank. [1]
To calculate the total price of stationery items in column ‘Price’, you would use function.
(a) SUM(Price) (b) COUNT(Price)
(c) TOTAL(Price) (d) ADD(Price)
12. Which of the following is an advantage of bus topology? [1]
(a) Easy to add new devices (b) High security
(c) Fault isolation is easy (d) Requires central hub
13. How do you retrieve second row and third column of df1 using iloc? [1]
(a) df1.iloc[2,3] (b) df1.iloc[3,2]
(c) df1.iloc[1,2] (d) df1.iloc[2,1]
14. Which of the following is an online fraud? [1]

(a) Installing firewall (b) Creating phishing websites
(c) Blocking pop-ups (d) Encrypting emails
15. Which of the following attributes is used to display dimensions of a dataframe? [1]
(a) df.shape (b) df.size
(c) df.count (d) df.index
16. Match the following SQL functions with their descriptions: [1]
SQL Function Description
A. COUNT(*) 1. Returns the current date and time
B. INSTR() 2. Returns the argument raised to the specified power
C. POW() 3. Returns the position of the first occurrence of the substring
D. NOW() 4. Returns the total number of rows including NULL values
(a) A-4, B-3, C-2, D-1 (b) A-3, B-2, C-4, D-1
(c) A-1, B-3, C-2, D-4 (d) A-2, B-4, C-1, D-3
17. Which method is used to add a new column to a Pandas DataFrame? [1]
(a) insert_column() (b) add_column()
(c) df[new_column] = values (d) append_column()
18. What is the purpose of plt.legend() in a plot? [1]
(a) To add gridlines (b) To add labels to axes
(c) To display the plot (d) To show the label of the plotted data
19. Infrared communication (like used in TV remotes) is an example of which of the following network
types? [1]
(a) WAN (b) LAN
(c) PAN (d) MAN
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 R is the correct explanation for A.
(b) Both Assertion (A) and Reason (R) are true but R is not the correct explanation for A.
(c) Assertion (A) is true but Reason (R) is false.
(d) Assertion (A) is false but Reason (R) is true.

20. Assertion (A): SQL WHERE clause filters records. [1]
Reasoning (R): SQL ORDER BY filters records.

P.2 Informatics Practices with Python–XII