CBSE Class 12 Informatics Practices 2025 Sample Paper Solved Set 5

Section-A 

1 Slicing takes place positions wise and not the index wise in a series object 

Answer : True

2 What is the meaning of “HAVING” clause in SELECT query?
a) To filter out the summary groups
b) To filter out the column groups
c) To filter out the row and column values
d) None of the mention

Answer : a

3 A device that works like a bridge but can handle different protocols
a) Hub
b) Switch
b) Router
d) Repeater

Answer : b

4 Identify the SQL command used to add new attribute a relation(table) from the relational database
a) UPDATE TABLE
b) ALTER TABLE
c) CHANGE TABLE
d) MODIFY TABLE

Answer : b

5 What is the example of e-waste?
a) A ripened banana
b) an old computer
c) old clothes
d) empty soda cans

Answer : b

6 Which of the following Python statements can used to delete column column_name from a DataFrame df
a) del df[column_name]
b) del def[‘column_name’]
c) df.drop(column_name)
d) df.drop(column_name’)

Answer : b

7 Which of the following is not a valid plotting function of pyplot?
a) plot( )
b) bar( )
c) line( )
d) pie( )

Answer : c

8 The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.

Answer : True

9 The correct statement to read from a CSV file in a dataframe is :-
a) <DF>.read_csv(<file>)
b) <File>.read_csv( )(<DF>)
b) <DF>=pandas.read(<File>)
d) <DF> = pandas.read_csv(<Files>)

Answer : a

Please refer to attached file for CBSE Class 12 Informatics Practices 2025 Sample Paper Solved Set 5