An example of an OLTP environment is _____
-
creating a report to show a comparison of sales from this week to last week
-
creating a report show how much credit can be extended to a customer
-
creating a report that shows the top ten selling items across all stores for one year
-
updating a checking account to reflect a deposit
OLTP (Online Transaction Processing) systems are characterized by individual, transactional operations that update data in real-time. Updating a checking account to reflect a deposit is a classic OLTP operation. The other options - sales comparison reports, credit limit reports, and top-selling item reports - are all OLAP (Online Analytical Processing) activities involving historical data analysis and reporting.
OLTP (Online Transaction Processing) systems handle real-time, high-volume, day-to-day transactional operations like updating a checking account with a deposit. Generating comparison or aggregate sales reports is analytical/reporting work, which belongs to OLAP (Online Analytical Processing), not OLTP.