CBSE 2025, Compartment, Set 4

Question

Consider the table STAFF given below :

![Table Staff](https://www.edvaya.com/images/cbse/computer-science/2025/set4/q32-staff.webp)

Write the output for the queries given below:
(I) `SELECT STAFF_NAME FROM STAFF WHERE SALARY BETWEEN 25000 AND 30000;`
(II) `SELECT * FROM STAFF WHERE DEPARTMENT = "MATHS" AND SALARY > 25000;`
(III) `SELECT STAFF_NAME, STAFF_ID FROM STAFF WHERE DEPARTMENT LIKE "%S";`
(IV) `SELECT MAX(SALARY) FROM STAFF;`

Edvaya · Accepted Answer

The correct answer is Subjective. **(I) Output:** ``` SUNITA MANJEET ``` *(Explanation: The BETWEEN clause is inclusive, so it captures salaries 26000 and 25000).* **(II) Output:** ``` S101 | SUNITA | 26000 | MATHS | TGT ``` *(Explanation: Filters for the MATHS department and salary strictly greater than 25000. Manjeet is exactly 25000, so only Sunita matches).* **(III) Output:** ``` SUNITA | S101 MANJEET | S102 ``` *(Explanation: Finds names and IDs of staff where the department ends with "S", which applies to MATHS).* **(IV) Output:** ``` 80000 ``` *(Explanation: Retrieves the maximum salary in the table).*

Edvaya Target

Edvaya Aspire

Take a Free Mock Test

Target Subjects

Aspire Subjects

Subject Mastery

Computer Science > Database Management > Structured Query Language

Keep Practicing

Edvaya Target

Current Question

Community Stats

Track Your Progress

Quick Actions

We Value Your Privacy