COMPUTER FUNDAMENTALS

COMPUTER APPLICATIONS

DATABASE MANAGEMENT SYSTEMS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which system is application oriented?
A
Online transaction processing system
B
Online analytical processing system
C
Either A or B
D
None of the above
Explanation: 

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.

There is 1 question to complete.