Which of the following is NOT a characteristic of an OLTP database?

  1. Granular transactions

  2. Current data

  3. Optimized for queries

  4. Frequent updates


Correct Option: C
Explanation:

To solve this question, the user needs to have an understanding of OLTP (Online Transaction Processing) databases and their characteristics.

Now, let's go through each option and explain why it is right or wrong:

A. Granular transactions: This is a characteristic of OLTP databases. OLTP databases are designed to handle small, granular transactions that involve the insertion, deletion, or modification of individual records in real-time.

B. Current data: This is also a characteristic of OLTP databases. OLTP databases are optimized for real-time data processing and are designed to handle the most up-to-date information.

C. Optimized for queries: This is NOT a characteristic of OLTP databases. OLTP databases are optimized for transaction processing, not for complex queries or data analysis.

D. Frequent updates: This is a characteristic of OLTP databases. OLTP databases are designed to handle frequent updates to individual records in real-time.

Therefore, the correct answer is:

The Answer is: C

Find more quizzes: