KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION

FIRST PREBOARD EXAMINATION 2023-24

CLASSXII
INFORMATICS PRACTICES(065)
TIME:3 HOURS M.M.70

General Instructions:
1. This question paper contains five sections, Section A to E.
2. All questions are compulsory.
3. Section A have 18 questions carrying 01 mark each.
4. Section B has 07 Very Short Answer type questions carrying02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has03 Long Answer type questions carrying 05marks each.
7. Section E has02 questions carrying 04 marks each. One internal choice is given in Q 34
and 35 against part c only.
8. All programming questions are to be answered using Python Language only.
9. 3333333333

PARTA
1. It is a world-wide network which is a collection of many other networks 1
a) Internet
b) Website
c) Web Page
d) LAN
2. It is an act of copying another person’s data idea, words or work and pretended that they 1
are our own.
a) Copyright
b) Virus
c) Plagiarism
d) IPR
3. Choose the method(s) used for managing e-Waste. 1
a) Reducingb) Reusingc) Recycling d) All of these
4. Which type of values will not be considered by SQL while executing the following 1
statement?
SELECT COUNT(column name) FROM STOCK;
a) Null value
b) Text value
c) Numeric value
d) Date value
5. In a table SHOP, column “Margin” contains the data 1
set(2.00,2.00,NULL,4.00,NULL,3.00,3.00).What will be the output after the execution of the
query given below?
SELECT AVG(Margin) FROM SHOP;
a) 2.9 b) 2.8 c)2.00 d) None of these
6. ‘P’ in IPR stands for 1
a) Proprietary
b) Platform
c) Patent
d) Property
7. Which of the following is not a category of MySQL functions? 1
a) Text Functions
b) Mathematical Functions
c) Aggregate Functions
d) Arithmetic Functions
8. Select the output of the following SQL Command : - 1
SELECT ROUND(568.45,-1)
a) 570
b) 550
c) 568
d) 600
9. Which of the following function is similar to LCASE () function? 1
a) Lowercase()
b) Lower()
c) Lower_case()
d) All of the these
10 To display Third Element of a Series object S,you will write : 1
. a) S[:3]
b) S[2]
c) S[3]
d) S[:2]
11 Choose statement from the statements given below which is not correct in the context of a 1
. DataFrame?
a) size is Mutable
b) Can perform Arithmetic operators on rows and columns.
c) Homogeneous tabular data structure
d) Two dimensional
12 Which attribute is not used with the Dataframe? 1
. a) size
b) column
c) empty
d) type
13 A computer program designed to simulate conversation with human users especially is 1
. known as
a) e-mail
b) Chat group
c) Whatsapp
d) Chat bot
14 Suppose you have a DATETIME “2023-11-10 12:50:10” value. Which function extracts the 1
. date part of the given DATETIME value.
a) CURRENT()
b) NOW()
c) SYSDATE()
d) DATE()
15 What is the name of the IT law that India is having in the Indian Legislature? 1
. a) India’s Technology(IT) Act,2000
b) India’s Digital Information Technology(DIT),Act,2000
c) India’s Information Technology(IT),Act ,2000
d) The Technology Act,2008
16 Which of the following are automatically granted to creators and authors? 1
. a) Copyright
b) Patent
c) Trademark
d) Netiquette
Q17and18areASSERTIONANDREASONING basedquestions. Mark thecorrect choiceas
i. BothAand Raretrue andRisthecorrectexplanationforA
ii. BothAand Raretrueand Ris not the correctexplanation forA
iii. Ais Truebut Ris False
iv. Ais false butR is True
17 ASSERTION (A):E-waste can be toxic and harmful for nature 1
. REASONING(R):E-Waste that do not organically break down can, over time, can seep
directly into the environment
18 ASSERTION(A):drop() function removes data from a Dataframe temporarily. 1
. REASONING(R): Axis parameter is compulsory with drop() function.
PARTB
19 What do you understand by a website? Mention any two points of difference between 2
aWebsite and Webpage?
OR
“Switch is an intelligent Hub”. State Yes or No with reason.
20 Gopi Krishna is using a table Employee which has columns - 2
Code,Name,Salary,Deptcode. He wants to display maximum salary department wise but
he did not get the desired result. Rewrite the query given below with necessary change to
help him get the desired result.
SELECT Deptcode,MAX(Salary) FROM Employee;
21 In SQL, differentiate HAVING and WHERE clause? 2
.
22 Consider the given data and write a python program to create a series named Subject 2
. using a dictionary.
English 75
Hindi 78
Math 82
Science 88

23 Explain any two physical problems of using technology excessively. 2

. OR
What is meant by digital footprint? Give example of one active and one passive digital
footprint?

24 What will be the output of the following code: 2

.
import pandas as pd
numbers=pd.Series([9,8,7,6,5],index=range(0,10,2))
print(numbers[1:3]

25 Answer the following questions based on the code given below : - 2

. …………………….... # Statement 1
Ld=[{'a',10,'b':20},{'a':5,'b':10,'c':20}]
df=pd.DataFrame(Ld)
print(df)
i) Write the statement 1 in the above code.
ii) How many columns will be there in the dataframe.
 SECTION C
26 Write a python code to create a DataFrame with appropriate column headings from the list 3
. given below:
[[201,’Gurmeet’,95],[202,’Praveen’,89],[203,’Suman’,97],[204.’Yogesh’,91]]

27 Consider the given DataFrame ‘Fees’: 3

.
Cname Fee
0 XII 3500
1 XI 3000
2 X 2700
3 VII 1800

Write suitable Python statements for the following:

i. Add a column called ‘Section’ with the data: [‘A’,’B’,’C’,’D’]
ii. Add a new Class Name named ‘IX' having price 1800.
iii. Remove the column ‘Section’.
28 Write SQL commands for the statements (i) to (iii) which are based on the given table 3
. WORKER.
PI GE PINCO SALA
SNAME FNAME CITY
D N DE RY
SHARM
1 GEET F JAMMU 182141 50000
A
SURINDE
2 SINGH M KANPUR 193222 75000
R
3 JCOB PETER M MUMBAI 185155 45000
4 ALVIS THOMAS M GURUGRAM 380025 50000
MOHA
5 GAURAV M KOLKATA 390026 33000
N
6 AZMI SIMI F NEW DELHI 110021 40000
MANPRE
7 KAUR F JAMMU 182141 42000
ET

i) SELECT SUM(SALARY) FROM PERSON WHERE GEN=’F’;

ii) SELECT GEN,COUNT(*) FROM PERSON GROUP BY GEN;
iii) SELECT MOD(SALARY,4000) FROM PERSON WHERE CITY=‘JAMMU’;

29 NISHA has recently changed his school so she is not aware of the people, but someone is 3
posting negative demeaning comments on his social media profile. She is also getting
repeated mails from unknown people. Every time she goes online, she finds someone
chasing him online.
i. Nisha is a victim of ___________.
ii. The action that Nisha should take to handle it.
iii. .......................... is a set of moral principles that governs the behavior of a group or
individual and regulates the use of computers.
OR
What do you understand by plagiarism? Why is it a punishable offence? Mention any two
ways to avoid plagiarism.
 30 Consider a table “AGENT”” with the following data: 3
Table : AGENT
SNO ANAME SALAR BONU DOJ
Y S
A01 Beena Mehta 30000 45.23 29-10-2019
A02 K.L. Sahay 50000 25.34 13-03-2018
B03 Nisha Thakkar 30000 35.00 18-03-2017
B04 Leela Yadav 80000 NULL 31-12-2018
C05 Gautam Gola 20000 NULL 23-01-1989
Write SQL queries to
perform the following operations.
(i) Display Agent name and bonus after rounding off to zero decimal places.
(ii) Display the month name of the date of join (DOJ) of all the agents who have no bonus.
bonus
(iii) Display the
e minimum salary of all the agents
agents.
OR
What is the purpose of GROUP BY clause in MySQL? How is it different from ORDER BY
clause?
SECTION D
31 Write suitable SQL query for the following: 5
. i. Display 7 characters extracted from 7 th characterharacter onwards from the string
‘INDIASHINING’.
ii. Display the position of occurrence of string ‘COME’ in the string‘WELCOME WORLD’.
iii. Round off the value 78.779 to 2nd decimal place.
iv. Display the remainder of 1 149 divided by 6.
v. Remove all the expected leading and trailing spaces from a column USERID of the table
‘USERS’.
OR
Explain the following SQL functions using suitable examples.
i. LENGTH()
ii.RTRIM()
iii. NOW()
iv. DAYNAME()
v. POWER()
v. POWER(
32 VIKRAMA UNIVERSITY, Allahabad is setting up the network between its different wings. 5
. There are four wings named as Science(S), Journalism(J), Arts(A) and Home Science(H).

Distance between various wings

a. Suggest a suitable layout for networking the computers in each wing.

 b. Name the wing where server needs to be installed.
c. Suggest the placement of Hub/Switch in the network.
d. Suggest type of wired media to provide internet accessibility to all wings.
e. University is planning to get its website designed which will allow students to see their
results after registering themselves on its server. Out of the static or dynamic, which type of
website will you suggest?

33 Mr. Gupta is working in a game development industry and he was comparing the given chart 5
on the basis of the rating of the
various games available on
the play store.

Write the python code for the above graph and Also give suitable python statement to save
this chart.
OR
Write a python program to plot a line chart based on the given data to depict the pass
percentage of students in CBSE exams for the years 2018 to 2022 as shown below.

Year=[2018,2019,2020,2021,2022]
Pass_Percentage=[85,83,90,82,92]

SECTION E
34 Naveen, a database administrator has designed a database for a Computer Stock. Help him 1+
by writing answers of the following questions based on the given table: 1+
2
TABLE: INVENTORY

Pid Pname Categor Qty Price

y
1 Keyboard IQ 15 450
2 Mouse IQ 10 350
3 Wi-fi router NW 5 2600
4 Switch NW 3 3000
5 Printer O 4 17000

i. Write a query to display product name in upper case.

ii. To display the records in descending order of the price.
iii. To display category and category wise highest price of product.
OR (Option for part iii only)
 To display category and category wise total quantities of product.

35 Assume a DataFrame df has following data of passengers for the year 2010 to 2012 for
. January, March and December. Find output of the following python statements given 1+
below: - 1+
2
Year Mont Passengers
h
0 2010 Jan 25
1 2010 Mar 50
2 2012 Jan 35
3 2010 Dec 55
4 2012 Dec 65

i. df.columns
ii. df.shape
iii. df[df.Passengers>50]
OR (Option for part iii only)
df.tail(3)