Online Transaction Processing (OLTP) is a category of data processing that refers to the management of transactional data in real-time. OLTP involves transaction-oriented tasks such as inserting, deleting, and updating data in a database. OLTP systems mainly deal with a large number of transactions by a large number of users.
Option A is incorrect. Batch processing processes transactions in batch or group, in sequential, non-stop, often simultaneous manner. OLTP systems are preferred to manage and facilitate transaction-oriented applications.
Option B is incorrect. Stream processing focuses on the real-time processing of continuous data streams and takes action on a series of data at the time just when the data is created.
Option C is Correct. Online Transaction Processing (OLTP) is preferred for transaction-oriented tasks to manage transactional data in real-time, for e-commerce and other applications.
Option D is incorrect. Online Analytical Processing (OLAP) involves the use of complex queries for the analysis of aggregated historical data received from the OLTP systems.
Reference: To know more about the Online Transaction Processing (OLTP), refer to the documentation below from Azure:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/online-transaction- processing