KENDRIYA VIDYALAYA SANGATHAN, CHANDIGARH REGION

PREBOARD -I EXAMINATION 2023-24

CLASS - XII
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. Digital footprints are also known as 1
a) Digital Data b) Plagiarism c) Digital Tattoos d) Digital Print
3. Which of the following are Net Etiquette? 1
a) Be Ethical b) Be Respectful c) Be Responsible d) All of the above
4. In SQL, the equivalent of UCASE() is 1
a) UPPERCASE () b) CAPITALCASE() c) UPPER() d) TITLE ()
5. Which one of the following is not an aggregate function? 1
a) ROUND() b) SUM() c) COUNT() d) AVG()
6. Which of the following is not feasible method of e-waste management? 1
a) Reuse b) Throwing in Sea c) Recycle d) Reduce
7. Size of DataFrame is_______ and values are_______ 1
a) immutable, mutable b) mutable, mutable
c) mutable, immutable d) immutable, immutable
8. In SQL, What will be output of 1
SELECT INSTR (‘wednesday’, 'e');
a) 1 b) 5 c) 2 d) 4
9. In SQL, What will be output of 1
SELECT Month (‘2023-05-23’);
a) May b) 5 c) NULL d) 0
10. A series by default have numeric data labels starting from________ 1
a) 1 b) 0 c) ‘1’ d) ‘a’
11. Which operator performs pattern matching? 1
a) BETWEEN operator b) LIKE operator c) EXISTS operator d) None of these
12. To delete a column from a dataframe ______method can be used. 1
a) delete() b) remove() c) erase() d) drop()
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. If column “Salary” contains the data set {10000, 15000, 25000, 10000, 15000}, what 1
will be the output after the execution of the given query?
SELECT SUM(DISTINCT SALARY) FROM EMPLOYEE;
a)75000 b) 25000 c) 50000 d) 10000
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) :
DataFrame.loc(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. Give two differences between Hub and Switch. 2
OR
Explain Static and Dynamic Webpage.
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 statement:
SELECT Stream, MAX(Agg) FROM EMPLOYEE;
But she did not get the desired result. Rewrite the above query with necessary changes to help
her get the desired output.
21. Considering the same string “Preoccupied” 2
Write SQL commands to display:
a) the position of the substring ‘cup’ in the string “Preoccupied”
b) the first 4 letters of the string
22. What will be the output of the following 2
import pandas as pd
x= [20, 40,90, 110]
y=pd.Series([20, 40,90, 110])
print (x*2)
print(y*2)
23. What is the difference between copyright and Patent? 2
24. What will be the output of the following code: 2
import pandas as pd
A=pd.Series(data=[10,13,22,18])
print(A>15)
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
15000
2 Sunny Sales
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 python statements to create a data frame for the following data. 3
Name Age Designation
RAJIV 20 CLERK
SAMEER 35 MANAGER
KAPIL 45 ACCOUNTANT
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. Sumit got good marks in all the subjects. His father gifted him a laptop. He would like to 3
make Sumit aware of health hazards associated with inappropriate and excessive use of
laptop. Help his father to list the points which he should discus with Sumit.
OR
How would you recognise if one of your friends is being cyber bullied? Cite the online
activities which would help you detect that your friend is being cyber bullied?
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 Clas DOB Gender City Marks

s
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. Ravi, a data analyst has designed the DataFrame df that contains data about Car 1+
Sales with ‘T1’, ‘T2’, ‘T3’, ‘T4’ as indexes shown below. Answer the following 1+
questions: 2

Col1 Col2 Col3 Res

T1 62.893165 100.0 60.00 True
T2 94.734483 100.0 59.22 True
T3 49.090140 100.0 46.04 False
T4 38.487265 85.4 58.60 False

a) Predict the output of the following python statement:

i. df.shape
ii. df[1:3]
iii) Write Python statement to display the data of Col3 column of indexes T2 to T4.

OR (Option for part (iii) only)

Write Python statement to compute and display the difference of data of Col2 column and
Col3 column of the above given Data Frame.
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 ‘R’ in string 'INFORMATION FORM'
e) To find out the result of 9**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. Knowledge Supplement Organisation has set up its new centre at Mangalore for its 5
office and web based activities. It has 4 blocks of buildings as shown in the diagram
below:

a) Suggest a cable layout of connections between the blocks.

b) Suggest the most suitable place (i.e. block) to house the server of this organization with a
suitable reason.
c) Suggest the placement of the following devices with justification
(i) Repeater
(ii) Hub/Switch
d) The organization is planning to link its front office situated in the city in a hilly region
where cable connection is not feasible, suggest an economic way to connect it with
reasonably high speed?
e) VoIP technology is to be used which allows one to make voice calls using a broadband
internet connection. Expand the term VoIP.
35. Collect the minimum temperature of your city for a month and present it using a histogram. 5
Let us
assume the following data:
min_temp=[6,5,6,5,5,5,4,9,11,12,14,15,12,13,11,11,8,7,10,10,9,9,7,8,9,5,6,6,7,10]

OR
Write Python code to plot a bar chart for India’s medal tally as shown below: