OLTP OLAP
OLTP stands for Online Transaction Processing. OLAP stands for Online Analytical Processing.
It has fundamental business tasks It has Multi-dimensional business tasks
It is used to normalize small database It is used to denormalize large database
It supports simple queries by users It supports complex queries by the system.
BY Best Interview Question ON 07 Nov 2021