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 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 3

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.

Source: This question is from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065), Informatics Practices &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065): Question, Network, Topologies, Devices, Connect, Central. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065)Q1: Question 1 State whether the following statement is True or False: Slicing can be used to extract a...
Q10: Question 28(B) Complete the given Python code to get the required output (ignore the dtype...
Q11: Question 11 Fill in the Blank The COUNT(*) function provides the total number of ..................
Q13: Question 13 In a Pandas DataFrame, if the tail() function is used without specifying the optional...
Q14: Question 14 Identify the type of cybercrime that involves sending fraudulent emails to deceive...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065) &mdash; Informatics Practices, Class 12 CBSE

Question 4

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.

Source: This question is from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065), Informatics Practices &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065): Question, Pandas, Dataframe, Tail, Without, Specifying. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065)Q1: Question 1 State whether the following statement is True or False: Slicing can be used to extract a...
Q10: Question 28(B) Complete the given Python code to get the required output (ignore the dtype...
Q11: Question 11 Fill in the Blank The COUNT(*) function provides the total number of ..................
Q14: Question 14 Identify the type of cybercrime that involves sending fraudulent emails to deceive...
Q15: Question 15 While creating a Series using a dictionary, the keys of the dictionary become: Values...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065) &mdash; Informatics Practices, Class 12 CBSE

Question 5

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 6

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 7

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 8

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 9

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 10

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.

Source: This question is from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065), Informatics Practices &mdash; Class 12, CBSE Board.
Key Concepts CoveredThis question tests your understanding of the following concepts from the chapter Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065): Question, Network, Covers, Small, Geographical, Area. These are fundamental topics in Informatics Practices that students are expected to master as part of the CBSE Class 12 curriculum.A thorough understanding of these concepts will help you answer similar questions confidently in your CBSE examinations. These topics are frequently tested in both objective and subjective sections of Informatics Practices papers. We recommend revising the relevant section of your textbook alongside practising these solved examples to build a strong foundation.
How to Approach This QuestionRead the question carefully and identify what is being asked. Break down complex questions into smaller parts. Use the terminology and concepts discussed in this chapter. Structure your answer logically — begin with a definition or key statement, then provide supporting details. Review your answer to ensure it addresses all parts of the question completely.
Key Points to RememberRead the question carefully and identify all parts before answering.
Use the terminology specific to this subject and chapter.
Review the textbook content for this chapter before attempting questions.
Practice writing concise, well-structured answers within time limits.
Related Questions from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065)Q1: Question 1 State whether the following statement is True or False: Slicing can be used to extract a...
Q10: Question 28(B) Complete the given Python code to get the required output (ignore the dtype...
Q11: Question 11 Fill in the Blank The COUNT(*) function provides the total number of ..................
Q13: Question 13 In a Pandas DataFrame, if the tail() function is used without specifying the optional...
Q14: Question 14 Identify the type of cybercrime that involves sending fraudulent emails to deceive...
Practice more questions from Solved 2025 Sample Question Paper CBSE Class 12 Informatics Practices (065) &mdash; Informatics Practices, Class 12 CBSE

Question 11

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.

Question 12

Question 21Assertion (A): In SQL, INSERT INTO is a Data Definition Language (DDL) Command.Reason (R): DDL commands are used to create, modify, or remove database structures, such as tables.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

A is false but R is true.ExplanationIn SQL, INSERT INTO is a Data Manipulation Language (DML) Command. Data definition language (DDL) commands in SQL are used to define a database, including creating, altering, and dropping tables.

Question 13

Question 26Define the term Primary Key in a database. Explain how it is different from a Candidate Key.

Accepted Answer

A primary key is a set of one or more attributes/fields that can uniquely identify tuples/rows within the relation (table). It must contain unique values and cannot be null.A candidate key, on the other hand, refers to all the attributes in a relation that are candidates or are capable of becoming a primary key. A table can have multiple candidate keys, but only one of them is chosen as the primary key.

Question 14

Question 27Mention two health concerns associated with excessive use of Digital Devices.

Accepted Answer

The two health concerns associated with excessive use of digital devices are as follows:Impact on Hearing — Listening to loud music for over 15 minutes can cause hearing damage. Using headphones for long periods increases bacteria in the ears by over 700 times.Impact on Bones and Joints — Technology affects posture due to prolonged sitting and repetitive movements, leading to muscle and joint strain. Repetitive Strain Injuries (RSIs) affect muscles, nerves, tendons, ligaments, and joints.

Question 15

Question 28(A)Sneha is writing a Python program to create a DataFrame using a list of dictionaries. However, her code contains some mistakes. Identify the errors, rewrite the correct code, and underline the corrections made.import Pandas as pd 
D1 = {'Name': 'Rakshit', 'Age': 25} 
D2 = {'Name': 'Paul', 'Age': 30} 
D3 = {'Name': 'Ayesha", 'Age': 28} 
data = [D1, D2, D3) 
df = pd.Dataframe(data) 
print(df)

Accepted Answer

import Pandas as pd # Error 1
D1 = {'Name': 'Rakshit', 'Age': 25} 
D2 = {'Name': 'Paul', 'Age': 30} 
D3 = {'Name': 'Ayesha", 'Age': 28} # Error 2
data = [D1, D2, D3) # Error 3
df = pd.Dataframe(data) # Error 4
print(df)Error 1 — The module should be imported as import pandas as pd (lowercase).Error 2 — In D3, the value has mismatched quotes.Error 3 — The list data should use square brackets [], not parentheses.Error 4 — The Dataframe should be DataFrame (capital 'F').The corrected code is:import pandas as pd 
D1 = {'Name': 'Rakshit', 'Age': 25} 
D2 = {'Name': 'Paul', 'Age': 30} 
D3 = {'Name': 'Ayesha', 'Age': 28} 
data = [D1, D2, D3] 
df = pd.DataFrame(data) 
print(df)

Question 16

Question 28(B)Complete the given Python code to get the required output (ignore the dtype attribute) asOutput:Tamil Nadu       Chennai   
Uttar Pradesh    Lucknow   
Manipur           Imphal   
Code:import _______ as pd 
data = ['Chennai','_______','Imphal'] 
indx = ['Tamil Nadu','Uttar Pradesh','Manipur'] 
s = pd.Series(_______, indx) 
print(_______)

Accepted Answer

import pandas as pd 
data = ['Chennai', 'Lucknow', 'Imphal'] 
indx = ['Tamil Nadu','Uttar Pradesh','Manipur'] 
s = pd.Series(data, indx) 
print(s)

Question 17

Question 31I. Write an SQL statement to create a table named STUDENTS, with the following specifications:Column NameData TypeKeyStudentIDNumericPrimary KeyFirstNameVarchar(20)LastNameVarchar(10)DateOfBirthDatePercentageFloat(10, 2)II. Write SQL Query to insert the following data in the Students Table1, Supriya, Singh, 2010-08-18, 75.5

Accepted Answer

I.CREATE TABLE STUDENTS ( 
StudentID NUMERIC PRIMARY KEY, 
FirstName VARCHAR(20),
LastName VARCHAR(10), 
DateOfBirth DATE, 
Percentage FLOAT(10,2) 
);II.INSERT INTO STUDENTS (StudentID, FirstName, LastName, 
DateOfBirth, Percentage) VALUES (1, 'Supriya', 'Singh', '2010-08-18', 
75.5);

Question 18

Question 32(A)Consider the following tables:Table 1:EMPLOYEE which stores Employee ID (EMP_ID), Employee Name (EMP_NAME), Employee City (EMP_CITY)Table 2:PAYROLL which stores Employee ID (EMP_ID), Department (DEPARTMENT), Designation (DESIGNATION), and Salary (SALARY) for various employees.Note: Attribute names are written within brackets.Table: EMPLOYEEEMP_IDEMP_NAMEEMP_CITY1ABHINAVAGRA2KABIRFARIDABAD3ESHANOIDA4PAULSEOUL5VICTORIALONDONTable: PAYROLLEMP_IDDEPARTMENTDESIGNATIONSALARY1SALESMANAGER750002SALESASSOCIATE500003ENGINEERINGMANAGER950004ENGINEERINGENGINEER700005MARKETINGMANAGER65000Write appropriate SQL queries for the following:I. Display department-wise average Salary.II. List all designations in the decreasing order of Salary.III. Display employee name along with their corresponding departments.

Accepted Answer

I.SELECT DEPARTMENT, AVG(SALARY) 
FROM PAYROLL 
GROUP BY DEPARTMENT; II.SELECT DESIGNATION 
FROM PAYROLL 
ORDER BY SALARY DESC; III.SELECT EMP_NAME, DEPARTMENT 
FROM EMPLOYEE E, PAYROLL P 
WHERE E.EMP_ID = P.EMP_ID;

Question 19

Question 32(B)Consider the following tables:Table 1:ATHLETE, which stores AthleteID, Name, Country. The table displays basic information of the athletes.Table 2:MEDALS, which stores AthleteID, Sport, and Medals. The table displays the number of medals won by each athlete in their respective sports.Table: ATHLETEAthleteIDNameCOUNTRY101ArjunINDIA102PriyaINDIA103AsifUAE104RozyUSA105DavidDENMARKTable: MEDALSAthleteIDSportMedals101Swimming8102Track3103Gymnastics5104Swimming2105Track6Write appropriate SQL queries for the following:I. Display the sports-wise total number of medals won.II. Display the names of all the Indian athletes in uppercase.III. Display the athlete name along with their corresponding sports

Accepted Answer

I.SELECT Sport, SUM(Medals) 
FROM MEDALS 
GROUP BY Sport;II.SELECT UPPER(Name) 
FROM ATHLETE 
WHERE Country = 'INDIA'; III.SELECT Name, Sport 
FROM ATHLETE A, MEDALS M 
WHERE A.AthleteID= M.AthleteID;

Question 20

Question 34(A)Rahul, who works as a database designer, has developed a database for a bookshop. This database includes a table BOOK whose column (attribute) names are mentioned below:BCODE: Shows the unique code for each book.TITLE: Indicates the book’s title.AUTHOR: Specifies the author’s name.PRICE: Lists the cost of the book.Table: BOOKBCODETITLEAUTHORPRICEB001MIDNIGHT'S CHILDRENSALMAN RUSHDIE500B002THE GOD OF SMALL THINGSARUNDHATI ROY450B003A SUITABLE BOYVIKRAM SETH600B004THE WHITE TIGERARAVIND ADIGA399B005TRAIN TO PAKISTANKHUSHWANT SINGH350I. Write SQL query to display book titles in lowercase.II. Write SQL query to display the highest price among the books.III. Write SQL query to display the number of characters in each book title.IV. Write SQL query to display the Book Code and Price sorted by Price in descending order.

Accepted Answer

I.SELECT LOWER(TITLE) 
FROM BOOK;  II.SELECT MAX(PRICE) 
FROM BOOK; III.SELECT LENGTH(TITLE) 
FROM BOOK; IV.SELECT BCODE, PRICE 
FROM BOOK 
ORDER BY PRICE DESC;

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