Question 1

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

Accepted Answer

TrueReason — Slicing can be used to extract a specific portion from a Pandas Series by specifying the start, stop, and step values. The syntax is Series[start:stop:step].For example,import pandas as pd
data = pd.Series([5, 10, 15, 20, 25, 30, 35])
sliced_data = data[1:5:1]
print(sliced_data)Output1    10
2    15
3    20
4    25
dtype: int64

Question 2

Question 2The purpose of WHERE clause in a SQL statement is to:Create a tableFilter rows based on a specific conditionSpecify the columns to be displayedSort the result based on a column

Accepted Answer

Filter rows based on a specific conditionReason — The purpose of the WHERE clause in a SQL statement is to select only those rows that meet a specific condition.

Question 3

Question 3Identify the networking device responsible for routing data packets based on their destination addresses.ModemHubRepeaterRouter

Accepted Answer

RouterReason — A Router is a networking device responsible for directing data packets to their correct destination by analyzing their destination addresses.

Question 4

Question 4Identify the SQL command used to delete a relation (table) from a relational database.DROP TABLEREMOVE TABLEDELETE TABLEERASE TABLE

Accepted Answer

DROP TABLEReason — The DROP TABLE command in SQL is used to delete an entire relation (table) from a relational database, removing its structure and all data permanently.

Question 5

Question 5e-waste refers to:Software that has become obsoleteData that has been deleted from a storage deviceViruses that infect computersElectronic devices that are no longer in use

Accepted Answer

Electronic devices that are no longer in useReason — E-waste, or electronic waste, refers to discarded electronic or electrical devices and components. This includes items like computers, mobile phones, televisions, refrigerators, and other electronic appliances that are no longer in use or have reached the end of their life cycle.

Question 6

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

Accepted Answer

df['column_name']Reason — The statement df['column_name'] is used to select a column named column_name from a DataFrame df in Python.

Question 7

Question 7By default, the plot() function of Matplotlib draws a ............... plot.histogramcolumnbarline

Accepted Answer

lineReason — By default, the plot() function of Matplotlib draws a line plot, which connects data points with lines.

Question 8

Question 8State 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.

Accepted Answer

TrueReason — The HAVING clause applies conditions to groups after data is grouped using the GROUP BY clause in SQL queries.

Question 9

Question 9Which 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)?pd.open_csv('filename.csv')pd.read_csv('filename.csv')pd.load_csv('filename.csv')pd.import_csv('filename.csv')

Accepted Answer

pd.read_csv('filename.csv')Reason — The statement pd.read_csv('filename.csv') is used to import data from a CSV file into a Pandas DataFrame. The read_csv function reads the contents of the specified CSV file and converts it into a structured DataFrame format.

Question 10

Question 10What is plagiarism ?Using copyrighted material without giving proper acknowledgement to the sourceDownloading illegal software.Spreading misinformation online.Hacking into computer systems.

Accepted Answer

Using copyrighted material without giving proper acknowledgement to the sourceReason — Plagiarism is stealing someone else's intellectual work, such as an idea, literary work or academic work etc., and representing it as our own work without giving credit to creator or without citing the source of information.

Question 11

Question 11Fill in the BlankThe COUNT(*) function provides the total number of ............... within a relation (table) in a relational database.ColumnsUnique valuesNot-null valuesRows

Accepted Answer

RowsReason — The COUNT(*) function provides the total number of rows within a relation (table) in a relational database. It counts all rows, including duplicates and NULL values.

Question 12

Question 12In which of the network topologies do all devices connect to a central point, such as a switch or hub?StarBusTreeMesh

Accepted Answer

StarReason — Star topology consists of a central node to which all other nodes are connected by a single path.

Question 13

Question 13In 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 ?0145

Accepted Answer

5Reason — In a Pandas DataFrame, if the tail() function is used without specifying an optional argument, it displays the last 5 rows by default.

Question 14

Question 14Identify the type of cybercrime that involves sending fraudulent emails to deceive individuals into revealing sensitive information.HackingPhishingCyberbullyingCyberstalking

Accepted Answer

PhishingReason — Phishing is the act of illegally acquiring personal and sensitive information such as, online banking details, credit card details, and other login details, of an individual by sending malicious e-mails or by creating web pages that can collect this information as they appear to come from very famous organizations.

Question 15

Question 15While creating a Series using a dictionary, the keys of the dictionary become:Values of the SeriesIndices of the SeriesData type of the SeriesName of the Series

Accepted Answer

Indices of the SeriesReason — While creating a Series using a dictionary, the keys of the dictionary become the indices of the Series. The values in the dictionary correspond to the data in the Series.

Question 16

Question 16Match the following SQL functions/clauses with their descriptions: SQL Function DescriptionP.MAX()1.Find the position of a substring in a string.Q.SUBSTRING()2.Returns the maximum value in a column.R.INSTR()3.Sorts the data based on a column.S.ORDER BY4.Extracts a portion of a string.P-2, Q-4, R-3, S-1P-2, Q-4, R-1, S-3P-4, Q-3, R-2, S-1P-4, Q-2, R-1, S-3

Accepted Answer

P-2, Q-4, R-1, S-3Reason —The MAX() function is used to return the maximum value from a specified column in a database table.The SUBSTRING() function extracts a portion of a string based on specified starting position and length.The INSTR() function returns the position of a substring within a string.The ORDER BY clause is used to sort the result set based on one or more columns in ascending or descending order.

Question 17

Question 17Fill in the BlankBoolean indexing in Pandas DataFrame can be used for ...............Creating a new DataFrameSorting data based on index labelsJoining data using labelsFiltering data based on condition

Accepted Answer

Filtering data based on conditionReason — Boolean indexing in Pandas DataFrame allows for the selection of rows based on a condition that evaluates to True or False.

Question 18

Question 18Which Matplotlib plot is best suited to represent changes in data over time?Bar plotHistogramLine plotHistogram & Bar plot

Accepted Answer

Line plotReason — A line plot shows changes over time by connecting data points, called "markers," with straight line segments. A line chart, or line graph, is a type of chart that displays continuous information effectively.

Question 19

Question 19Which type of network covers a small geographical area like a single office, building, or school campus?PANMANLANWAN

Accepted Answer

LANReason — LAN (Local Area Network) covers a small geographical area like a home, office, or school. It typically covers an area of up to 10 kilometers.

Question 20

Question 20Assertion (A): We can add a new column in an existing DataFrame.Reason (R): DataFrames are size mutable.Both A and R are true, and R is the correct explanation of A.Both A and R are true, and R is not the correct explanation of A.A is true but R is false.A is false but R is true.

Accepted Answer

Both A and R are true, and R is the correct explanation of A.ExplanationWe can add a new column to an existing DataFrame using the .at or .loc methods. A DataFrame is a two-dimensional data structure that is size-mutable. This means that we can add or drop elements in an existing DataFrame object without needing to create a new DataFrame internally.

Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065)

Section A 1 Mark Each

Section B 2 Marks Each

Section C 3 Marks Each

Section D 4 Marks Each

Section E 5 Marks Each