Page 293 - IT-802_class_12
P. 293

3.  ............................ can be primary key in CATEGORY table.
                 i.  Category_id                                   ii.  Name
                 iii. Description                                  iv.  All of these

               4.  What do you mean by  Category_id in COMMODITIES table?
                 i.  Category number                               ii.  Commodity number
                 iii. Category to which the commodity belongs      iv.  Description of Commodity
               5.  What is the data type of address in BUYER table?

                 i.  Int                                           ii.  Char
                 iii. Varchar                                      iv.  None of these

                Ans.  1. iii   2. iv   3. i      4. iii   5. iii


            B.  Fill in the blanks.

               1.  To  store  information  on  the  plans  offered  and  plans  subscribed  by  the  users  is  the  application  of  database  in
                 ................................ .
              2.  ................................ table stores details about commodity, buyer wishes to buy in the future.

               3.  A customer can select items to be purchased by putting them in the shopping cart or in the ................................ .

               4.  If the buyer selects any commodity on the website, then function  ................................ may be used to display the details of
                 commodity.
               5.  Buyer may view his wish list using function ................................ .


                 Ans.   1. Telecommunication      2. WISH_LIST   3. wish list     4. display_product
                        5. display_wishlist

                                                            Section B
                                                    (Subjective Type Questions)
            A.  Short answer type questions.
               1.  Mention any two modes of payment during online shopping.
             Ans.  Two modes of payment during online shopping are as follows:
                 Ð  Net banking
                 Ð Credit card
               2.  Write an application of database in airlines.
             Ans.  Application of database in airlines is to store information to keep track of online and offline reservations.
               3.  Which table stores details of commodities available?
             Ans.  The COMMODITIES table stores details of commodities available.
               4.  What information does the VENDOR table store?
             Ans.  The VENDOR table stores information such as vendor_id and rating of vendor.

               5.  Name two domains where database management may be used.                     [CBSE Sample Paper 2023]
             Ans.  Education, banking







                                                                                 Work-Integrated Learning IT-DMA  291
   288   289   290   291   292   293   294   295   296   297   298