Page 42 - IPP-12-2025

Write the output of the following SQL queries:
(a) SELECT LENGTH(TITLE) FROM LIBRARY_BOOKS WHERE COPIES > 100;
(b) SELECT TITLE FROM LIBRARY_BOOKS WHERE MONTH(PUB_DATE) = 6;
(c) SELECT TITLE, BOOK_ID FROM LIBRARY_BOOKS WHERE COPIES BETWEEN 50 AND 150;
(d) SELECT MAX(PUB_DATE) FROM LIBRARY_BOOKS;

Section E (3 × 5 = 15 Marks)
35. The Institute of Brilliance is setting up a new campus in Pune with an academic block, an administrative
block, a library block and a computer lab block. Additionally, a regional office in Nagpur will be connected
to the Pune campus for better communication and data sharing. As a network expert, you have to propose
solutions for the given queries. [5]

PUNE NAGPUR

Academic Administrative

Library Computer Lab

The shortest distances between the blocks/offices are as follows:

ACADEMIC TO ADMINISTRATIVE 50 m
ACADEMIC TO LIBRARY 70 m
ACADEMIC TO LAB 100 m
ADMINISTRATIVE TO LIBRARY 60 m
PUNE CAMPUS TO NAGPUR 800 m

The number of computers in each block/office is as follows:

ACADEMIC BUILDING 120
ADMINISTRATIVE BUILDING 50
LIBRARY 30
COMPUTER LAB 150
NAGPUR REGIONAL OFFICE 40
(a) Suggest the most suitable block in the Pune campus to install the server. Give a reason to justify your
answer.
(b) Draw a suitable cable layout of wired network connectivity between the blocks in the Pune campus.
(c) Which networking device would you suggest the college to purchase to interconnect all the computers
within a block in Pune campus?
(d) The company is considering establishing a network connection between its Pune campus office and
Nagpur regional office. Which type of network—LAN, MAN or WAN—will be created? Justify your
answer.
(e) The college plans to develop an online portal where students can log in to check attendance, view
assignments and register for exams. Would you recommend a static or dynamic website for this
purpose? Justify your recommendation.

Practice Paper P.15