The CBSE Class 12 Informatics Practices (IP) Code 065 Sample Question Paper 2026-27 with Solution is a useful resource for students preparing for their upcoming CBSE Board Examination. This sample paper helps Class 12 students understand the latest exam pattern, question types, marking scheme, and distribution of marks in a better way. By practicing the sample questions and checking the detailed solutions, students can identify important topics, improve their problem-solving skills, and become familiar with the way questions are asked in the Informatics Practices examination.
Students are advised to solve the CBSE Class 12 IP (065) Sample Question Paper 2026-27 as part of their exam preparation and revision. It can help them assess their preparation level, manage their time effectively during the examination, and gain confidence before the final board exam. Links to sample question papers and solutions from other academic sessions are also available at the bottom of this post, allowing students to practice previous session papers and prepare for the examination in a more comprehensive manner.
CBSE Class 12 IP 065 Sample QP 2026-27 with Solution
You can download the free PDF of this sample pre-board question paper from our website and start practicing today. Download Link available in last.
The Year-Wise CBSE Class 12 Informatics Practices (065) Pre-Board and Sample Question Papers with Solutions are provided at the bottom of this post.
CBSE Class 12 IP 065 Sample Question Paper Session (2026-27)
CBSE | DEPARTMENT OF SKILL EDUCATION
INFORMATICS PRACTICES (SUBJECT CODE - 065)
Sample Question Paper (SQP) Solution for Class XII (Session 2026-2027)
Max. Time: 3 Hours
Max. Marks: 70
General Instructions:
- Please check this question paper contains 37 questions.
- All questions are compulsory. However, internal choices have been provided in some questions. Attempt only one of the choices in such questions
- The paper is divided into 5 Sections- A, B, C, D and E.
- Section A consists of 21 questions (1 to 21). Each question carries 1 Mark.
- Section B consists of 7 questions (22 to 28). Each question carries 2 Marks.
- Section C consists of 4 questions (29 to 32). Each question carries 3 Marks.
- Section D consists of 2 case study type questions (33 to 34). Each question carries 4 Marks.
- Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
- All programming questions are to be answered using Python Language only.
- In case of MCQ, text of the correct answer should also be written.
SECTION A (21x1=21 Marks)
1. A Pandas Series S1 is created with index labels ['a', 'b', 'c', 'd', 'e']. State whether the following statement is True or False:
"The statement S1['b':'d'] will produce the same result as S1[1:3]"
Ans: False
2. Ravi needs to find the total number of characters in the StudentName column. Which SQL function should he use?
a) COUNT()
b) SIZE()
c) LENGTH()
d) TOTAL()
3. Which type of Intellectual Property Right (IPR) protects an invention by giving the creator exclusive rights to make, use, and sell it for a specific period?
a) Copyright
b) Trademark
c) Patent
d) Software License
4. While plotting a graph using Matplotlib, which function is used to specify the label for the Y-axis?
a) label_y()
b) ylabel()
c) yaxis_name()
d) set_y()
5. I am a networking device that converts digital data from a computer into analog signals for transmission, and then converts incoming analog signals back into digital data for the computer to understand. Who am I?
a) Repeater
b) Router
c) Modem
d) Switch
6. Which of the following is a Data Manipulation Language (DML) command in SQL?
a) ALTER
b) DROP
c) UPDATE
d) CREATE
7. The process of re-selling old electronic goods after minor repairs or modification is called:
a) Recycling
b) Refurbishing
c) Reducing
d) Leaching
8. What will be the output of the following code?
import pandas as pd
print(pd.Series(5, index=[0, 1, 2]))
a) A Series with values 5, 5, 5
b) A Series with value 5 only at index 0
c) A Series with values 0, 1, 2
d) Error
9. Fill in the blank:
The SQL clause used to filter the groups formed by the GROUP BY clause based on a specific condition is ________.
Ans: HAVING
10. Riya visited an online shopping website, and it saved small text files on her computer to remember her preferences and session details. What are these files called?
a) Plug-ins
b) Add-ons
c) Cookies
d) Scripts
11. Which keyword is used with the ORDER BY clause to sort data in descending order?
a) DESC
b) DOWN
c) DSC
d) REVERSE
12. If we add two Pandas Series that do not have matching index labels, the result for those non-matching indices will be:
a) 0
b) Error
c) NaN
d) Empty string
13. The process of buying electronic gadgets only when necessary to minimize the generation of electronic waste is an example of which 'R' of e-waste management?
a) Recycle
b) Reuse
c) Reduce
d) Refurbish
14. Which SQL function is used to extract a specific number of characters from a string starting from a given position?
a) LEFT()
b) RIGHT()
c) LENGTH()
d) MID()
15. Aman is exporting a Pandas DataFrame to a CSV file using the to_csv() function. He wants to save only the data and avoid writing the row indices to the file. Which parameter should he set to False to prevent the indices from being included?
a) header
b) sep
c) index
d) columns
16. Fill in the blank:
The process of storing a website on a web server so that it can be accessed over the internet is known as ________.
Ans: Web Hosting / Hosting
17. A HR manager queries an employee database. He wants to retrieve only those records where the Commission field actually contains a value. Which SQL condition should he use?
a) WHERE Commission != NULL
b) WHERE Commission IS NOT NULL
c) WHERE Commission <> NULL
d) WHERE Commission NOT NULL
18. When creating a DataFrame from a list of dictionaries, the dictionary keys become:
a) Row indices
b) Data values
c) Column labels
d) Positional Index
19. State whether the following statement is True or False:
In SQL, the BETWEEN operator is inclusive of both the lower and upper values specified in the range.
Ans: True
Q.20 and Q.21 are Assertion (A) and Reason (R) Type questions. Choose the correct option.
20. Assertion (A): The statement df.drop('Science', axis=0) will remove the column labeled 'Science' from the DataFrame.
Reason (R): In Pandas drop() method, axis=0 refers to row-wise operations and axis=1 refers to column-wise operations.
a) Both A and R are True, and R correctly explains A
b) Both A and R are True, but R does not correctly explain A
c) A is True, but R is False
d) A is False, but R is True
21. Assertion (A): In SQL, the query select * from emp; and SELECT * FROM EMP; will produce the same result.
Reason (R): SQL is a case-sensitive language.
a) Both A and R are True, and R correctly explains A
b) Both A and R are True, but R does not correctly explain A
c) A is True, but R is False
d) A is False, but R is True
SECTION B (22 to 28) 7x2=14 Marks
22. (A) (i) Explain the use of the head() function in a Pandas DataFrame.
Ans: The head() function in Pandas is used to display the first few (n) rows of a DataFrame.
Syntax: DataFrame.head(n)
(ii) What happens if the parameter n is not specified in the head() function?
Ans: If the parameter n is not specified in the head() function, it displays the first 5 rows of the Pandas DataFrame by default.
OR
(B) Explain the concept of Boolean Indexing in DataFrames. Write a small Python code example to demonstrate it.
Ans: Boolean Indexing is a technique used in Pandas to filter rows of a DataFrame based on a condition. It creates a Boolean (True/False) condition for each row and returns only the rows where the condition is True.
import pandas as pd
data = {
"Name": ["Aman", "Riya", "Karan", "Neha"],
"Marks": [85, 92, 68, 78]
}
df = pd.DataFrame(data)
# Select students who scored more than 80
result = df[df["Marks"] > 80]
print(result)
Output:
| Name | Marks | |
|---|---|---|
| 0 | Aman | 85 |
| 1 | Riya | 92 |
23. Differentiate between an Active and a Passive digital footprint.
Ans: Active footprint: Information you deliberately share online.
Example: Posting a photo or comment on social media.
Passive footprint: Information collected about you automatically while you use the Internet.
Example: A website recording your IP address or browsing activity.
24. Define Data Visualization and state its primary purpose.
Ans: Data Visualization is the process of representing data in a graphical or visual form, such as charts, graphs, and plots. Its main purpose is to make data easier to understand, analyse, and interpret by presenting complex information visually.
25. Define Star Topology. Mention one major advantage of using it.
Ans: In star topology, each node is directly connected to a central controller (hub or switch).
Advantage: Failure of one node does not affect the rest of the network.
OR
What is VoIP? State any one advantages of using VoIP for communication.
Ans: VoIP stands for Voice over Internet Protocol, which allows voice transmission over a computer network rather than traditional telephone lines.
Advantages: It is generally cost-effective, especially for long-distance and international calls, as it uses an Internet connection.
26. Write SQL queries for the following requirements:
I. Display the last 3 characters of the attribute Ename from the EMPLOYEE table.
Ans: SELECT RIGHT(Ename, 3) FROM EMPLOYEE;
II. Find the position of the substring 'ma' in the string 'Informatics'.
Ans: SELECT INSTR('Informatics', 'ma');
27. Mention and briefly explain any two guidelines of netiquette.
Ans: (i) Be respectful: Use polite and appropriate language while communicating online. Avoid insulting, abusing, or offending others.
(ii) Protect privacy: Do not share personal or private information of yourself or others without permission. Avoid posting someone else's photos, messages, or personal details without their consent.
28. Consider the following two dictionaries:
dict1 = {'a': 10, 'b': 20}
dict2 = {'a': 5, 'b': 10, 'c': 20}
Write Python code to create a DataFrame from a list containing the above two dictionaries.
Ans:
import pandas as pd
dict1 = {'a': 10, 'b': 20}
dict2 = {'a': 5, 'b': 10, 'c': 20}
df = pd.DataFrame([dict1, dict2])
print(df)
OR
Mention the purpose of read_csv() and explain the use of its sep parameter.
Ans: read_csv() function in Pandas is used to read data from a CSV (Comma-Separated Values) file and create a DataFrame.
SECTION C (29 to 32) 4x3=12 Marks
29. Consider the following digital security scenarios and answer the questions:
I. Mehak receives an SMS from an unknown number stating she has won a lottery. To claim it, she must click a link and enter her Aadhaar number and bank OTP. What type of cybercrime is this?
Ans: Phishing
II. A group of people repeatedly post insulting comments and spread rumors about a classmate on a social media platform to distress them. What is this activity called?
Ans: Cyber Bullying
III. Suggest one Communication Etiquette that should be followed to maintain credibility while participating in an online discussion forum.
Ans: Be credible, Use polite language
30. (A) (i) Write a Python program to create a Pandas Series named Inventory from the following dictionary:
stock = {'Pens': 150, 'Erasers': 80, 'Sharpeners': 60, 'Notebooks': 200}
Ans:
import pandas as pd
stock = {'Pens': 150, 'Erasers': 80, 'Sharpeners': 60, 'Notebooks': 200}
Inventory = pd.Series(stock)
print(Inventory)
(ii) Consider two Series S1 and S2:
import pandas as pd
S1 = pd.Series([10, 20], index=['a', 'b'])
S2 = pd.Series([30, 40], index=['b', 'c'])
Write the output of the statement: print(S1 + S2)
Ans: Output:
| a | NaN |
| b | 50.0 |
| c | NaN |
OR
(B) Consider a DataFrame df as shown belows:
| Name | IP | Maths | |
|---|---|---|---|
| 0 | Arpit | 95 | 88 |
| 1 | Vani | 89 | 92 |
| 2 | Chetan | 78 | 80 |
Write Pandas statements to perform the following actions:
(i) Add a new column 'Total' containing the values [183, 181, 158].
Ans: df['Total'] = [183, 181, 158]
(ii) Rename the 'Name' column to 'Student'.
Ans: df.rename(columns={'Name': 'Student'}, inplace=True)
(iii) Delete the 'Maths' column from the DataFrame.
Ans: df.drop(columns=['Maths'], inplace=True)
31. Consider the table HOSPITAL, which contains the following columns:
| Column Name | Remark |
|---|---|
| PNo | Patient Number |
| PName | Patient Name |
| Dept | Department |
| DOA | Date of Admission |
Table: HOSPITAL
| PNo | PName | Dept | DOA |
|---|---|---|---|
| 101 | Ravi Kumar | Cardiology | 2024-05-12 |
| 102 | Anita Sharma | Neurology | 2025-06-01 |
| 103 | Mohan Das | Cardiology | 2023-05-18 |
| 104 | Seema Verma | Orthopedics | 2022-04-22 |
| 105 | Rahul Singh | Cardiology | 2025-03-30 |
Write SQL queries to perform the following tasks:
(i) Display the names of all patients in the Cardiology department in lowercase.
Ans: SELECT LOWER(PName) FROM HOSPITAL WHERE Dept = 'Cardiology';
(ii) Display each patient's number along with the day name of the week on which they were admitted.
Ans: SELECT PNo, DAYNAME(DOA) FROM HOSPITAL;
(iii) Display the patient names arranged in alphabetical order.
Ans: SELECT PName FROM HOSPITAL ORDER BY PName ASC;
32. (A) Consider a table named STUDENT containing the following data:
| SID | Name | DOB |
|---|---|---|
| 1 | Aman | 2005-08-15 |
| 2 | Vinod | 2006-01-26 |
| 3 | Saurabh | 2004-01-01 |
Write the output of the following SQL queries:
(i) SELECT UPPER(Name), LENGTH(Name) FROM STUDENT WHERE ID = 2;
Ans:
| UPPER(Name) | LENGTH(Name) |
|---|---|
| VINOD | 5 |
(ii) SELECT DAY(DOB), YEAR(DOB) FROM STUDENT WHERE ID = 3;
Ans:
| DAY(DOB) | YEAR(DOB) |
|---|---|
| 1 | 2004 |
(iii) SELECT RIGHT(Name, 3) FROM STUDENT WHERE ID = 1;
Ans:
| RIGHT(Name, 3) |
|---|
| man |
OR
(B) Write the output of the following SQL queries:
(i) SELECT POWER(MOD(13, 5), 2);
Ans: 9
(ii) SELECT UCASE(MID("Digital India", 9, 5));
Ans: INDIA
(iii) SELECT LENGTH(TRIM(" Informatics "));
Ans: 11
SECTION D (33 to 34) 2x4=8 Marks
33. Write a Python program using Matplotlib to plot a Line Graph showing the "Monthly Sales" of a shop with the following data:
Months: ['Jan', 'Feb', 'Mar', 'Apr']
Sales: [12000, 15000, 11000, 18000]
The program should include:
- Code to import the required library.
- Code to plot the line graph with a label "Sales".
- A title "Sales Performance".
- Labels for both X-axis ("Month") and Y-axis ("Amount").
- Code to display the legend and show the plot.
Ans:
import matplotlib.pyplot as plt
# Data
months = ['Jan', 'Feb', 'Mar', 'Apr']
sales = [12000, 15000, 11000, 18000]
# Plot line graph
plt.plot(months, sales, label='Sales')
# Add title and axis labels
plt.title('Sales Performance')
plt.xlabel('Month')
plt.ylabel('Amount')
# Display legend and graph
plt.legend()
plt.show()
34. (A) Consider the following tables:
Table: SPORTS
| RegNo | SName | Game | Fees |
|---|---|---|---|
| 101 | Aryan | Cricket | 500 |
| 102 | Riya | Tennis | 600 |
| 103 | Kabir | Cricket | 500 |
| 104 | Ishaan | Tennis | 600 |
| 105 | Tejas | Football | 750 |
| CoachID | CName | Game |
|---|---|---|
| C1 | Venkatesh | Cricket |
| C2 | Rameshwar | Tennis |
| C3 | Sridhar | Football |
Write SQL queries for the following:
(i) Display the Game name and the total fees collected for each game, but only for those games where the total fees exceed 1000.
Ans: SELECT Game, SUM(Fees) FROM SPORTS GROUP BY Game HAVING SUM(Fees) > 1000;
(ii) Display the Student Name (SName) and their respective Coach Name (CName).
Ans: SELECT SName, CName FROM SPORTS, COACH WHERE SPORTS.Game = COACH.Game;
OR
(B) Consider the following tables:
Table: Employee
| EmpID | Name | DeptID | Salary |
|---|---|---|---|
| 301 | Aarav | D1 | 5200 |
| 302 | Riya | D2 | 7500 |
| 303 | Kabir | D2 | 6800 |
| 304 | Ananya | D3 | 4000 |
| 305 | Ishaan | D1 | 4900 |
Table: Department
| DeptID | DeptName |
|---|---|
| D1 | HR |
| D2 | IT |
| D3 | Sales |
Write the output of the following SQL Queries.
I. SELECT DeptID, COUNT(*), MAX(Salary) FROM Employee GROUP BY DeptID HAVING COUNT(*) > 1 ORDER BY DeptID;
Ans:
| DeptID | COUNT(*) | MAX(Salary) |
|---|---|---|
| D1 | 2 | 5200 |
| D2 | 2 | 7500 |
II. SELECT Name, DeptName FROM Employee, Department WHERE Employee.DeptID = Department.DeptID AND Employee.Salary > 6000;
Ans:
| Name | DeptName |
|---|---|
| Riya | IT |
| Kabir | IT |
SECTION E (35 to 37) 3x5=15 Marks
35. Tech-Innovate Pvt Ltd is a leading technology solutions provider renowned for delivering innovative digital services to clients worldwide. The company operates from a spacious campus comprising four blocks: Block A, Block B, Block C, and Block D.
| Tech-Innovate Pvt Ltd | |
|
Block A
|
Block B
|
|
Block C
|
Block D
|
To ensure smooth communication, centralized data storage, and high-speed connectivity across the campus, the organization plans to set up a structured network connecting all blocks.
The following tables provide the distances between the blocks and the number of computers in each block.
| From To | Distance (meters) |
| Block A to Block B | 40 meters |
| Block A to Block C | 50 meters |
| Block A to Block D | 160 meters |
| Block B to Block C | 70 meters |
| Block B to Block D | 60 meters |
| Block C to Block D | 120 kilometers |
The number of computers in each department/office is as follows:
| Block | Number of Computers |
| Block A | 25 |
| Block B | 60 |
| Block C | 15 |
| Block D | 150 |
As a network engineer, answer the following questions based on the details given above:
I. Suggest the most suitable block to install the server. Justify your answer.
Ans: Block D. It is the most suitable because it has the maximum number of computers (150).
II. What type of network (PAN, LAN, MAN, or WAN) will be formed within the campus?
Ans: LAN (Local Area Network). The distance is within a single campus/limited area.
III. Suggest the placement of a Switch with suitable justification.
Ans: Switch: Every block (A, B, C, D) should have a switch to connect multiple computers within that block.
IV. The company wants to host a website where clients can log in and see real-time project updates. Should they develop a Static or a Dynamic website? Why?
Ans: Dynamic Website. Since it involves user logins and real-time data updates from a database, a dynamic site is required.
V. Identify between which blocks a repeater is needed and justify your answer.
Ans: Between Block A and Block D, & Block C and Block D, because Repeaters are needed as distance exceeds ~100m for Ethernet.
36. I. Create a DataFrame named StoreDF as shown below using dictionary of series:
| Items | Qualtity | Unit_Price | |
|---|---|---|---|
| 0 | Bread | 50 | 30 |
| 1 | Milk | 100 | 25 |
| 2 | Eggs | 120 | 6 |
Write suitable Pandas statements to Perform the following operations:
Ans:
import pandas as pd
Items = pd.Series(['Bread', 'Milk', 'Eggs'])
Quality = pd.Series([50, 100, 120])
Unit_Price = pd.Series([30, 25, 6])
StoreDF = pd.DataFrame({
'Items': Items,
'Qualtity': Quality,
'Unit_Price': Unit_Price
})
print(StoreDF)
II. Add a new row containing data [Butter, 40, 55]
Ans: StoreDF.loc[3] = ['Butter', 40, 55]
III. Display values of Items column only,
Ans: print(StoreDF['Items'])
37. (A) Refer to the table given below:
Table: BOOK
| BookID | Title | Author | Price |
|---|---|---|---|
| 201 | Wings of Fire | A P J Abdul Kalam | 350 |
| 202 | The Guide | R. K. Narayan | 299 |
| 203 | The God of Small Things | Arundhati Roy | 399 |
| 204 | Malgudi Days | R. K. Narayan | 280 |
Write SQL commands for the following tasks:
I. Insert a new record into the table with the values: 205, The White Tiger, Aravind Adiga, 350.
Ans: INSERT INTO BOOK VALUES (205, 'The White Tiger', 'Aravind Adiga', 350);
II. Update the Price of the book with BookID 202 to 325.
Ans: UPDATE BOOK SET Price = 325 WHERE BookID = 202;
III. Delete the records of all books written by 'R. K. Narayan'.
Ans: DELETE FROM BOOK WHERE Author = 'R. K. Narayan';
IV. Add a new column Publisher of type VARCHAR(30) to the table.
Ans: ALTER TABLE BOOK ADD Publisher VARCHAR(30);
V. Drop the table BOOK from the database.
Ans: DROP TABLE BOOK;
OR
(B) Consider a table named PRODUCT, which contains the following columns: PCode, PName, Category, Qty, Price, ExpiryDate.
The columns are described as follows:
PCode – A unique code assigned to each product.
PName – The name of the product.
Category – The category or type of the product.
Qty – The available quantity of the product.
Price – The unit price of the product.
ExpiryDate – The expiration date of the product.
Write SQL queries for:
I. Display PName and its Price rounded to one decimal place.
Ans: SELECT PName, ROUND(Price, 1) FROM PRODUCT;
II. Display the names of products that end with the letter 's'.
Ans: SELECT PName FROM PRODUCT WHERE RIGHT(PName,1) = 's';
III. Display the PName and Category of those products whose Price is less than or equal to 500.
Ans: SELECT PName, Category FROM PRODUCT WHERE Price <= 500;
IV. Display the total quantity of all products.
Ans: SELECT SUM(Qty) FROM PRODUCT;
V. Display PName after removing leading spaces only.
Ans: SELECT LTRIM(PName) FROM PRODUCT;
Download Now - Class 12 IP 065 Sample Question Paper 2025-26 with Solution
