Page 5 - IPP-12-2025

7. Which parameter is used in the plt.plot() function to label the y-axis of a plot? [1]
(a) Ylabel (b) y_label
(c) label_y (d) ylabel
Ans. (d) ylabel

8. State whether the following statement is True or False: [1]
The GROUP BY clause in SQL is used to group rows that have the same values.
Ans. True
9. What will df.to_csv('datainfo.csv') do? [1]
(a) Read a CSV file
(b) Export the DataFrame to a text file
(c) Write the DataFrame to a CSV file named datainfo.csv
(d) Display the DataFrame in HTML format
Ans. (c) Write the DataFrame to a CSV file named datainfo.csv

10. What is protected under trademark law? [1]
(a) Songs (b) Brand names and logos
(c) Ideas (d) Furniture
Ans. (b) Brand names and logos
11. Fill in the blank. [1]
To count the number of unique values in a column ‘Fee’, you would use the function.
(a) COUNT(Fee) (b) COUNT(*)
(c) COUNT(DISTINCT Fee) (d) SUM(price)
Ans. (c) COUNT(DISTINCT Fee)
12. Which of the following is a limitation of bus topology? [1]
(a) Central failure risk (b) High cost
(c) Difficult setup (d) Difficult to detect faults
Ans. (d) Difficult to detect faults
13. How do you access the first column of a DataFrame named df1 using iloc? [1]
(a) df1.iloc[:, 0] (b) df1.iloc[1,:]
(c) df1.iloc[1:2] (d) df1.loc[0]
Ans. (a) df1.iloc[:, 0]
14. Which of the following is an example of cyberbullying? [1]
(a) Reporting spam messages
(b) Sharing someone’s personal photos without consent
(c) Installing antivirus software
(d) Posting a job advertisement
Ans. (b) Sharing someone’s personal photos without consent
15. What will the shape attribute of a Pandas DataFrame return? [1]
(a) Index (b) dtypes
(c) Size (d) Tuple of (rows, columns)
Ans. (d) Tuple of (rows, columns)
16. Match the following SQL clauses/functions with their descriptions: [1]
SQL Clause/Function Description
A. SUM() 1. Matches values based on pattern
B. ORDER BY 2. Retrieves data from one or more tables
C. LIKE 3. Calculates the total of a numeric column
D. SELECT 4. Sorts the records in ascending/descending
(a) A-1, B-2, C-3, D-4 (b) A-3, B-4, C-2, D-1
(c) A-3, B-4, C-1, D-2 (d) A-4, B-3, C-2, D-1
Ans. (c) A-3, B-4, C-1, D-2

M.2 Informatics Practices with Python–XII