KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION

PRE-BOARD II
CLASS XII (SESSION: 2022-23)
SUBJECT: INFORMATICS PRACTICES (065)
Time: 3 Hrs. Max. 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 marks each.
4. Section B has 07 Very Short Answer type questions carrying 02 marks each. Internal choice
is given in two questions (19 and 23).
5. Section C has 05 Short Answer type questions carrying 03 marks each. Internal choice is
given in two questions (29 and 30).
6. Section D has 03 Long Answer type questions carrying 05 marks each. Internal choice is
given in two questions (31 and 33).
7. Section E has 02 questions carrying 04 marks each.
8. One internal choice is given in Q34 and Q35 against part C only.
Q. N. Question Marks
Section - A
A _______ is usually privately owned and links the devices in a single office,
building, or campus.
01 1
a. WAN b. MAN
c. LAN d. None of These
At lunch break Mukeshinstall a keylogger software in colleague computer
which collect the information and send to Mukesh personal email. Which
02 illegal activity Mukesh is doing. 1
a. Identity Theft b. Cyber Bullying
c. Spying d. None of these
How does excessive use of technology affect physical health?
03 a. Internet Addiction b. Social Isolation 1
c. Anxiety & Depression d. A & C
Which of the following is not a math function?
04 a. LTRIM() b. RIGHT() 1
c. DAYNAME() d. All the above
If a column DOJ contains the data-set(‘2022-12-23’, ‘2021-11-15’, ‘2019-11-
17’), what will be the output after execution of the following query:
SELECT MAX(DOJ) FROM EMP;
05 1
a. 2022-12-23 b. 2019-11-17
c. Can’t be predicted d. Error as max function does not
support date values
Which one of the following operating systems comes under FOSS?
06 a. Ubuntu b. Unix 1
c. Mac d. Windows
SQL applies conditions on the groups through __________ clause?
07 a. GROUP BY b. ORDER BY 1
c. WHERE d. HAVING
 Which of the following MySQL functions removes spaces on the right side of
a given string?
08 1
a. RTRIM() b. RREMOVE()
c. RSTRIP() d. None of these
What will be the output of the following SQL query?
SELECT LEFT('I LOVE KVS', 8);
09 1
a. ILOVEKVS b. I LOVE K
c. Can’t be predicted d. Error
Minimum number of arguments required to pass in pandas Series function to
create a Series?
10 1
a. 1 b. 2
c. 0 d. 3
Which one of the following commands is used to install the PANDAS module
in the system?
11 1
a. pip install pandas b. install pandas
c. pip pandas d. None of the above
To select a single column col1 from the Dataframe df, which of the following
is correct?
12 1
a. df.select('col1') b. df.loc[:, 'col1']
c. df['col1'] d. both B&C
A web browser is ____________________________.
a. A computer that stores www b. A person who likes to look at
13 files websites 1
c. A software program that allows d. A computer program to edit
to access sites on WWW word files.
Which MySQL function returns the week day name corresponding to Date
value supplied as argument.
14 1
a. WEEKDAY() b. DAYNAME()
c. DAYOFWEEK() d. WEEKOFDAY()
The symbol © signifies?
15 a. Patent b. Copyright 1
c. Trademark d. Copyleft
Read following statements:
(i). Digital footprint is nothing but the record of what a person does online.
(ii). Patents are automatically granted to creators and authors.
16 1
Which of the following is correct?
a. (i) True, (ii) False b. (i) False, (ii) True
c. Both are True d. Both are False
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
1
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.
Assertion (A): A cookie is a binary file, stores UserId and Password to autofill
17 the same on various websites. 1
Reasoning(R): The web browser on our computer store and manage cookies.
 Assertion (A): Professionals and developers are using the Pandas library in
data science and machine learning.
18 1
Reason(R): Pandas is an open-source Python library which offers high
performance, easy-to-use data structures and data analysis tools
Section - B
Define Web hosting with example.
19 OR 2
Explain resource sharing through a computer network with example.
Suhani is learning MySQL in her school. Her teacher taught her various SQL
functions. She tried to experiment with a few. She thought of finding the
name of the week day on the date when she was born. She wrote the
following query but she is getting errors in it.
20 2
SELECT DAY('1997-12-23')
WHERE DOB = '1997-12-23';
Help her in identifying the reason for the error and write the correct query
by suggesting the possible correction.
Which clause is used to arrange a query result in ascending or descending
21 order? Write a query, which displays all the records of a table ‘Employee’ in 2
descending order of the Salary.
Write a program to create a Series “s” using ndArray filled with “n” no. of
22 2
zeroes. The value of “n” should be entered by the user.
List any four health concerns related to excessive usage of technology.
23 OR 2
List any four measures to ensure Good Health of a Computer System.
What will be the output of the following code?
import pandas as pd
24 2
df = pd.Series(12, index = [4, 6 , 8])
print(df)
Carefully observe the following code:
import pandas as pd
data = {'col1':pd.Series([11, 12, 13, 14, 15, 16, 17, 18, 19]),
'col2':pd.Series([21, 22, 23, 24, 25, 26, 27, 28, 29])}
df = pd.DataFrame(data)
25 print(df) 2
Answer the following based on above code:
a. Print all rows except first five of the DataFrame df using negative value
with tail() function
b. Print values of the DataFrame df where all the values are double of their
original value
Section - C
Write outputs for SQL queries based on the table Student given below:
SNO ENAME DOB Fees
26 1 AARADHYA 2004-07-01 6000 3
2 KAVYA 2005-01-10 3500
3 NAMAN 2000-08-15 4000
4 LAKSHITA 2007-05-10 3500
 a. SELECT MAX(MONTH(DOB)) FROM Student;
b. SELECT ENAME FROM Student WHERE YEAR(DOB) = 2000;
c. SELECT LOWER(ENAME) FROM Student WHERE SNO IN(2,4);
Write a Python code to create the DataFrame with appropriate column
27 headings for the list given below: 3
[[3, 43, 56], [45, -34, 13], [18, 10, 6]]

Kumari Anamika, a student of class XII (IP) has designed a DataFrame df as

shown below. Consider this DataFrame and answer the below questions.
Name City Sales Expense

1 Vikram Kumar Churu 50000 42000

2 Hari Narayan Kota 52000 NaN

28 3 Sandeep Singh Jaipur 90000 50000 3

4 Nirmala Bikaner 34000 44000

5 Anjum Shaikh Nagaur 42000 38000

a. Print Sales and Expense of Nirmala and Vikram Kumar.
b. Rename Row Label Index as shown below
['E01', 'E02', 'E03', 'E04', 'E05']
c. Remove City column
Afirm offers SSO id-password to the employee to login in all their internal
applications and Windows. The firm has registered URL as
https://abccorp.com. One day, the following email was mass distributed to
all the employees. The email claimed that the password of their employee id
is about to expire in 24 hours. Instructions were given to go to the URL to
renew their password within 24 hours.

Email content is as follows:

-----------------------------------
Subject: Your Password will Expire in 24 hours!
Dear Employee,

This mail is meant to inform you that your password will expire in 24 hours.
29 Please follow the link below to update your password. 3
http://abcccorp.com/updatepass

Thank you
Network Security Staff
—---------------------------------
a. Do you find any discrepancy in this email?
b. Is the email an example of cybercrime? If yes, then specify which type of
cybercrime is it?
c. Is there any law in India to handle such an issue? Discuss briefly.
OR
What do you understand by Cyber bullying? Why is it a punishable offense?
Mention any two ways to avoid Cyber bullying.
 Based on the Club table given below, write SQL queries for the followings:
CID CName Age Gender Game DOJ Fee
1 KUKREJA 35 M KARATE 2018-06-15 1000
2 RAVINA 34 F KARATE 2020-01-26 1200
3 KARAN 34 M SQUASH 2022-10-25 2000
4 TARUN 33 M BASKETBALL 2015-03-06 1500
30 5 ZUBIN 36 M SWIMMING 2017-11-11 750 3
a. Display the total members in each game.
b. Display average age.
c. Display total fee paid by each gender.
OR
Explain the difference between Group By and Order By clauses with the help
of suitable examples in each case.
Section - D
Write SQL query for the following:
a. Find the value of 16 raised to the power 6.
b. Extract a few characters from the string 'KVS Sangathan’ such that the
result is ’athan’.
c. Display month name of the Date value ‘2023-01-15’.
d. Extract year from the date-time value ‘2022-12-31 23:25:59’.
e. Display number of Characters in String ‘I Love KVS’.
31 5
OR
Explain the following SQL functions with an example in each case.
a. ROUND()
b. LEFT()
c. DATE()
d. DAYNAME()
e. RTRIM()
Indian School, in Mumbai is starting up the network between its different
wings. There are four buildings named as Senior, Junior, Admin and Hostel as
per the below specifications:
Building to Building Distance:
Admin to Senior 200m
Admin to Junior 150m
Admin to Hostel 50m
Senior to Junior 250m
Senior to Hostel 350m
Junior to Hostel 350m
32 5
Number of Computers:
Senior 130
Junior 80
Admin 160
Hostel 50
a. Suggest the cable layout of connections between the buildings.
b. Suggest the most suitable place (i.e., building) to house the Server of this
school with a suitable reason.
c. Suggest the placement of the following devices with justification.
 Repeater
  Hub/Switch
d. The school also has an inquiry office in another city about 50-60 km
away in hilly region. Suggest the suitable transmission media to
interconnect to school and inquiry office out of the following:
Fibre Optical Cable, Microwave & Radio wave.
e. Which Zone should be selected for the placement of the firewall and
why?

Write down the python code to draw the bar chart using the diagram given
below. Consider the below avg. marks scored by boys and girls in five
subjects.
Score Boys = [94, 85, 45, 25, 50]
Score Girls = [84, 25, 65, 92, 85]

33 5

OR
Write a python program to plot a line chart based on the given data todepict
the changing weekly average temperature in Delhi for four weeks with
proper title, x-axis label, y-axis label. Also, save the figure in png format.
Week=[1,2,3,4]
Avg. Week Temp (in Celsius)=[40,42,38,44]

Section - E
Sunita is learning MySQL, she created a table Product to store the details of
various Products.
PCode PName Size Colour Price
111 Tshirt XL Red 1400
34 112 Jeans L Blue 1600 4
113 Skirt M Black 1100
114 Jacket XL Blue 4000
115 Trousers L Brown 1500
116 Ladies Top L Pink 1200
 Help Sunita to write the following queries:
a. Display the last 3 characters of ‘Colour’ for all records.
b. Find the minimum and maximum ‘Price’ from the Product table.
c. How many products are available in ‘Blue’ colour?
OR
Find an average ‘Price’ for each size.
ABC Enterprises is selling its products through five salesmen (S1 to S5) and
keeping the records of sales done quarterly of each salesman as shown
below. One of the employees created a DataFrame df_sales of the data for
further analysis. Consider the DataFrame df_sales and answer the following.

Q1 Q2 Q3 Q4

S1 11500 20000 18000 26000

S2 19000 23000 25000 27000

S3 23000 12000 20000 22000

35 4
S4 24000 23000 21000 25000

S5 13000 18000 20000 9000

a. Predict the output for below
i. print(df_sales.columns)
ii. print(df_sales.count(1))
b. Display sales of Quarter 3 for salesman 2 and 5.
OR
Display the difference between Quarter 1 and Quarter 2 and also Quarter
3 and Quarter 4.