FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

DATA WAREHOUSING AND DATA MINING

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: -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: -OLTP or Online Transaction Processing is a type of data processing that consists of executing a number of transactions occurring concurrently-online banking, shopping, order entry, or sending text messages, for example.

Detailed explanation-3: -What is OLTP? OLTP or online transactional processing is a software program or operating system that supports transaction-oriented applications in a three-tier architecture. It facilitates and supports the execution of a large number of real-time transactions in a database.

Detailed explanation-4: -Examples of OLTP systems and transactions Some common examples of systems that use OLTP include: ATMs, financial transaction systems and online banking applications; online bookings, ticketing and reservation systems; and. recordkeeping applications, such as health records, inventory control and production scheduling.

Detailed explanation-5: -Typical OLTP applications are airline reservation systems, large order-entry applications, and banking applications. The key goals of OLTP applications are availability (sometimes 7 day/24 hour availability); speed (throughput); concurrency; and recoverability.

There is 1 question to complete.