Page 37 - IPP-12-2024

Write the SQL functions which will perform the following operations:
(i) To return the summation of all non-NULL values of a data set.
(ii) To extract a substring starting from a position with a specific length.
(iii) To convert a string to uppercase.
(iv) To return the year for a specified date.
(v) To round off a number to a specified number of decimal places.
34. A company in Mega Enterprises has 4 wings of buildings as shown in the diagram: [5]

W1 W2

W3 W4

Centre-to-centre distances between various buildings:
W3 to W1 — 50m
W1 to W2 — 60m
W2 to W4 — 25m
W4 to W3 — 170m
W3 to W2 — 125m
W1 to W4 — 90m
Number of computers in each of the wings:
W1 — 150
W2 — 15
W3 — 15
W4 — 25

Computers in each wing are networked but the wings are not networked. The company has now decided
to connect the wings also.
(i) Suggest the 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 repeater with justification.
(v) Suggest the placement of the Hub/Switch with justification if the company wants to minimize
network traffic.
35. Write Python code to draw the following Bar graph representing the number of students in each class. [5]

40

30

20

10

0
IX X XI XII
Or
Write Python code to create a Line graph using the list of elements x and y. Set ylabel as “marks” and xlabel
as “names”. The title of the graph is ‘Result’.
x=['A','B','C','D','E']

y=[82,25,87,14,90]
A.40 Informatics Practices with Python–XII