Given below are two statements: one is labelled as Assertion A and the other…

2026

Given below are two statements: one is labelled as Assertion A and the other is labelled as Reason R.

Assertion A: OLAP systems are optimized for complex queries and analysis.

Reason R: OLTP systems are designed for transactions processing with large read-only queries.

In the light of the above statements, choose the most appropriate answer from the options given below:

  1. Both A and R are correct and R is the correct explanation of A

  2. Both A and R are correct but R is NOT the correct explanation of A

  3. A is correct but R is not correct

  4. A is not correct but R is correct

  1. A.

    1

  2. B.

    2

  3. C.

    3

  4. D.

    4

Attempted by 676 students.

Show answer & explanation

Correct answer: C

Assertion A is correct: OLAP (Online Analytical Processing) systems are designed for complex queries and data analysis. Reason R is incorrect: OLTP (Online Transaction Processing) systems handle transactional processing with short, frequent operations like inserts and updates, not large read-only queries. Therefore, A is correct but R is not.

Explore the full course: Mppsc Assistant Professor