(Download) CBSE Class-12 Sample Paper 2024-25 : Informatics Practices

Sample Question Paper (Term-1) 2024-25

Subject Name : Informatics Practices

Subject Code: 065

Time Allowed: 3 Hour

Minutes Maximum Marks:70

SECTION-A

1 State whether the following statement is True or False:
Slicing can be used to extract a specific portion from a Pandas Series.

2 The purpose of WHERE clause in a SQL statement is to:
(A) Create a table
(B) Filter rows based on a specific condition
(C)Specify the columns to be displayed
(D)Sort the result based on a column

3 Identify the networking device responsible for routing data packets based on their destination addresses.
(A) Modem
(B) Hub
(C)Repeater
(D)Router

4 Identify the SQL command used to delete a relation (table) from a relational database.
(A) DROP TABLE
(B) REMOVE TABLE
(C)DELETE TABLE
(D)ERASE TABLE

5 e-waste refers to:
(A) Software that has become obsolete
(B) Data that has been deleted from a storage device
(C)Viruses that infect computers
(D)Electronic devices that are no longer in use

6 Which of the following Python statements can be used to select a column column_name from a DataFrame df ?
(A) df.getcolumn('column_name')
(B) df['column_name']
(C)df.select('column_name')
(D)df(column_name)

7 By default, the plot() function of Matplotlib draws a ______ plot.
(A) histogram
(B) column
(C)bar
(D)line

8 State whether the following statement is True or False:
In SQL, the HAVING clause is used to apply filter on groups formed by the GROUP BY clause.

9 Which of the following Python statements is used to import data from a CSV file into a Pandas DataFrame (Note: pd is an alias for pandas)?
(A) pd.open_csv('filename.csv')
(B) pd.read_csv('filename.csv')
(C)pd.load_csv('filename.csv')
(D)pd.import_csv('filename.csv')

Click Here To Download Full Sample Paper

Click Here To Download Full Marking Scheme

NEW!  CBSE Old Papers PDF: Class-X, Class-XII 

<<Go Back To Main Page