Page 327 - IT 402 v2.0 class 10
P. 327
iii. SE L E CT * F RO M ACCE SSO RI E S O RD E R B Y P r ice ASC
iv. SELECT NAME FROM ACCESSORIES WHERE Name='Mother Board'
Ans. i. Displays all the records of the table ‘ACCESSORIES’.
o ame Price ID
A01 Mother Board 12000 S01
A02 Hard Disk 5000 S01
A03 Keyboard 500 S02
A04 Mouse 300 S01
A05 Mother Board 13000 S02
ii. Displays records of all those accessories whose price is greater than equal to 5000.
No. Name Price ID
A01 Mother Board 12000 S01
A02 Hard Disk 5000 S01
A05 Mother Board 13000 S02
iii. isplays records of the table SSO I S in ascending increasing order of rice.
No. Name Price ID
A04 Mouse 300 S01
A03 Keyboard 500 S02
A02 Hard Disk 5000 S01
A01 Mother Board 12000 S01
A05 Mother Board 13000 S02
iv. Display records from the table ACCESSORIES where Accessory name is Motherboard.
o ame Price ID
A01 Mother Board 12000 S01
A05 Mother Board 13000 S02
Unsolved Exercise
Section
ecti e T e uestions
Multi le c oice uestions:
1. DML stands for ............................. .
i. Data Manipulation Language ii. Database Manipulation Language
iii. Data Modify Language iv. None of these
More on Database 325

