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
   322   323   324   325   326   327   328   329   330   331   332