Organisation : Central Board of Secondary Education (CBSE)
Class Name : 12th/HSC (Class XII)
Subject : Informatics Practices
Download : Sample Question Paper 2024-25
Website : https://cbseacademic.nic.in//SQP_CLASSXII_2024-25.html
CBSE Class XII Informatics Practices Sample Question Paper
Central Board of Secondary Education (CBSE) Class XII Informatics Practices Sample Question Paper 2024-25.
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. 1
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’)
10. What is plagiarism?
(A) Using copyrighted material without giving proper acknowledgement to the source
(B) Downloading illegal software.
(C) Spreading misinformation online.
(D) Hacking into computer systems.
11. Fill in the Blank
The COUNT(*) function provides the total number of __________ within a relation (table) in a relational database.
(A) Columns
(B) Unique values
(C) Not-null values
(D) Rows
12. In which of the network topologies do all devices connect to a central point, such as a switch or hub?
(A) Star
(B) Bus
(C) Tree
(D) Mesh
13. In a Pandas DataFrame, if the tail() function is used without specifying the optional argument indicating the number of rows to display, what is the default number of rows displayed, considering the DataFrame has 10 entries?
(A) 0
(B) 1
(C) 4
(D) 5
14. Identify the type of cybercrime that involves sending fraudulent emails to deceive individuals into revealing sensitive information.
(A) Hacking
(B) Phishing
(C) Cyberbullying
(D) Cyberstalking
Download CBSE Class XII Informatics Practices Sample Question Paper
Download Sample Question Paper Here : https://www.pdfquestion.in/uploads/pdf2025/43632-ip.pdf