Page 17 - IPP-12-2025

8. State whether the following statement is True or False:
HAVING clause in SQL is applied to filter rows before grouping data. [1]
Ans. False
9. Which command is used to read a CSV file named test.csv into a Pandas dataframe? [1]
(Note: pd is an alias for pandas)
(a) df = pd.read_csv('test.csv')
(b) df = pd.load_csv('test.csv')
(c) df = pd.readcsv('test.csv')
(d) df = pd.get_csv('test.csv')
Ans. (a) df = pd.read_csv('test.csv')
10. What is protected under copyright law? [1]
(a) General ideas and concepts
(b) Financial and business transactions
(c) Tangible items like furniture
(d) Creative works such as books, music and software
Ans. (d) Creative works such as books, music and software
11. Fill in the blank. [1]
To calculate the average of a column price while excluding duplicate values, you would use
function.
(a) AVG(price) (b) AVG(UNIQUE price)
(c) AVG(DISTINCT price) (d) SUM(price)/COUNT(price)
Ans. (c) AVG(DISTINCT price)
12. Which of the following is a disadvantage of star topology? [1]
(a) High cabling cost (b) Data collision issues
(c) Difficult to scale (d) Dependence on a central device
Ans. (d) Dependence on a central device
13. How do you use iloc[] to select a specific value from the third row and second column? [1]
(a) df.iloc[2, 3] (b) df.iloc[1, 2]
(c) df.iloc[3, 2] (d) df.iloc[2,1]
Ans. (d) df.iloc[2,1]
14. What is the main benefit of Free and Open-Source Software (FOSS)? [1]
(a) It is free to use and modify.
(b) It cannot be shared with others.
(c) It requires an annual subscription.
(d) It is only available to developers.
Ans. (a) It is free to use and modify.
15. What will the empty attribute of a Pandas series return? [1]
(a) True if the series contains all NaN values
(b) True if the series has no elements
(c) False if the series contains non-zero elements
(d) False if the series index is not unique
Ans. (b) True if the series has no elements
16. Match the following SQL clauses/functions with their descriptions: [1]

SQL Clauses/Functions Description
P. COUNT() 1. Filters groups based on a condition
Q. WHERE 2. Returns the number of rows
R. HAVING 3. Sorts the resultset
S. ORDER BY 4. Filters rows based on a condition

(a) P-1, Q-2, R-3, S-4 (b) P-2, Q-1, R-4, S-3
(c) P-2, Q-4, R-1, S-3 (d) P-4, Q-2, R-1, S-3
Ans. (c) P-2, Q-4, R-1, S-3
Model Test Paper M.14
33