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

