Page 34 - IPP-12-2025
P. 34

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
   29   30   31   32   33   34   35   36   37   38   39