Information Technology 4 Marks Quetions

(i) Credit, debit card, Internet banking, etc are the options that he can use to make payment of his bill on the online shopping website.
(ii) (a) They offer huge discounts on goods and services.
(b) Online shopping saves time and effort to buy products of one’s choice.
(iii) Flipkart and Amazon are two popular online shopping websites.
(iv) COD stands for Cash On Delivery. Cash on delivery is the sale of goods by mail order where payment is made at the time of delivery rather than in advance.

(a) DBMS (Database Management System) is used to store logically related information at a centralized location. It facilitates data sharing among all the applications requiring it.
(b) Two uses of the database management system are as follows:

• DBMS is used to store data at a centralized location.
• It is used to minimize data redundancy and data inconsistency.

(i) There are 6 fields and 4 records in the table PRODUCT.
(ii) (a) SELECT* FROM PRODUCT WHERE Qty BETWEEN 100 AND 400;
(b) SELECT S _Name, P _Name, Cost FROM PRODUCT WHERE Qty <300;
(c) SELECT * FROM PRODUCT ORDER BY S_Name;

(a) Mailing labels are usually pieces of paper with adhesive on the back that can be affixed to packages or envelopes to identify the name and address of a recipient. They may also indicate the name and address of the person sending the mail. Mailing labels are extremely useful and time-saving for the people who must send out a large volume of mail.
(b) Mailing labels can be created in two ways:

• Printing multiple copies of a single label
• Printing address lists where each label contains a different address

(a) Quick Sort is especially useful when you add new information to a spreadsheet. When a spreadsheet is long, it is usually easier to add new information at the bottom of the sheet, rather than adding it in its correct place. After you have added information, you can sort the records to update the spreadsheet and put the information in its correct place in quick sort.
(b) When a sheet contains a large amount of data, it can be difficult to find information quickly. In that case, Filters can be used to narrow down the data in your worksheet, allowing you to view only the information you need. In other words, Filters help you to ask questions about your data and retrieve only the relevant information filtering away the undesirable data.