Subject Code 0 6 5 Roll No.

KENDRIYA VIDYALAYA SANGATHAN, MUMBAI REGION

PRE-BOARD I EXAMINATION
SESSION 2025-26
Subject: Informatics Practices Class: XII
Time Allowed: 3:00 Hours Max. 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.
Q NO SECTION-A (21X1=21 Marks) Marks

1. State whether the following statement is True or False: 1

The [Link] 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: 1
(A) 16 (B) 15.6 (C) 15 (D) 15.67
3. Riya created a fake profile to harass her friend online. Identify the cybercrime. 1
(A) Hacking (B) Cyber Bullying (C) Phishing (D) Plagiarism
4. The correct function to read data from a CSV file into Pandas is: 1
(A) pd.load_csv() (B) pd.read_csv()
(C) pd.import_csv() (D) pd.open_csv()
5. Which device regenerates signals in a network? 1
(A) Switch (B) Repeater (C) Hub (D) Modem
6. What will be the output of the following SQL query? 1
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 1
Property right protects it?
(A) Patent (B) Copyright (C) Trademark (D) Industrial Design
8. Default axis for drop() method in Pandas is: 1
(A) 0 (B) 1 (C) None (D) 2

Page 1 of 8
 9. A table named Employees has one primary key and two alternate keys. How many 1
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? 1
(A) FTP (B) VoIP (C) SMS (D) Video Call
11. What will be the output of the following SQL 1
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 1
having index as points, from a Pandas Series named ser ?
(A) [Link](points) (B) [Link](points)
(C) ser[points] (D) [Link](points)
13. Which of the following is NOT a cybercrime? 1
(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? 1
(A) DISTINCT (B) UNIQUE (C) ONLY (D) CLEAN
15. A DataFrame column can be accessed using: 1
(A) [Link] (B) df['columnname']
(C) df(columnname) (D) Both A and B
16. Which topology uses a single backbone cable to connect all computers? 1
(A) Star (B) Bus (C) Mesh (D) Ring
17. Which SQL function calculates ab ? 1
(A) MOD() (B) POWER() (C) RAISE() (D) ROUND()
18. Which of the following libraries defines an ndarray in Python ? 1
(A) pandas (B) numpy (C) matplotlib (D) scipy
19. Which of the following is an aggregate function? 1
(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, 1
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 1
position and length.
Reason (R): The starting position in SUBSTR() begins from 0 in SQL.
Q. NO SECTION B (7x2=14 Marks) Marks
22. (A) What is the difference between [Link]() and [Link]() in Pandas? 2
OR
(B) What is the difference between a 1-dimensional and a 2-dimensional data
structure in Pandas? Give examples.

Page 2 of 8
 23. Define cyber safety. Mention two precautions to stay safe while using social media. 2
24. Amit wants to create a Pandas Series as shown below: 2
Fruit Quantity
Apple 50
Mango 30
Orange 40
Help him complete the code
below: import as pd
fruit_data =
s = pd. (fruit_data)
print(s)

25. (A) Briefly explain the difference between a webpage and website. 2
OR
(B) 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'. 2
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 2
collected automatically by websites.
(a) Identify the type of digital footprint each one is leaving.
(b) Justify your answer.
28. (A) Write the output of the following code: 2
import pandas as pd
df1 = [Link]({'Juice' : ['Mango', 'Orange', 'Apple'], 'Snacks' : ['Chips',
'Namkeen', 'Biscuits']})
df2 = [Link]({'ColdDrink' : ['Pepsi', 'Coke'],'Juice' : ['Mango', 'Orange'],
'Snacks' : ['Chips', 'Namkeen']})
print(df2.reindex_like(df1))
OR
(B) import pandas as pd
df = [Link]({ 'Fruits' : ['Apple', 'Banana', 'Mango'], 'Rate' : [120, 60,
90]})
df2 = df. rename (columns = {'Rate':' Price', 'Fruits': 'Fruit_Name'})
print(df2)
Q. NO Section-C (4X3=12 Marks)
29. Identify the type of cybercrime for the following situations: 3
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. (A) Mr. Krishnamurthy, who is a new user of Python Pandas, has created the 3
following Series "Electrical" as shown below using ndarray, where watts are the
Page 3 of 8
 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
(B) 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: 2+1
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. 3
Table 1: AUTHORS
AuthorID Name Country
1 J.K. Rowling UK
2 Chetan Bhagat India
3 George Orwell UK

Table 2: BOOKS
BookID AuthorID Title Price
101 1 Harry Potter 500
102 2 Two States 300
103 1 Fantastic Beasts 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
Page 4 of 8
 (B) SunTech Electronics maintains a table SALES to track product sales.

SaleID SaleDate ProductName Quantity Amount Customer

City
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;
Q. NO Section- D(2X4=8 Marks) Marks
33. Mr. Sharma is working in a game development industry and he was the given chart on 4
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 4

Page 5 of 8
 I. Choose the right code from the following for Statement 1.
(a) matplotlib as plt
(b) pyplot as plt
(c) [Link] as plt
(d) [Link] 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 4
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
I. Display105 Amanand
each Dept. Gupta Cardiology
the total 14000 in each.
number of patients
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
(B)
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 SABINA 400 CEHMISTRY 55.25 II
I. 7 Select MIN(AVERAGE)
VIKAS 400from GRADUATE
MATHS 57.94 II
where SUBJECT=”PHYSICS”;
II. Select LEFT(NAME,3) from GRADUATE where STIPEND>395;
III. Select NAME, SUBJECT, AVERAGE from GRADUATE

Page 6 of 8
 where AVERAGE between 68 and 70;
IV. Select ROUND(AVERAGE,1) from GRADUATE where STIPEND > 480;
Q. NO Section- E(3X5=15 Marks) Marks
35. MakeInIndia Corporation, an Uttarakhand based IT training company, is planning to set 5
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 28m
App Development to Movie Editing 55m
Web Designing to Movie Editing 32m
Kashipur Campas to Mussoorie campus 232km
Number of computers in each block:

BLOCK Number of Computers

App Development 75
Web Designing 50
Movie Editing 80
a. 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.
b. Suggest a device to be installed in each block of Kashipur Campus to
connect computers.
c. Suggest the best wired medium and draw the cable layout (Block to Block)
to economically connect various blocks within the Kashipur Campus.
d. Suggest the placement of Repeater with appropriate reason.
e. Suggest a protocol that shall be needed to provide Video
Conferencing solution between Kashipur Campus and Mussoorie
Campus.

Page 7 of 8
36. Given DataFrame df: 5
Name Age Marks
0 Amit 17 85
1 Neha 18 92
2 Rohit 16 78
Write Python statements for the following task :

I. Print the last two rows of the DataFrame df

II. Column new column ‘Grade’ = [‘A’,‘A+’,‘B’].
III. Display students having Marks > 80.
IV. Rename column ‘Marks’ to ‘Score’.
V. Show the shape of DataFrame.
37. (A) Write suitable SQL queries for the following: 5
I. To display the total quantity of items from the quantity column in the
inventory table.
II. To display the first four characters of the model number column
(attribute) in the products table. (Note: The model numbers are stored
in the format AB-1234).
III. To display the data from the description column (attribute) in the
furniture table, after removing any leading and trailing spaces.
IV. To display the minimum price in the price column (attribute) of the
furniture table.
V. To determine the count of distinct categories in the categories
column (attribute) of the furniture table.
(B) OR
Write suitable SQL Queries (using SQL Functions) for the following
I. Write an SQL query to extract the first three characters from the
emp_name column in the Employees table.
II. Write an SQL query to display the total salary from the salary column in
the Payroll table.
III. Write an SQL query to display the month name from the
joining_date column in the Employees table.
IV. Write an SQL query to display the city column from the Customers
table after converting it to uppercase.
V. Write an SQL query to display the highest marks from the marks column in
the Students table.

Page 8 of 8