Beginner
Database Management Systems
Q37 / 100
What is OLTP vs OLAP?
Correct! Well done.
Incorrect.
The correct answer is B) OLTP (Online Transaction Processing) handles frequent short transactions; OLAP (Online Analytical Processing) handles complex analytical queries on large datasets
B
Correct Answer
OLTP (Online Transaction Processing) handles frequent short transactions; OLAP (Online Analytical Processing) handles complex analytical queries on large datasets
Explanation
OLTP: order processing, banking — high concurrency, simple queries, normalized schema. OLAP: data warehousing, BI — complex aggregations, denormalized star/snowflake schema, fewer concurrent users.
Progress
37/100