Answer / hr@tgksolutions.com

Databases made for handling transaction-oriented applications are known as OLTP (Online Transaction Processing) databases. They are designed to handle a lot of brief online transactions (update, remove, insert). Retail sales systems are one example.
Databases created for querying and reporting are known as OLAP (Online Analytical Processing) databases, and they are frequently used for corporate intelligence and data analysis. They are best suited for processes involving a lot of reading on big data sets. Data warehousing is one example.

What is data independence and also explain its types?

1 Answers  

---

What do you understand by the view and mention the steps to create, update and drop a view?

1 Answers  

---

What is progress open edge?

1 Answers  

---

What is the use of GRANT option in EXP command ?

1 Answers  

---

What is unique key example?

1 Answers  

---

What is the quickest sorting method to use?

1 Answers  

---

What do you understand by data model?

1 Answers  

---

What is the use of RECORD option in EXP command ?

1 Answers  

---

What is the normal procedure followed by a java client to access the db?

1 Answers  

---

What are the differences between drop, truncate and delete commands?

1 Answers  

---

Segregate database technology's development.

1 Answers  

---

What are the different technologies used to access Database from Visual Basic?

1 Answers   CGI,

---