Write short notes on the following: Online Transaction Processing (OLTP).

CS Professional · Information Technology and Systems Audit · PYQS · June 2021
Write short notes on the following: Online Transaction Processing (OLTP).

Answer & Explanation:

Operational Databases (OLTP - On Line Transaction Processing): Operational databases (OLTP- On Line Transaction Processing), are used to manage more dynamic bits of data. These types of databases allow you to do more than simply view archived data. Operational databases allow you to modify that data (add, change or delete data). These types of databases are usually used to track real-time information. For example, a company might have an operational database used to track warehouse/stock quantities. As customers order products from an online web store, an operational database can be used to keep track of how many items have been sold and when the company will need to reorder stock. Examples of OLTP systems are- Online Banking, Online Ticket booking, Online Order booking etc.

Topics: Database Management System (DBMS)

Open in Interactive Practice Hub · Full Practice Hub · Chapter Weightage · More in this subject

Related Questions in this Topic