What kind of query should I use and why?
If a company has uses OLAP and OLTP simultaneously to lets say add new customers, ordering products, and so forth. What kind of query should the company use and why?
Hi,
as u told that u wanted to ADD new customers to ur database then u have to use INSERT query, it will add customer in the table. It is INSERT or APPEND query.
if u want to delete particular customer then u will have to use DELETE query. It will delete that customer from ur table.
if u want to change some particulars of a customer, e.g. to change the address or phone number or e-mail ID or any existing information of a customer then use UPDATE query.
if u want to see information about a customer or u want to see selected information then u have to use SELECT query.