CBSE 2025, Set 4 Solutions
CBSE Computer Science (2025)

Write a Python program to input a list of integers and display the largest number present in the list.

What is the purpose of the PRIMARY KEY constraint in SQL?

Write the SQL command to add a column Email to table STUDENT.

Write a Python function CountOdd(L) that accepts a list L of integers and returns the count of odd numbers present in the list.

Write a Python program to read a text file "data.txt" and count the number of words present in the file.

Suman has created a table named WORKER with a set of records to maintain the data of the construction sites, which consists of WID, WNAME, WAGE, HOURS, TYPE, and SITEID. After creating the table, she entered data in it, which is as follows :

(a) Based on the data given above, answer the following questions : (i) Write the SQL statement to display the names and wages of those workers whose wages are between 800 and 1500. (ii) Write the SQL statement to display the record of workers whose SITEID is not known. (iii) Write the SQL statement to display WNAME, WAGE and HOURS of all those workers whose TYPE is 'Skilled'. (iv) Write the SQL statement to change the WAGE to 1200 of the workers where the TYPE is "Semiskilled".

OR

(b) Considering the above given table WORKER, write the output on execution of the following SQL commands : (i) SELECT WNAME, WAGE*HOURS FROM WORKER WHERE SITEID = 103; (ii) SELECT COUNT(DISTINCT TYPE) FROM WORKER; (iii) SELECT MAX(WAGE), MIN(WAGE), TYPE FROM WORKER GROUP BY TYPE; (iv) SELECT WNAME, SITEID FROM WORKER WHERE TYPE="Unskilled" ORDER BY HOURS;

'Swabhaav' is a big NGO working in the field of Psychological Treatment and Counselling, having its Head Office in Nagpur. It is planning to set up a center in Vijayawada. The Vijayawada Center will have four blocks ADMIN, PSYCHIATRY, PSYCHOLOGY, and ICU. You, as a Network Expert, need to suggest the best network-related solutions for them to resolve the issues/problems mentioned in questions (i) to (v), keeping the following parameters in mind :

Block to Block distances (in metres) :

Distance of Nagpur Head Office from Vijayawada Center = 700 km

Number of Computers in each block is as follows:

(i) Suggest the most appropriate location of the server inside the Vijayawada Center. Justify your choice.\n (ii) Which hardware device will you suggest to connect all the computers within each block of Vijayawada Center? \n (iii) Draw a cable layout to efficiently connect various blocks within the Vijayawada Center. \n (iv) Where should the router be placed to provide internet to all the computers in the Vijayawada Center? \n (v) (a) The Manager at Nagpur wants to remotely access the computer in Admin block in Vijayawada. Which protocol will be used for this? \n OR \n (b) Which type of Network (PAN, LAN, MAN or WAN) will be set up among the computers connected with Vijayawada Center?