KENDRIYA VIDYALAYA SANGATHAN, GURUGRAM REGION

PRE BOARD-II EXAMINATIONS -2024-25 (Winter Station)

Class: XII Max. Marks: 70

Subject: Informatics Practices (065) Time: 03 Hrs.
General Instructions:
● Please check this question paper contains 37 questions.
● All questions are compulsory. However, internal choices have been provided in
somequestions. Attempt only one of the choices in such questions
● The paper is divided into 5 Sections- A, B, C, D and 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 case study type questions (33 to 34). Each question carries 4 Marks.
● Section E consists of 3 questions (35 to 37). Each question carries 5 Marks.
● All programming questions are to be answered using Python Language only.
● In case of MCQ, text of the correct answer should also be written.
SECTION - A
1 State whether the following statement is True or False: 1
NumPy, Pandas and Matplotlib are three well-established Pythonlibraries
for scientific and analytical use.
2 The purpose of LEFT()in a SQL statement is to: 1
(a) Returns 5 number of charactersfrom the left side of the string.
(b) Returns N number of charactersfrom the left side of the string.
(c) Returns only alphabets from the left side of the string.
(d) Display N-1 number of characters from the left side of the string.
3 There are numerous websites, which provide search facility for searching 1
the contents on ……
a) Internet b) Website c)Web Page d) LAN
4 Identify the SQL command used to delete a row (tuple) from a relation 1
(table)
a) DROP ROW b) REMOVE FROM c)DELETE FROM d)ERASE ROW
5 It is an act of copying another person’s data idea, words or work and 1
pretended that they are our own.
a) Copyright b) Virus c) Plagiarism d) IP
6 Which of the following is a 2-dimensional array containing a sequence of 1
Page 1 of 8(2nd PB-XII-IP-2024)
 values in Python?
(a) Relation (b) DataFrame(c) Series(d) Square
7 Which function Plot a histogram? 1
a)hist()b) histogram() c)h_gram() d) None of the above
8 State whether the following statement is True or False: 1
In SQL, the HAVING clause is used to apply filter on groups formed by the
GROUP BY clause.
9 Which of the following Python statements is used to import data from a 1
Pandas DataFrame into a CSV file (Note: pd is an alias for pandas)?
(a) pd.open_csv('filename.csv')
(b) pd.read_csv('filename.csv')
(c) pd.load_csv('filename.csv')
(d) pd.to_csv ('filename.csv')
1 Which of the following are automatically granted to creators and 1
0 authors?
a) Copyright b) Patent c) Trademark d) Netiquette
1 Which of the following function is the correct syntax of LCASE() function? 1
1
a) LCASE(row_name) b) LCE(column_name)
c)LCASE(string/column_name) d) None of the above
1 A ……………………..is a networkthat is limited to a relativelysmall area. It is 1
2 generally limited to a geographic area such as a school building, office or
a university campus.
a) LANb) MANc) WANd) None of the above
1 In a Pandas DataFrame, if the head() function is used without specifying 1
3 the optional argument indicating the number of rows to display, what is
the default number of rows displayed, considering the DataFrame has 10
entries?
(a) 0(b) 1(c) 4(d) 5
1 ‘P’ in IPR stands for 1
4
a) Proprietary b) Platform c) Patent d) Property

Page 2 of 8(2nd PB-XII-IP-2024)

1 To display Third Element of a Series object S, you will write : 1
5
a) S[:3] b) S[2] c) S[3] d) S[:2]
1 Which of the following function find the position of a substring in a 1
6 string?
a) MAX() b) SUBSTRING() c) INSTR() d) LCASE()
1 Which command will add a New Column to a DataFrame? 1
7
a) ResultDF['Preeti']=[89,78,76] b) ResultDF['Preeti'=89,78,76]
c)ResultDF.'Preeti'=[89,78,76] d) None of the above
1 In Matplotlib, …………………is used to display the figures (plots, charts, 1
8 etc.) that you've created.import matplotlib.pyplot as plt
a) plt.dis() b) plt.Show() c) pt.show() d) plt.show()
1 Which network device used to amplify andregenerate a signal which is on 1
9 its way through a communication channel.
a) switch b) hub c) repeater d) rj45
Q-20 and Q-21 are Assertion (A) and Reason (R) Type questions. Choose
the correct option as:
(A) Both Assertion (A) and Reason (R) are true, and Reason (R) is the
correct explanation of Assertion (A)
(B) Both Assertion (A) and Reason (R) are true, but Reason (R) is not
the correct explanation of Assertion (A)
(C) Assertion (A) is True, but Reason (R) is False
(D) Assertion (A) is False, but Reason (R) is True
2 ASSERTION(A):drop() function can removes data from a Dataframe 1
0 temporarily.
REASONING(R): Axis parameter is compulsory with drop() function.
2 Assertion (A): In SQL, INSERT INTO is a Data Definition Language (DDL) 1
1 Command.
Reason (R): DDL commands are used to create, modify, or remove
database structures, such as tables.
SECTION - B
2 A. What is a DataFrame in Python Pandas? Also, give a suitable 2
Page 3 of 8(2nd PB-XII-IP-2024)
2 example to support your answer.
OR
B. What is the use of the following libraries:
• Pandas
• Matplotlib
2 What is meant by digital footprint? 2
3
2 Jiyais using a table Employee .it has the following Columns: 2
4
Code,Name,Salary,Deptcode

SELECT Deptcode,MAX(Salary) FROM Employee;

He wants to display maximum salary for each department. But he did not
get thedesired result .Rewrite the above query with necessary change to
help him get the desired result.
2 What is a Website and Webpage? 2
5
OR
What is a network? Why is it needed?
2 What is the use of INSTR()? Give a suitable example. 2
6
2 Mention two health concerns associated with excessive use of Digital 2
7 Devices.
2 A. What will be the output of the following code: 2
8 >>>import pandas as pd
>>>nums=pd.Series([9,8,7,6,5],index=[0,2,4,6,8])
>>>print(nums[1:3])
OR
B.
Consider the code given below and answer the following question:
Ld=[{'a',10,'b':20},{'a':5,'b':10,'c':20}]
df=pd.DataFrame(Ld)
print(df)
i) Write the missing statement in the above code which will give
Page 4 of 8(2nd PB-XII-IP-2024)
 error.
ii) How many columns will be there in the dataframe.
SECTION - C
2 What Is the Difference Between a Patent, Copyright, and Trademark? 3
9
3 A. Write a Python program to create the following DataFrame using a 3
0 list of dictionaries.
CnameFee
0 XII 3500
1 XI 3000
2 X 2700
B. Write a Python Program to create a Pandas Series as shown below
using a dictionary. Note that the left column indicates the indices
and the right column displays the data.
XII 3500
XI 3000
X 2700
3 Write an SQL statements to create a table named Stock with the given 2+1
1 one tuple.
=3

3 Consider the following tables: 3

2
Table :Uniform

Table :Cost

Page 5 of 8(2nd PB-XII-IP-2024)

 I. Display no. of uniforms are in each color in the table uniform.
II. List all names in the decreasing order of color from the table
uniform.
III. Display uniformnamealongwiththeircorresponding size.
SECTION - D
3 Write a python program to plot a line chart based on the given data to 4
3 depict the pass percentage of students in CBSE exams for the years 2015
to 2018 as shown below (along with labels).
Year=[2015,2016,2017,2018]
Pass_Percentage=[82,83,85,90]
3 Write suitable SQL query for the following: 4
4
i. Display 7 characters extracted from 7th left character onwards from the
string ‘INDIA SHINING’.
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 149 divided by 6.
OR
Explain the following SQL functions using suitable examples.
i. LENGTH()
ii. TRIM()
iii. NOW()
iv. DAYNAME()
SECTION - E
3 Trine Tech Corporation (TTC) is a professional consultancy company. The 5
5
company is planning to set up their new offices in India with its hub at
Hyderabad. As a network adviser, you have to understand their
requirement and suggest them the best available solutions. Their queries
are mentioned as (i) to (v) below.
Physical location of the blocks of TTC

Page 6 of 8(2nd PB-XII-IP-2024)

 (i)Which will be the most appropriate block, where TTC should plan to
install their server?
(ii) Draw a block to block cable layout to connect all the buildings in the
most appropriate manner for efficient communication.
(iii) Which of the following device will be suggested by you to connect
each computer in each of the buildings?
(a) Switch
(b) Modem
(c) Gateway
(iv) The company is planning to connect its admission office to Hyderabad
which is more than 1000 km from company. Which type of network will
be formed?
(v)what will be the best possible connectivity out of the following you will
suggest to connect the new setup of offices in Hyderabad with its London
based office.
a) Satellite Link
b) Infrared
c) Ethernet
3 Consider the DataFrame df shown below. 5
6
MovieI Title Year Ratin
D g
Page 7 of 8(2nd PB-XII-IP-2024)
 0 1 LAGAAN 2001 8.4
1 2 TAARE ZAMEENPAR 2007 8.5
2 3 3IDIOTS 2009 8.4
3 4 DANGAL 2016 8.4
4 5 ANDHADHUN 2018 8.3
Write Python statements for the DataFrame df to:
I. Print the first four rows of the DataFrame df.
II. Display titles of all the movies.
III. Remove the row having index no. 3.
IV. Display the data of the 'Title' column from indexes 2 to 4 (both
included)
V. Rename the column name 'Year' to 'P_Year'.
3 Ira, a database administrator has designed a database for a clothingshop. 5
7 Help her by writing answers of the following questions based on the
given table: TABLE: CLOTH

CCODE CNAME SIZE COLOR PRICE DOP

C001 JEANSXL BLUE 990 2022-01-21
C002 TSHIRT M RED 599 2021-12-12
C003 TROUSER M GREY 399 2021-11-10
C004 SAREEFREE GREEN 1299 2019-11-12
C005 KURTI L WHITE 399 2021-12-07
i. Write a query to display cloth names in lowercase.
ii. Write a query to display the highest price of the cloths.
iii. Write a query to find size wise total price.
iv. Write a query to display name of the day from DOP COLUMN.
v. Write a query to display 2 characters from 2nd position of the
column cname.
************Best of Luck*************

Page 8 of 8(2nd PB-XII-IP-2024)