NEO CONVENT SR. SEC.

SCHOOL
PRE BOARD 2022-23

CLASS: XII MAX MARKS:70

SUBJECT: INFORMATICES PRACTICES(065) TIME: 3 HOURS

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 carrying 02 marks each.
5. Section C has 05 Short Answer type questions carrying 03 marks each.
6. Section D has 03 Long Answer type questions carrying 05 marks each.
7. Section E has 02 questions carrying 04 marks each.
8. All programming questions are to be answered using Python Language only.

PART A
1 Given a Pandas series called S, the command which will display the last 4 rows is _ . 1
a. print(S.tail(4))
b. print(s.Tail())
c. print(s.tails(4))
d. print(s.tail(4))
2 are messages that a web server transmits to a web browser so that the web 1
server can keep track of the user’s activity on a specific website.
a. text
b. cookies
c. email
d. chat
3 The trim()function in MySql is an example of . 1
a. Math function
b. Text function
c. Date Function
d. Aggregate Function
4 The command can be used to insert a new row in a table in SQL. 1
a. add()
b. append
c. insert into
d. alter table.
5 State whether True or False : 1
i. Copying and pasting data from internet or other digital resources is ethical.
ii. E-waste is very hazardous if not handled carefully.
6 Rohan wants to print the row labels of the dataframe. He should use the 1
attribute of a dataframe.
 a. column
b. columns
c. index
d. rowname
7 Write the output of the following SQL command. 1
select pow(2,–2);
a. -4
b. 4
c. 0.25
d. -0.25
8 What is e-waste? 1
(a) electronic waste
(b) environmental waste
(c) earth waste
(d) energy waste
9 What will be the output of the following code? 1
mysql>> lcase ('INFORMATICS PRACTICES CLASS 12TH');

10 Which of these is not an example of unguided media? 1

(i) Optical Fibre Cable (ii) Radio wave (iii) Bluetooth (iv) Satellite

11 Stealing someone’s intellectual work and representing it as your own is known as . 1

a. Phishing
b. Spamming
c. plagiarism
d. hacking

12 Which of the following is not the correct aggregate functions in SQL. 1

(a) AVERAGE() (b) MAX() (c) COUNT() (d) TOTAL()

13 A URL can specify the IP address of the Web _ that houses a Web page? 1
a) server
b) client
c) e-mail recipient
d) None

14 ………………. are the records and traces that are left behind while internet is used. 1
a) Digital data
b) Digital Footprint
c) Data Protection
d) Plagiarism
15 To mention conditions along with group by function ............................. clause is used. 1
a)Where b)having c)distinct d)select
16 Jhilmalini has stolen a credit card. She used that credit card to purchase a laptop. What 1
type of offence has she committed?
a. online fraud
b. cyber bullying
 c. cyber stalking
d. All of the above.

Q17 and 18 are ASSERTION AND REASONING based questions. Mark the correct
choice as
i. Both A and R are true and R is the correct explanation for A
ii. Both A and R are true and R is not the correct explanation for A
iii. A is True but R is False
iv. A is false but R is True
17 Assertion (A) : import matplotliblib.pyplot as plt is used to import pyplot .
Reason (R) :It is python library so it is imported for using its function.

18 Assertion (A):- Series store data row wise.

Reasoning (R): - A Series is a one-dimensional labelled data structure.

SECTION B
19 (a) Consider a given Series , T1: 1
SUB1 45
SUB2 65
SUB3 24
SUB4 89
Write a program in Python Pandas to create the series.
(b) Define Series. Write a python statement to create an empty statement.
1

20 Rohit writes the following commands with respect to a table student having fields, Sno, 2
name, Age, fee.
Command1 : Select count(*) from student;
Command2: Select count(name) from employee;
he gets the output as 6 for the first command but gets an output 5 for the second command.
Explain the output with justification.
21 Consider the following Series object, C_amt 2
Mouse 135
Keyboard 260
Pen drive 80
CD 155
i. Write the command which will display the name of the items having amount <100.
ii. Write the command to name the series as comp_items.

22 Consider the following DataFrame, Student 2

Rollno Name Class Section Marks Stream

S1 1 Sheetal XI A 87 Science
S2 2 Preet XI B 89 Arts
S3 3 Kartik XI A 92 Science
S4 4 Laksh XI A 94 Commerce

Write commands to :
 i. Add a new column ‘Percentage’ to the Data frame.
ii. Add a new row with values ( 5 , Rohit ,XI, A ,98,Science)

23 (a) Expand the following terms related to Computer Networks: 1

a. HTTP
b. POP3
c. FTP
d.VoIP
1
(b)Differentiate between static and dynamic web pages.
24 (a) Consider the following SQL string: 1
“Computer”Write commands to display:
a. “mputer”
b. “ut”

(b) Considering the same string

“Computer”Write SQL commands to 1
display:
a. The position of the substring ‘ter’ in the string “Computer”.
b.The first 5 letters of the string.
25 (a) List any two health problems related to excessive use of Technology. 1
(b) List 4 steps to reduce e waste. 1
SECTION C
26 Consider two objects s and t. s is a list whereas t is a Series. Both have values 20, 40, 3
90, 110.What will be the output of the following two statements considering that the
above objectshave been created already
a. print (s*2) b. print(t*2) Justify your answer.

27 Consider the Table “Infant” shown below. 3

Table: Infant

NOTE: Discount column stores discount %.

Write SQLcommands to:
a. To displays the number of items that have more than 10% as discount.
b. To display the highest unit price of items.
c. To display the names of items that has ‘Baby’ anywhere in their item names.

28 Write a Python code to create a DataFrame with appropriate column headings from the list 3
 given below:

[[21101,'MANJUSH',58],[21102,'AKSHAY',60],[21103,'ANN' ,76],
[21104,'NITHYA',48]]
29 (a)What are the different ways in which authentication of a person can be performed? 1.5
(b)Describe measures to recycle your e-waste. 1.5

30 (a) Predict the output of the following queries: 1.5

I) SELECT INSTR (‘Very good’, 'good');
II) SELECT MID('Quadratically',5,6);
III) SELECT RIGHT (‘Command', 3);
(b)Explain the following SQL functions using suitable examples.
a) INSTR()
b) MID()
c) RIGHT() 1.5

SECTION D
31 Consider the following graph. Write the code to plot it. 5

OR
Draw the following bar graph representing the uses of programming language.

32 A company AST Enterprises has 4 wings of buildings as shown in the diagram : 5

Center to center distances between various Buildings:
T3 to T1 - 50m
T1 to T2 - 60m
T2 to T4 - 25m
T4 to T3 - 170m
T3 to T2 - 125m
 T1 to T4 - 90m

Number of computers in each of the wing:

T1 - 140
T2 - 15
T3 - 15
T4 - 25

T1 T2

T3 T4

Computers in each wing are networked but wings are not networked The company has
now decided to connect the wings also.
i. Suggest a most suitable cable layout for the above connections.
ii. Suggest the most appropriate topology of the connection between the wings.
iii. The company wants internet accessibility in all the wings. Suggest a suitable
technology.
iv. Suggest the placement of the following devices with justification if the company
wants minimized network traffic
a) Repeater b)Hub / switch
v. The company is planning to link its head office situated in Pune with the offices
in hilly areas. Suggest a way to connect it economically.
33 (a)Write the SQL functions which will perform the following operations: 2.5
i) To display the current date .
ii) To display the substring “earn” from the whole string ‘LearningIsFun’.
iii) To round the number 76.384 up to 2 place after decimal point.
iv) To find the position of first occurrence of ‘R’ in string 'INFORMATION FORM'
v) To find out the result of 93 .
(b)Consider a table Order with the following data: 2.5

Write SQL queries using SQL functions to perform the following operations:
i) To count the number of orders booked by Salespersons with names starting with ‘R’.
ii) Display the position of occurrence of the string “an” in SalesPerson names.
iii) Display the four characters from SalesPerson name starting from second character.
 iv) To find the average of order amount.
v) Display the month name for the Order date.
SECTION E
34 A relation Vehicles is given below: 1+1+2

Write SQL commands to:

a. Count the type of vehicles manufactured by each company.
b. Display the total price of all the types of vehicles.
c. Display the average price of each type of vehicle having quantity more than 20.
OR (Option for part iii only)
Write a query to display type and price * quantity with title TOTAL PRICE company wise

35 A dataframe fdf stores data about passengers, Flights and Years as given below. 1 each

S_NO Year Months MalePassengers FemalePassengers

1 2009 January 90 30
2 2009 February 100 18
3 2009 March 98 22
4 2009 April 110 30

1) Write python code to create the dataframe.

Perform the following operations on the DataFrame :

2) Add both the male and female passengers and assign to column “Total_ passengers”
3) Display the maximum passengers in male passengers and maximum passengers in
female passengers of the Data Frame.
4) Predict the output of the following python statement:
fdf.loc[:,’year’:’MalePassengers’]