KENDRIYA VIDYALAYA SANGATHAN, JAIPUR REGION
PREBOARD -II EXAMINATION 2023-24
CLASS - XII SET A
INFORMATICS PRACTICES (IP) (065)
TIME: 03 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 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. Hub is a 1
a) Broadcast device b) Unicast device c) Multicast device d) None of the above
2. For web pages where the information is changed frequently, for example, stock prices, 1
weather information which out of the following options would you advise?
a) Static web page b) Dynamic web page
c) Fixed Web page d) Homepage
3. Which of the following are Net Etiquette? 1
a) Be Ethical b) Be Respectful c) Be Responsible d) All of the above
4. Which type of values will be returned by SQL while executing the following statement? 1
Select length(“LENGTH”)
a) Numeric value b) Text value c) Null value d) Float value
5. Which one of the following is not an aggregate function? 1
a) ROUND() b) SUM() c) COUNT() d) AVG()
6. An organization purchase new computers every year and dumps the old one into the local 1
dumping yard. Write the name of the most appropriate category of waste that the
organization is creating every year, out of the following options:
a) Business waste b) Commercial waste c) E-waste d) Green waste
7. Size of DataFrame is_______ and values are_______ 1
a) immutable, mutable b) mutable, mutable
c) mutable, immutable d) immutable, immutable
8. If column “salary” contains the data set (45000, 5000, 55000, 45000, 55000), what will be 1
the output after the execution of the given query?
SELECT AVG (DISTINCT salary) FROM employee;
a) 38500 b) 40000 c) 41000 d) 35000
9. In SQL, What will be output of 1
SELECT Month (‘2023-05-23’);
a) May b) 5 c) NULL d) 0
10. We can create DataFrame from: 1
a) Series b) Numpy arrays c) List of Dictionaries d) All of the above
11. Which operator performs pattern matching? 1
a) BETWEEN operator b) LIKE operator c) EXISTS operator d) None of these
12. In order to draw charts in Python, which of the following statement will be used: 1
a) import [Link] as pl b) import [Link] as plt
c)Import matplotlib from pyplot as plt d) import pyplot from matplotlib as plt
13. It allows a visited website to store its own information about a user on the user’s 1
computer:
a) Spam b) cookies c) Malware d) Adware
14. Having clause and Where clause can be used interchangeably in SELECT queries? 1
a) True b) False c) Only in views d) With order by
15. The name and logo of the software will be protected under 1
a) Patent b) Copyright c) Trademark d) Digital Property right
16. Digital Footprint last for 1
a) 1 Month b) 1 Year c) Depends on browser’s setting d) Forever
17. Assertion: The internet is a collection of interconnected computer networks, linked by 1
transmission medium such as fiber optic cables, transmission wires, wireless connection etc.
Reason: World Wide Web is a collection of websites or web pages stored in web servers and
connected to local computers through the internet.
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
18. Assertion (A): 1
Boolean indexing is a type of indexing.
Reasoning (R) :
[Link](False) function can be used to find the relative values where index
value is False
a) Both A and R are true and R is the correct explanation of A.
b) A is true but R is false.
c) A is false but R is true.
d) Both A and R are false
SECTION B
19. Explain the terms Web Page and Web Site. 2
OR
Compare and contrast – STAR and BUS topologies
20. Nikita is using a table EMPLOYEE. It has the following columns: 2
Admno, Name, Agg, Stream [column Agg contains Aggregate marks]
She wants to display highest Agg obtained in each stream. She wrote the following statemen
t:
SELECT Stream, MAX(Agg) FROM EMPLOYEE;
But she did not get the desired result. Rewrite the above query with necessary changes to h
elp her get the desired output.
21. Write the purpose of GROUP BY clause in SQL? Explain with a suitable example. 2
22. What will be the output of the following 2
import pandas as pd
x= [20, 40,90, 110]
y=[Link]([20, 40,90, 110])
print (x*2)
print(y*2)
23. What is the difference between copyright and Patent? 2
24. Carefully observe the following code: 2
>>> import pandas as pd
>>> xiic = {‘amit’:34, ‘kajal’:27, ‘ramesh’:37}
>>> xiid = {‘kajal’:34, ‘lalta’:33, ‘prakash’:38}
>>> result = {‘PT1’:xiic, ‘PT2’:xiid}
>>> df = [Link](result)
>>> print(df)
Answer the following:
i) List the index of the dataframe df
ii) Find the output of the following code :
print([Link][‘kajal’:’ramesh’])
25. What is the difference between count() and count(*)? Give Example 2
SECTION C
26. Mr. Ram is working on mysql table named ‘employee’ having following structure: 3
Empno Name Dept Salary
1 Ravi Sales 10000
2 Sunny Sales 15000
3 Vikram IT 5000
4 Nitin HR 20000
He needs to perform following task on the table. Write Sql query
a) To display the maximum salary given to employee.
b) To display last three character of column Name.
c) To display 4th characters from 4th place of column dept.
OR
Predict the output of the following queries:
a) Select mod(12,0)
b) Select SUBSTRING("Kevin Peterson",5,3);
c) Select Month("2023-09-12");
27. Write a Python code to create a DataFrame with appropriate column headings from the list 3
given below:
[ [1001,'IND-AUS', ’2022-10-17’], [1002,'IND-PAK', ’2022-10-23’], [1003,'IND-SA', ‘2022-10-
30’], [1004, 'IND-NZ', ’2022-11-18’] ]
28. Write MySQL statements for the following: 3
a) create a database “BOOKS”.
b) create table Bookdetail using given description
Field Name Data type Constraint
Bno integer(4) primary key
Bname varchar(20)
Author varchar(30)
Price float(4,2)
29. What do you mean by “Digital Footprints”? Explain the different types of digital footprints 3
with example?
OR
What do you mean by Intellectual Property Right? Give some names of common type of IP
with example.
30. Consider the given DataFrame ‘Stock’: 3
Name Price
0 Nancy Drew 150
1 Hardy boys 180
2 Diary of kid 225
3 Harry Potter 500
Write suitable Python statements for the following:
a) Add a column called Special_Price with the following data: [135,150,200,440].
b) Add a new book named ‘The Secret' having price 800.
c) Remove the column Special_Price.
SECTION D
31. Consider the given table Result and write SQL queries for (a) to (d) 4
Rollno Name Class DOB Gender City Marks
1 Nanda X 12-10-1998 F Delhi 56
2 Saurabh XI 24-12-1994 M Chennai 45
3 Sanal XII 15-08-2003 M Delhi 66
4 Rekha X 11-09-2004 F Mumbai 81
5 Neha XII 05-06-2006 F Chennai 77
a) Display the minimum and maximum marks obtained by female students.
b) Display different Cities (without repetition) available in table.
c) Display the average mark obtained by students of each City.
d) Display the class wise total of marks obtained by students.
32. Mr. Summit, a data analyst has designed the DataFrame df that contains data about 1+
Computer infrastructure with ‘S01’, ‘S02’, ‘S03’, ‘S04’, ‘S05, ‘S06’ as indexes shown below. 1+
2
Answer the following questions:
i) Predict the output of the following python statement:
A) [Link] B) df[2:4]
ii) Write Python code to display the data of working column of indexes S03 to S05.
OR (Option for part ii only)
Write Python statement to compute and display the difference of data of computers column
and working column of the above given DataFrame.
SECTION E
33. Write the SQL functions which will perform the following operations: 5
a) To display the current date.
b) To display the substring “earn” from the whole string ‘LearningIsFun’.
c) To round the number 76.384 up to 2 places after decimal point.
d) To find the position of first occurrence of ‘RM’ in string 'INFORMATION FORM'
e) To find out the result of 9 raised to power 3.
OR
Consider a table Order with the following data:
Write SQL queries using SQL functions to perform the following operations:
a) Insert a new row with following data[0106,’2015-10-12’,’Rakhi Singh’,35000].
b) To change the value 34000 to 40000 in OrderAmount column.
c) To remove the records of those Orders whose OrderAmount are less than 50000.
d) To add a new column ‘Item’ of suitable datatype.
e) To display records of “Ravi Kumar” SalesPerson.
34. BATA Shoes Pvt. Limited is an international shoe maker organization. It is planning to set up 5
its India Office at Agra with its head office in Delhi. The Agra office campus has four main
buildings - ADMIN, PRODUCTION, WAREHOUSE and SHIPPING.
You as a network expert have to suggest the best network related solutions for their
problems raised in (i) to (v), keeping in mind the distances between the buildings and other
given parameters.
i) Suggest the most appropriate location of the server inside the AGRA Office (out of
the four buildings) to get the best connectivity for maximum number of computers. Justify
your answer.
ii) Suggest and draw cable layout to efficiently connect various buildings within the
AGRA Office for a wired connectivity.
iii) Which networking device will you suggest to be procured by the company to
interconnect all the computers of various buildings of AGRA Office?
iv) Company is planning to get its website designed which will allow shopkeepers to see
their products, shipping details themselves on its server. Out of the static or dynamic, which
type of website will you suggest?
v) Which of the following will you suggest to establish the online face to face communication
between the people in the ADMIN office of AGRA and Delhi head office?
A) Cable TV B) Email (C) Video conferencing D) Text chat
35. Write Python code to plot a bar chart for No of Games Tally in State Level Sports shown below: 5
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
changing weekly average temperature in Jhansi for four weeks.
Week = [1, 2, 3, 4]
Avg_week_temp = [30, 26, 28,24]