Page 34 - IPP-12-2025

Write the outputs for the following SQL queries:
(a) SELECT Name FROM STAFF WHERE Dept='IT';
(b) SELECT MAX(Salary) FROM STAFF;
(c) SELECT Dept, COUNT(*) FROM STAFF GROUP BY Dept;
(d) SELECT LOWER(Name) FROM STAFF;

SECTION E (3 x 5 = 15 Marks)
35. RoboToy, a company, is establishing a new office in Chennai with these units— Manufacturing, Admin, Sales
and HR. Additionally, a regional office in Bengaluru will be connected to the Chennai office for seamless
communication and data sharing. As a network expert, propose solutions to the following queries: [5]

CHENNAI BENGALURU

Manufacturing Sales

HR Admin

The shortest distances between the units are as follows:

ADMIN TO SALES 100 m
ADMIN TO HR 60 m
SALES TO HR 80 m
HR TO MANUFACTURING 45 m
MANUFACTURING TO SALES 55 m
ADMIN TO BENGALURU BRANCH 348 km
The number of computers in each unit/office is as follows:

ADMIN 50
SALES 30
HR 20
MANUFACTURING 40
BENGALURU REGIONAL OFFICE 35

(a) Suggest the most suitable unit/office to install the server. Give a reason to justify your suggested
location.
(b) Draw a suitable cable layout of wired network connectivity between the units at the Chennai office.

(c) Which networking device would you suggest to interconnect all the computers within a unit at the
Chennai office?

(d) The company is considering establishing a network connection between its Chennai office and
Bengaluru regional office. Which type of network—LAN, MAN or WAN—will be created? Justify your
answer.
(e) The company plans to develop an online portal where employees can log in to check their attendance
and target hits. Which website would you recommend for this purpose— static or dynamic? Justify
your answer.

Practice Paper P.7