Question 1 / 5 · latest firstNext ›
✓ Board-verified
Computer Science · 2026 · 1 mark
CBSE 2026 · Central · Set 4 · Q14
What will be the output of the query? SELECT MACHINE ID, MACHINE NAME FROM INVENTORY WHERE QUANTITY <= 100;
What will be the output of the query ?
SELECT MACHINE_ID, MACHINE_NAME FROM INVENTORY
WHERE QUANTITY <= 100;Official answer
(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.
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 a database to keep track of the stock…2026
- Assume that you are the Manager of the Loans department of a Finance House. To keep track of the loans you have created two tables: CUSTOMERS and…2026
- Abhishek has created a table, named STOCK, with a set of records to maintain the data of packaged milk in his shop. After creating the table, he…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 2026 board exam, with the answer as CBSE’s own marking scheme gives it. Where our answers come from.