Page 80 - IP

i. To select the ItemName purchased after 31-Oct-2010.
ii. To list the ItemName, which are within the warranty period till present date.
iii. To list the ItemName in ascending order of the date of purchase where quantity is
more than 3.
iv. To display ItemName,CostPerItem, and Quantity whose warranty is over.
v. To count the number of Items whose cost is more than 10000.
vi. To increase the quantity of computer,printer andUPS with 5.
vii. Give the output of following SQL commands:
a. SELECT AVG(CostPerItem) FROM Lab;
b. SELECT * FROM LAB WHERE ItemName like ‘%r’;
c. SELECT COUNT(*) FROM LAB WHERE CostPerItem > 15000;
d. SELECT DateOfPurchase,SUM(Quantity) FROM LAB GROUP BY DateOfPurchase;

Q – 9.1How is e-learning beneficial to students ? Give the name of some major e-
learning portals. 2
9.2 List of features of a good programming interface. 2
9.3 Prikshit works for a School. She wishes to create controls on a form for the
following functions. Choose appropriate controls from Text field, Label, radio Button,
Check Box, List box, Combo Box, Button and write in the third column. 1
S.No Control used to Control
1 Enter Admission Number
2 Select Stream