GAYATRI PUBLIC SCHOOL

PRE-BOARD EXAM-II 2024-25

CLASS : XII
SUBJECT: INFORMATICS PRACTICES(065)
MARKING SCHEME
Time: 3 Hours Max. Marks: 70
Q No. Section-A Marks
1 False 1

(1 mark for correct answer)

2 (A) Filter rows based on a condition. 1

(1 mark for correct answer)

3. (C) - Convert digital signals to analog signals and vice versa. 1

(1 mark for correct answer)

4. (D) - SELECT * FROM customers WHERE email IS NULL; 1

(1 mark for correct answer)

5. (C) - Recycling or refurbishing electronic devices. 1

(1 mark for correct answer)

6. (A) - 1

KVs
0 KV1
1 KV2
2 KV3

( 1 mark for correct answer)

7. 1
(C) - import matplotlib.pyplot as plt

(1 Mark for correct answer)

8. 1
False
(1 Mark for correct answer)
9. 1
(B) - Comma (,)

(1 mark for correct answer)

10. 1
(C) – Copyright

(1 mark for correct answer)

11. 1
(A) - GROUP BY

(1 mark for correct answer)

12. 1
(B) - The entire network fails.

(1 mark for correct answer)

13 1
(B)- Ramesh
(1 mark for correct answer)

14. 1
(A) – Phishing
(1 mark for correct answer)

15. 1
(C) – Series

(1 mark for correct answer)

1
16. (C) P-2,Q-4, R-1, S-3

(1 mark for correct answer)

1
17. (D) - All of the above

(1 mark for correct answer)

18. 1
(C) - Line plot

(1 mark for correct answer)

19. 1
(A) - PAN

(1 mark for correct answer)

20. 1
(A) . Both Assertion (A) and Reason (R) are true, and Reason (R) is the correct
explanation of Assertion (A)

(1 mark for correct answer)

 21. 1
(D). Assertion (A) is False, but Reason (R) is True

(1 mark for correct answer)

Q No. Section-B (7 x 2 = 14 Marks) Marks

2
22. (A) Series DataFrame
One-dimensional data Two-dimensional data structured of
structured of pandas pandas
Series has a single column. DataFrame can store multiple
columns
Size Immutable Size Mutable

(1 mark for each correct difference as above or similar difference)

OR
(B) Library: A collection of modules providing functionalities for specific tasks.
NumPy :-Used for numerical operations.
Matplotlib: Used for data visualization/ Used for creating plots
(1 mark for correct definition)
(1/2 mark each for correct use of each library)

23. 2
FOSS (Free and Open Source Software) refers to software that is both freely
available and open source, meaning that anyone can use, modify, and distribute it.

Examples:- Linux, MySQL , Apache, GIMP

(1 mark for correct definition)

(1/2 mark for each correct open source software name)

24. I. SELECT LENGTH('Humpty Dumpty'); 2

II. SELECT UPPER('Humpty Dumpty');

(1 mark for each correct query)

25.(A)
A web browser is an application software use to fetches and displays content from 2
the internet in a user-friendly way. Web browser names :- Google Chrome,
Mozilla Firefox, Apple Safari, Microsoft Edge, Opera etc.

(1 mark for correct role)

(1/2 mark each for each correct web browser name above or any other web
browser name) )

OR

(B) A webpage is a digital document that is displayed on the internet using a web
browser. It can contain text, images, videos, links, and other multimedia
elements.
Difference:- In static web pages, pages will remain same until someone
changes it manually and information changes rarely.
Dynamic web page: In dynamic web pages, content of pages are different for
different visitors and information change frequently.
(1 mark for correct definition)
(1 mark for correct difference)

26. 2
Primary key :- It uniquely identifies records or rows in a table . There can only be
one primary key per table.
Candidate key:- all attribute present in a relation (table) that have unique values.
Table:- Student

Rollno Name Admno Phoneno

1201 Ajay 101 9876543210

1202 Riya 102 9123456789
1203 Ajay 103 9234567890

Primary Key:- Rollno can be selected as primary key

Candidate Key :- Rollno, Admno, and Phoneno are unique for each student,
making all three eligible to be candidate keys.

(1 mark for correct difference)

(1/2 for each correct example)
 27. 1. Recycle e-waste responsibly 2
2. Donate your old electronic devices to your friend

(1 mark for each correct advice)

Corrected code 2
28.(A)
import pandas as pd
Rollno= [1101, 1102,1103]
Name= ['Teena', 'Jay', 'Rishi']
Age=[26,27,35]
Final= [Rollno, Name, Age]
df= pd.DataFrame(Final, index= ['Stud1', 'Stud2', 'Stud3'])
print(df)

Changes Made :
i. Changed pantas to pandas.
ii. Corrected mismatched pdf to pd
iii. Corrected capital letter INDEX to index
iv. Correct print statement DataFrame to df

OR
import pandas as pd
Month_Day = pd.Series({'Jan': 31, 'Feb':28, 'Mar':31, 'Apr':30})
(B) print(Month_Day)
(1/2 mark for each correct fill in the blank)

Q No Section-C (4 x 3 = 12 Marks) Marks

29 3
(i) No, it is not safe for Bharti to upload her Aadhaar card, bank account
number, and OTP on the link provided in the message. This could be
part of a scam or phishing attempt to steal her personal and financial
information.
(1 mark for correct answer)
(ii) It is important for Bharti to immediately contact her bank to verify the
authenticity of the message because it could be a phishing attack
designed to steal her identity and financial details.
(1 mark for correct answer)
(iii) Phishing
(1 mark for each correct answer)
30. (A) import pandas as pd 3

Student = {'Name': ['aparna', 'pankaj', 'sudhir', 'Aditya'],

'English': [80, 78, 59, 76],
'Maths': [70, 18, 59, 66],
'Physics': [50, 48, 69, 96]}
df = pd.DataFrame(Student)
print(df)
(1 mark for correct import statement)
(1 mark for correct dictionary creation)
(1 mark for correct creation of DataFrame)
OR

import pandas as pd

(B) Sport = {'Virat Kohli': 'Cricket', 'Neeraj Chopra': 'Javelin Throw', 'Mary Kom':
'Boxing'}

My_Series = pd.Series(Sport)

print(My_Series)

(1 mark for correct import statement)

(1 mark for correct dictionary)

(1 mark for correct creation of Series)

31. 3
(I)
CREATE TABLE Employee
(
Emp_ID INTEGER PRIMARY KEY,
Emp_Name VARCHAR(20) NOT NULL,
Department VARCHAR(15),
Increment_Date DATE,
Salary INT(7)
);
(2 mark for correct creation of Table)

(II) INSERT INTO Employee VALUES (1001, 'Rajesh', 'Sales', '2024-12-10', 75000);

(1 Mark for correct insert Query)

 3
32.(A) a) SELECT source, COUNT(*) FROM Booking
GROUP BY source;
(b) UPDATE Booking
SET price = price+ (price * 0.10)
WHERE destination = 'DELHI';
(c) SELECT passenger, source, model, company
FROM Booking B, Flights F
WHERE B.Flightid = F.Flightid;

(1 mark for each correct query)

OR

(B) (I) SELECT StationaryName, AVG(Price) FROM Stationary

GROUP BY StationaryName;

(II) ALTER TABLE consumer CHANGE Consumer_Name Cons_name

VARCHAR(30);

(III) SELECT StationaryName, Consumer_Name

FROM Stationary S, Consumer C

WHERE S.S_ID = C.S_ID ;

or

SELECT StationaryName, Consumer_Name

FROM Stationary , Consumer

WHERE Stationary.S_ID = Consumer.S_ID ;

(1 mark for each correct query)

Section-D (2 x 4 = 8 Marks)
Q No. Marks

33 I. matplotlib.pyplot 4

II. Subject
III. xlabel
IV. SUBJECTWISE RESULT ANALYSIS
1 mark for each correct answer)
34. (A) 4
I. SELECT LOWER(Pname) FROM Sportsclub
WHERE Country = 'INDIA';
II. SELECT Sports, SUM(Salary) FROM Sportsclub
GROUP BY Sports HAVING SUM(Salary) > 15000;
III. SELECT DISTINCT (Sports) FROM Sportsclub;
IV. SELECT * FROM Sportsclub
WHERE Country = 'INDIA' AND Rating = 'A';

(1 mark for each correct answer)

OR
(I)
(B)
NAME LENGTH(NAME)

VIJAY SINGH 11

RAMESH KUMAR 12

(II)
NAME
RAKESH VERMA

(III)
NAME SALARY
RAKESH VERMA 60000
RAMESH KUMAR 72000

(IV)
SUBSTR(NAME, 2,4)
SHOK
AKES
AMES
1 mark for each correct output)

Section-E (3 x 5 = 15 Marks)
Q No. Marks

35 (I) The server should be installed in the Admin block as it has the most number 5
of computers and It will increase the efficiency of the network.
(1 mark for correct answer)
 (II) Cable layout

(III)

(1 mark for correct cable layout)

(III) (a) Repeater:- Between HR,logistics,Development and Admin block

because the distance is more than 100m.

(b) Switch/Hub:- in all the blocks since the computers need to be

connected to the network.

(1/2 mark for each correct answer)

(IV) Firewall
(1 mark for correct answer)

(V) Optical Fiber cable connection.

(1 mark for each correct answer)

36. (I) DF['Stream'] = ['Science', 'Commerce', 'Arts', 'Science'] # DF- DataFrame Name
5
(II) DF.loc[4] = [5, 'Rajesh', 'X', 'F', 9.8, 'Science']

Or

new_row = {'Rollno': 5, 'Name': 'Rajesh', 'Class': 'X', 'Section': 'F', 'CGPA':

9.8, 'Stream': 'Science'}

DF = DF.append(new_row, ignore_index=True)

(III) print(DF.shape)

(IV) DF=DF.drop([1])

(V) ravi_record = DF[DF['Name'] == 'Ravi']

print(ravi_record)
or print(DF.loc[2,:]) or any other suitable answer

(1 mark for each correct answer)

37.(A) 5
(I) SELECT SUBSTRING('EK BHARAT SHRESHTHA BHARAT', 3, 5);

(II) SELECT INSTR('INDIA IS THE GREATEST COUNTRY', 'GREATEST');

(III) SELECT ROUND(453.668, 2);

(IV) SELECT COUNT(*) FROM Employee;

(V) SELECT MIN(Salary) FROM Employee;

(1 mark for each correct query)

OR
(I) Monthname function is use to fetch the month name from the given date as in
argument
Argument type:- Date
Returen Type:- String
Example:-

(B) Select monthname(“2025-01-15”);

monthname(“2025-01-15”)
January

(II) Now() is use to fetch the current date and time.

Argument type:- empty
Returen Type:- Date and time
Example:- select now();

Now()
“2025-01-15 10:15:24”

(III) Trim() is use to remove leading and trailing spaces (if have) as well as
specified character.
Argument type:- String
Returen Type:- String
Example:- select trim(“ Ram”);

trim(“ Ram”)
Ram

(IV) Char()is use to fetch ASCII character.

Argument type:- int
Returen Type:- char
Example:- select char(65);

char(65)
A

(V) DayofYear() is use find the day no from the given date
Argument type:- Date
Returen Type:- int
Example:- select Dayofyear(“2025-01-15”);

Dayofyear(“2025-01-15”)
15