OLTP is a database system that manages transaction-oriented applications, handling multiple short online transactions efficiently.

Explanation:

• Used in banking, e-commerce, and airline booking systems.
• Handles high transaction volumes with ACID compliance.
• Characteristics:
  • Fast query execution
  • Small transactions (INSERT, UPDATE, DELETE)
  • High concurrency

Example OLTP Query (Bank Transaction):

sqlCopyEditSTART TRANSACTION;
UPDATE Accounts SET balance = balance - 500 WHERE account_id = 1;
UPDATE Accounts SET balance = balance + 500 WHERE account_id = 2;
COMMIT;