CBSE 2026 · Central · Set 4 · Q14 · 1 mark
What will be the output of the query ?
SELECT MACHINE_ID, MACHINE_NAME FROM INVENTORY
WHERE QUANTITY <= 100;
SELECT MACHINE_ID, MACHINE_NAME FROM INVENTORY
WHERE QUANTITY <= 100;Official answer
From CBSE’s own marking scheme for this paper.
(D)
ID and name of machines with quantity less than or equal to $\displaystyle 100$ from INVENTORY table.
Marking-scheme solution
(D)
ID and name of machines with quantity less than or equal to $\displaystyle 100$ from INVENTORY table.
Structured Query LanguageWHERE ClauseApplymcq
More from Structured Query Language
- Ms. Zoya is a Production Manager in a factory which packages mineral water. She decides to create a table in…2026
- Assume that you are the Manager of the Loans department of a Finance House. To keep track of the loans you…2026
- Abhishek has created a table, named STOCK, with a set of records to maintain the data of packaged milk in his…2026
- Which aggregate function in SQL returns the smallest value from a column in a table?2026
CBSE Class 12 Computer Science past-paper question from the 2026board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.