COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Online transaction processing system
|
|
Online analytical processing system
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Summary. OLTP is defined as an operational system that supports transaction-oriented applications in a 3-tier architecture. OLTP uses transactions that include small amounts of data. OLTP system is an online database changing system.
Detailed explanation-2: -Transaction processing systems consist of computer hardware and software hosting a transaction-oriented application that performs the routine transactions necessary to conduct business. Examples include systems that manage sales order entry, airline reservations, payroll, employee records, manufacturing, and shipping.
Detailed explanation-3: -OLTP systems supported transaction-oriented applications in a three-tier architecture while OLAP systems analyze data stored in a data warehouse. OLTP controls the daily transactions of an organization, while OLAP provides a platform for business analysis encompassing forecasting, analysis, planning, and budgeting.