UGC NET CSE | December 2015 | Part 2 | Question: 33

Question

____ system is market oriented and is used for data analysis by knowledge workers including Managers, Executives adn Analysts.

• A. OLTP
• B. OLAP
• C. Data System
• D. Market System

Answer 1

Answer must be OLAP

- OLTP (On-line Transaction Processing) 

•  characterized by a large number of short on-line transactions (INSERT, UPDATE, DELETE).
• The main emphasis for OLTP systems is put on very fast query processing, maintaining data integrity in multi-access environments and an effectiveness measured by number of transactions per second.
• In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF). 

- OLAP (On-line Analytical Processing)

• characterized by relatively low volume of transactions.
• Queries are often very complex and involve aggregations.
• For OLAP systems a response time is an effectiveness measure.
• OLAP applications are widely used by Data Mining techniques.
• In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).

It is a helpful link..

http://datawarehouse4u.info/OLTP-vs-OLAP.html