Class 12 IP 065 Sample Pre-Board QP 2026
The Class 12 Informatics Practices (IP) Sample Pre-Board Question Paper 2026 is designed to help students prepare effectively for their upcoming exams. Based on the latest CBSE syllabus 2025–26, this paper reflects the updated exam pattern, marking scheme, and question style that students will face in their Pre-Boards as well as the Final Board Examination.
This sample question paper includes a balanced mix of questions—ranging from short answer to long answer types. Students will find case study-based questions, Python programming questions, SQL queries, and data handling tasks using Pandas and Matplotlib, all structured exactly as per CBSE guidelines. The paper also covers important chapters such as data visualization, data management, and cyber safety, ensuring that the entire curriculum is thoroughly revised.
Practicing with this Pre-Board Sample QP helps students improve their accuracy, speed, and confidence. It prepares them for the real exam environment by giving them a clear idea of the difficulty level and the types of questions expected. Solving this paper is highly recommended for students who want to identify their strengths, overcome weak areas, and score higher in the actual board exam.
CBSE Class 12 IP 065 Sample Pre-Board Question Paper 2026
SAMPLE PRE-BOARD QUESTION PAPER – SET 1 (THEORY)
CLASS: XII SESSION: 2025-26
INFORMATICS PRACTICES (065)
Time allowed: 3 Hours
Maximum Marks: 70
General Instructions:
- All questions are compulsory.
- The examination paper contains five sections, from Section A to Section 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 questions (33 to 34). Each question carries 4 Marks.
- Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
- There is no overall choice. However, internal choices have been provided in some questions. A student has to attempt only one of the choices in such questions.
- All programming questions are to be answered using Python Language only.
- In case of MCQ, text of the correct answer should also be written.
1. State whether the following statement is True or False:
The df.size attribute in Pandas returns the number of rows and columns in a DataFrame as a tuple
2. The expression ROUND(15.678, 0) in SQL gives:
a) 16
b) 15.6
c) 15
d) 15.67
3. Riya created a fake profile to harass her friend online. Identify the cybercrime.
a) Hacking
b) Cyber Bullying
c) Phishing
d) Plagiarism
4. The correct function to read data from a CSV file into Pandas is:
a) pd.load_csv()
b) pd.read_csv()
c) pd.import_csv()
d) pd.open_csv()
5. Which device regenerates signals in a network?
a) Switch
b) Repeater
c) Hub
d) Modem
6. What will be the output of the following SQL query?SELECT SUBSTR('VIKISIT BHARAT', 2, 6);a) VIKISI
b) IKISIT
c) KISIT B
d) IKISIT B
7. Rohit designed a unique company logo for his new startup. Which type of Intellectual Property right protects it?
a) Patent
b) Copyright
c) Trademark
d) Industrial Design
8. Default axis for drop() method in Pandas is:
a) 0
b) 1
c) None
d) 2
9. A table named Employees has one primary key and two alternate keys. How many candidate keys does the table have?
a) 1
b) 2
c) 3
d) 4
10. Which of the following is used for file transfer between computers?
a) FTP
b) VoIP
c) SMS
d) Video Call
11. What will be the output of the following SQL command?SELECT MONTHNAME('2024-08-02');a) 08
b) 02
c) February
d) August
12. Which of the following Python statements will be used to select a specific element having index as points, from a Pandas Series named ser?
a) ser.element(points)
b) ser.select(points)
c) ser[points]
d) ser.show(points)
13. Which of the following is NOT a cybercrime?
a) Sending malicious emails
b) Unauthorized access to data
c) Online fraud
d) Installing licensed software
14. Which SQL clause is used to remove duplicate records?
a) DISTINCT
b) UNIQUE
c) ONLY
d) CLEAN
15. A DataFrame column can be accessed using:
a) df.columnname
b) df[‘columnname’]
c) df(columnname)
d) Both a) and b)
16. Which topology uses a single backbone cable to connect all computers?
a) Star
b) Bus
c) Mesh
d) Ring
17. Which SQL function calculates ab?
a) MOD()
b) POWER()
c) RAISE()
d) ROUND()
18. Which of the following libraries defines an ndarray in Python?
a) pandas
b) numpy
c) matplotlib
d) scipy
19. Which of the following is an aggregate function?
a) LENGTH()
b) SUM()
c) SUBSTR()
d) LOWER()
Q-20 and Q-21 are A & R Type questions. Choose the correct option as:
a) Both A & R are true, and R is the correct explanation of A
b) Both A & R are true, but R is not the correct explanation of A
c) A is True, but R is False
d) Assertion (A) is False, but Reason (R) is True.
20. Assertion (A) : The Pandas library in Python is primarily used for creating static, animated and interactive 2D plots or figures.
Reason (R) : Data visualization can be achieved with the help of a variety of charts and plots, including static plots, animations, and interactive visualizations.
21. Assertion (A): The SUBSTR() function extracts a portion of a string based on starting position and length.
Reason (R): The starting position in SUBSTR() begins from 0 in SQL.
SECTION B (7X2=14 Marks)
22. What is the difference between df.head() and df.tail() in Pandas?
OR
What is the difference between a 1-dimensional and a 2-dimensional data structure in Pandas? Give examples.
23. Define cyber safety. Mention two precautions to stay safe while using social media.
24. Amit wants to create a Pandas Series as shown below:
| Fruits | Quanity |
| Apple Mango Orange | 50 30 40 |
Help him complete the code below:
import _____ as pd
fruit_data = _____
s = pd.__(fruit_data)
print(s)
25. Briefly explain the difference between a webpage and website.
OR
Satyam is doing a course in networking. He is unable to understand the concept of URL. Help him by explaining it with the help of a suitable example.
26. i. Display the year from the date ‘2024-12-31’.
ii. Find the position of the substring ‘SQL’ in ‘Learning SQL is fun’.
27. Riya often posts photos and comments online, while her friend Amit’s browsing data is collected automatically by websites.
i. Identify the type of digital footprint each one is leaving.
ii. Justify your answer.
28. Write the output of the following code:
import pandas as pd
df1 = pd.DataFrame({'Juice' : ['Mango', 'Orange', 'Apple'], 'Snacks' : ['Chips', 'Namkeen', 'Biscuits']})
df2 = pd.DataFrame({'ColdDrink' : ['Pepsi', 'Coke'],'Juice' : ['Mango', 'Orange'], 'Snacks' : ['Chips', 'Namkeen']})
print(df2.reindex_like(df1))OR
import pandas as pd
df = pd.DataFrame({ 'Fruits' : ['Apple', 'Banana', 'Mango'], 'Rate' : [120, 60, 90]})
df2 = df. rename (columns = {'Rate':' Price', 'Fruits': 'Fruit_Name'}) print(df2)Section C (4X3=12 Marks)
29. Identify the type of cybercrime for the following situations:
i. A person complains that Rs. 4.25 lacs have been fraudulently stolen from his/her account online via some online transactions in two days using NET BANKING.
ii. A person complains that his/her debit/credit card is safe with him still somebody has done shopping /ATM transaction on this card.
iii. A person complains that somebody has created a fake profile of Facebook and defaming his/her character with abusive comments and pictures
30. Mr. Krishnamurthy, who is a new user of Python Pandas, has created the following Series “Electrical” as shown below using ndarray, where watts are the indices & the Name of electrical appliances are values in the series.
| Index | Name |
| 12W | LED |
| 200W | Fan |
| 1000W | Electrical Iron |
| 1200W | RiceCooker |
Help him in writing the code.
OR
Write a Python program to create the pandas DataFrame displayed below using list of dictionaries.
| Player | Score | |
| 0 | Rohit | 75 |
| 1 | Virat | 95 |
| 2 | Dhoni | 88 |
| 3 | Surya | 70 |
31. Create a table named ORDERS with the following fields:
| Column Name | Data Type | Key |
|---|---|---|
| OrderID | Int | Primary Key |
| OrderDate | Date | |
| CustomerID | Int | |
| TotalAmount | Float(7,2) |
(a) Write SQL command to create the table.
(b) Insert the record: (501, ‘2024-10-15’, 2001, 3499.90)
32. (A) BookWorld maintains authors and their books in two tables.
Table 1: AUTHORS
| AuthorID | Name | Country |
|---|---|---|
| 1 | J.K. Rowling | UK |
| 2 | Chetan Bhagat | India |
| 3 | George Orwell | UK |
Table 2: BOOKS
| BookID | AuthorID | Name | Country |
|---|---|---|---|
| 101 | 1 | Harry Potter | 500 |
| 102 | 2 | Two States | 300 |
| 103 | 1 | Fantasticc Beats | 450 |
| 104 | 3 | 1984 | 400 |
i. Write an SQL query to display Book Title and its length, sorted by length of the title in descending order.
ii. Write an SQL query to display the first 5 characters of each Book Title along with the total length of the title.
iii. Write an SQL query to display each Author Name and the total price of all their books.
OR
(B) SunTech Electronics maintains a table SALES to track product sales.
| SaleID | SaleDate | ProductName | Quantity | Amount | CustomerCity |
|---|---|---|---|---|---|
| 101 | 2025-03-05 | Laptop | 10 | 75000 | Delhi |
| 102 | 2025-03-12 | Smartphone | 60 | 30000 | Mumbai |
| 103 | 2025-04-01 | Tablet | 25 | 25000 | Bengaluru |
| 104 | 2025-03-20 | Headphones | 100 | 15000 | Delhi |
| 105 | 2025-02-28 | Smartwatch | 40 | 20000 | Chennai |
| 106 | 2025-03-25 | Laptop | 5 | 50000 | Mumbai |
| 107 | 2025-03-30 | Smartphone | 80 | 40000 | Delhi |
i. Write SQL query to Display the ProductName and Amount from the sales table
ii. Write SQL query to Display all sales done in the month of March.
iii. Write output of the following SQL query SELECT ProductName, Quantity, SaleDate FROM SALES WHERE MONTH(SaleDate) = 3 AND Quantity > 50;
Section D (2X4=8 Marks)
33. Mr. Sharma is working in a game development industry and he was the given chart on the basis of the rating of the various games available on the play store
He is trying to write a code to plot the graph. Help Mr. Sharma to fill in the blanks of the code and get the desired output.
import _________________ #Statement 1
Games=["Subway Surfer","Temple Run","Candy Crush","Bottle Shot","Runner Best"]
Rating=[4.2,4.8,5.0,3.8,4.1]
plt.____________(Games, Rating) #Statement 2
plt. xlabel("Games")
plt.__________("Rating") #Statement 3
plt._________ #Statement 4i. Choose the right code from the following for Statement 1.
a) matplotlib as plt
b) pyplot as plt
c) matplotlib.pyplot as plt
d) matplotlib.plt as pyplot
ii. Write the name of the function that should be used in statement 2 plot the above graph
iii. Choose the correct option for the Statement 3.
a) title(“Rating”)
b) ytitle(“Rating”)
c) ylabel(“Rating”)
d) yaxis(“Rating”)
iv. Fill in the blank in Statement 4 with function/method to save a graph
34. (A) Army hospital Pune maintains the following table for its patients. They want certain outputs department wise – like the average charges, total number of patients department wise etc. As a database programmer, helps them to get the required outputs.
Table: Hospital
| ptid | pname | Dept | charges |
|---|---|---|---|
| 101 | Amit Sharma | Cardiology | 15000 |
| 102 | Neha Kapoor | Orthopaedics | 12000 |
| 103 | Rajiv Mehta | Neurology | 18000 |
| 104 | Priya Verma | Paediatrics | 10000 |
| 105 | Aman Gupta | Cardiology | 14000 |
i. Display each Dept. and the total number of patients in each.
ii. Display the department wise average Charges.
iii. Display the total number of unique departments. IV. Show the Name and Dept of the hospitals, both in uppercase, sorted alphabetically by Name.
OR
Write output of the following SQL queries with reference to the
Table: GRADUATE
| SLNO | NAME | STIPEND | SUBJECT | AVERAGE | DIV |
|---|---|---|---|---|---|
| 1 | KARAN | 400 | PHYSICS | 68.47 | I |
| 2 | DIWAKAR | 450 | COMP. Sc. | 68.52 | I |
| 3 | DIVYA | 300 | CHEMISTRY | 62.12 | I |
| 4 | REKHA | 350 | PHYSICS | 63.75 | I |
| 5 | ARJUN | 500 | MATHS | 70.47 | I |
| 6 | SABNA | 400 | CHEMISTRY | 55.25 | II |
| 7 | VIKAS | 400 | MATHS | 57.94 | II |
i. Select MIN(AVERAGE) from GRADUATE where SUBJECT=”PHYSICS”;
ii. Select LEFT(NAME,3) from GRADUATE where STIPEND>395;
iii. Select NAME, SUBJECT, AVERAGE from GRADUATE where AVERAGE between 68 and 70;
iv. Select ROUND(AVERAGE,1) from GRADUATE where STIPEND > 480;
Section E (3X5=15 Marks)
35. MakeInIndia Corporation, an Uttarakhand based IT training company, is planning to set up training centres in various cities in next 2 years. Their first campus is coming up in Kashipur district. At Kashipur campus, they are planning to have 3 different blocks for App development, Web designing and Movie editing. Each block has number of computers, which are required to be connected in a network for communication, data and resource sharing. As a network consultant of this company, you have to suggest the best network related solutions for them for issues/problems raised in question keeping in mind the distances between various blocks/locations and other given parameters.
Distance between various blocks/locations:
| BLOCK | Distance |
|---|---|
| App Development to Web Designing | 28 m |
| App Development to Movie Editing | 55 m |
| Web Designing to Movie Editing | 32 m |
| Kashipur Campas to Mussoorie campus | 232 km |
Number of computers in each block:
| BLOCK | Number of Computers |
|---|---|
| App Development | 75 |
| Web Designing | 50 |
| Movie Editing | 80 |
i. Suggest the most appropriate block/location to house the SERVER in the Kashipur campus (out of the 3 blocks) to get the best and effective connectivity. Justify your answer.
ii. Suggest a device to be installed in each block of Kashipur Campus to connect computers.
iii. Suggest the best wired medium and draw the cable layout (Block to Block) to economically connect various blocks within the Kashipur Campus.
iv. Suggest the placement of Repeater with appropriate reason.
v. Suggest a protocol that shall be needed to provide Video Conferencing solution between Kashipur Campus and Mussoorie Campus.
Post Comment