FIRST PRE-BOARD 2023-24

Class XII – Informatics Practices

Time allowed: 3 Hours Maximum Marks: 70
General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A has 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 02 questions carrying 04 marks each.
7. Section E has 03 questions carrying 05 marks each.
8. All programming questions are to be answered using Python Language only
SECTION A
1. The device which connects two networks using different protocols is: 1
i. Router
ii. Repeater
iii. Gateway
iv. Hub
2. How we manage E-waste? 1
i. Reduce
ii. Reuse
iii. Recycle
iv. All of Above
3. To load data of a CSV file in a dataframe ______ function is used. 1
i. read_csv()
ii. load_csv()
iii. input_csv()
iv. None of these
4. Which SQL statement is used to display all the data from product table in the decreasing 1
order of price?
i. SELECT * FROM PRODUCT;
ii. SELECT * FROM PRODUCT ORDER BY PRICE;
iii. SELECT * FROM PRODUCT ORDER BY PRICE DESC;
iv. SELECT * FROM PRODUCT WHERE PRICE ORDER BY DESC;
5. Which of the following is an example of Cyber Crime? 1
i. Stealing of Mouse
ii. Accessing someone’s e-mail without permission
iii. Both of the above
iv. None of these
6. Which of the following command will show last 2 rows from a Pandas Series named NP? 1
A. NP.Tail(2 )
B. NP.tail(2)
 C. NP.TAIL( )
D. All of the above
7. OSS stands for: 1
i. Output Scanner Software
ii. Outstanding Set Software
iii. Open Source Software
iv. Open Set Software
8. Consider the STOCK table. 1
Name Price Qty
Crayons 30.00 70
Graph Book 40.00 50
Pencil Set 80.00 40
Find the output of the following SQL query
SELECT PRICE*QTY FROM STOCK WHERE QTY < 50;
(a) 2000.00
(b) 3200.00
(c) 2100.00
(d) All of the above
9. Which among the following is a scalar function? 1
i. INSTR()
ii. MAX()
iii. COUNT()
iv. AVG()
10. Consider the below given series, named Batsman, which command will be used to print 6 as 1
output?
a WD Parnell
b David Warner
c RG Sharma
d KL Rahul
e Baber Azam
f Ross Taylor
dtype: object
a. Batsman .index
b. Batsman .length
c. Batsman .values
d. Batsman .size

11. When a DataFrame is created from List of Dictionaries, then dictionary keys will become 1
______
(i) Column labels
(ii) Row labels
(iii) Both of the above
 (iv) None of the above
12. Identify the SQL function which returns output as a group of characters. 1
(a) NOW()
(b) MONTH()
(c) MONTHNAME()
(d) WEEKNAME()
13. ………………… is unauthorized access to computer, computer network or any digital 1
system.
a) Scam
b) Phishing
c) Hacking
d) Digital footprint
14. Consider the following table Player: 1
Table: Player
id Pname Sname pay
1 Kabir Squash 15000
2 Rekha Karate 12000
3 Kanishk Squash 20000
4 Sarita Badminton 21000
5 Ravi Karate 25000

What will be the output after the execution of the given query?
SELECT COUNT (DISTINCT SNAME) FROM player ;
(a) 5
(b) 3
(c) 4
(d) 2
15. In SQL, the equivalent of MID() is: 1
i. MIDDLE ()
ii. MIDNAME()
iii. SUBSTR()
iv. MIDCASE()
16. IPR stands for: 1
i. Integrated Programming Resource
ii. Integrated Personal Record
iii. Information Processing Record
iv. Intellectual Property Right
Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct choice as a.
Both A and R are true and R is the correct explanation for A b. Both A and R are true and R is not the
correct explanation for A c. A is True but R is False d. A is false but R is True
17. Assertion (A): - Internet is a collection of interconnected networks linked by transmission 1
media.
 Reasoning (R):- World wide web is a collection of interconnected documents.
18. Assertion (A): - Antivirus should be installed in our compute system. 1
Reasoning (R):- It is used to detect and remove viruses and other kinds of malicious software
from your computer or laptop.
SECTION B
19. What are the differences between http and https. 2
or
What are cookies?
20. What will be the output of the following code: 2
import pandas as pd
a=pd.Series([50, 10, 30, 40])
print( a [ a>35 ] )
21. Create a Series monthdays in which name of the months are index and corresponding 2
number of days are data.
22. Rohini writes the following commands with respect to a table Student having fields, SNo, 2
Name, Age, Fee.
Command1: Select count (*) from student;
Command2: Select count (Fee) from student;
she gets the output as 5 for the first command but gets an output 4 for the second
command.
Explain the reason for different output with justification.
23. Carefully observe the following code: 2
import pandas as pd
D1={'A1': 'India', 'B1': 'Russia', 'C1': 'World'}
D2={'A1': 'EOIS', 'E1': 'Moscow'}
data={1:D1,2:D2}
df=pd.DataFrame(data)
print(df)

Answer the following

i. List the index of the DataFrame df
ii. List the column names of DataFrame d
24. Write the names of two DDL commands and two DML commands. 2
25. What is E-waste? List any two e-waste management techniques. 2
Or
List one positive impact and one negative impact of usage of technology.
SECTION C
26. Sports Authority of India (SAI) has recruited some players with the details given below in 3
table ‘sports’. Now, SAI wants to perform some queries on sports table that is already been
created in database. Therefore, Write mentioned five SQL queries to facilitate SAI:-
Table: sports
id pname Age Sname pay gender
 1 Kabir 35 Lawn Tennis 15000 M
2 Rekha 29 Karate 12000 F
3 Kanishk 34 Squash 20000 M
4 Sarita 29 Squash 21000 F
5 Ravi 24 Karate 25000 M

Query (1): Show the average age of those players whose name ends with ‘a’.
Query(2): ): Show the name and game of female players.
Query (3): Show name of players in decending order of pay.
27. Write a program to create the following DataFrame using dictionary: 3
Also give appropriate column headings as shown below:
Game Marks
Sameer Volleyball 45
Nitin Basketball 42
Naveen Kho-Kho 34
Vipul Cricket 44

28. Consider the DataFrame df with following values: 3

Hindi English Math
S1 82 74 89
S2 92 73 96
S3 69 75 92
S4 85 92 83
Write python statement for following:
i) Change the marks of student3 in Hindi as 90.
ii) Display the marks of all students English subject.
iii) Rename the “S1” as “Amit”.
29. Write MySQL statements for the following: 3
i. To create a database named School.
ii. To create a table named Student based on the following specification:
Column Bane Data Type Constraint
Enrollment Char(5) Primary Key
RNo Integer Greater than 0
Class Integer
Name Varchar(25) Not NULL
Address Varchar(50)
30. Anisha received an e-mail from her bank stating that there is a problem with her account. 3
The e-mail provides an instruction and a link, by clicking on which she can login her account
and fix the problem.
i. What is happening to Anisha?
ii. What immediate action should she take to handle it?
iii. Is there any law to handle such issues? Discuss briefly.
 SECTION D
31. Write SQL commands for the following queries (i) to (v) based on the relations Teacher 4
given below:
TABLE : TEACHER
T_I Name Ag Department Date_of_join Salar Gender
D e y
1 Jugal 34 Computer Sc 10-01-2017 1200 M
0
2 Sharmila 31 History 24-03-2008 2000 F
0
3 Sandeep 32 Mathematics 12-12-2016 3000 M
0
4 Sangeeta 35 History 01-07-2015 4000 F
0
5 Rakesh 42 Mathematics 05-09-2007 2500 M
0
6 Shyam 50 History 27-06-2008 3000 M
0
7 Shiv Om 44 Computer Sc 25-02-2017 2100 M
0
8 Shalakha 33 Mathematics 31-07-2018 2000 F
0

i. To show average salary paid to each department.

ii. To list the all Department whose average salary paid is over 20000.
iii. To list the names of all teachers with their date of joining in descending order.
iv. To display number of teachers of each gender.
32. Alankar, a Data Analyst with a multinational brand has designed the DataFrame df that 4
contains the four quarter’s sales data of different stores as shown below:
Store Qtr1 Qtr2 Qtr3 Qtr4
0 Store1 300 240 450 230
1 Store2 350 340 403 210
2 Store3 250 180 145 160
Answer the following questions:
i. Predict the output of the following python statement:
a. print(df.size)
b. print(df.loc[0:2, ‘Qtr2’:’Qtr4’])
ii. Delete the last row from the DataFrame.
iii. Write Python statement to add a new column Total_Sales which is the addition of all the
4 quarter sales.
OR (Option for part iii only)
Write Python statement to change Sales of Store2 for Qtr3 to 500.
 SECTION E
33. Write suitable SQL query for the following: 5
i. Display the remainder of 210 divided by 17.
ii. Display 3 characters extracted from 6th left character onwards from the string ‘G-20
Summit’.
iii. Display the last five characters from the string “G-20 and FLN”.
iv. Round off the value 19.987 to two decimal place.
v. Display the values of “City” column of “Games” table in uppercase.
34. Write Python code to plot following bar chart 5
Also give suitable python statement to save this chart.

35. The Great Brain Organization has set up its new branch at Srinagar for its office and web 5
based activities. It has 4 Wings of buildings as shown in diagram:

Wing Z Wing Y

Wing X Wing U

Center to center distance between various blocks:

Wing X to Wing Z 50 m
Wing Z to Wing Y 70 m
Wing Y to Wing X 125 m
Wing Y to Wing U 80 m
Wing X to Wing U 175 m
Wing Z to Wing U 90 m

Number of Computers
Wing X 50
Wing Z 30
Wing Y 150
Wing U 15

(i) Suggest a cable layout of connections between the wings.

(ii) Suggest the most suitable topology of connections between the wings.
(iii) Suggest the most suitable place(i.e. Wing) to house the server of this organization
with a suitable reason, with justification.
(iv) Suggest the placement of following devices with justification:
a) Repeater
b) Hub/Switch
(v) The organization is planning to link its head office situated in Delhi with the
offices at Srinagar. Suggest an economic way to connect it; the company is ready
to compromise on the speed of connectivity. Justify your answer.