Which statement about multiple OLTP databases in an organisation is NOT true?

Question

BlackTom AI · Accepted Answer

OLTP systems process high-volume, real-time transactional activity and keep operational data current. When an organisation has multiple OLTP databases, there is no automatic guarantee that those databases are synchronized or governed by the same rules, schemas or update timing.

Relevant concepts:
- OLTP (Online Transaction Processing): optimized for transactions, often ensuring ACID properties within a single database instance.
- Data silos and integration: separate systems can produce different “views” of the same business entities.
- Data quality dimensions: accuracy, completeness and consistency can be violated across systems without integration or master data management.

Step-by-step reasoning:
1. Option: "Multiple OLTP databases ... created separate views of the business data." True — different applications (e.g., CRM, ERP, billing) model business entities differently, producing distinct views tailored to each function.
2. Option: "May result in duplicated and inaccessible data ... sometimes within a line of business." True — without consolidation, the same customer or product may be stored multiple times and may be hard to access across teams.
3. Option: "Could come from different vendor databases (Oracle, Microsoft, IBM)." True — organisations commonly run heterogeneous database platforms for historical, cost or functional reasons.
4. Option: "Always store data that is accurate, complete and consistent." This is NOT true. The word “always” is decisive: ACID guarantees apply per database instance, but accuracy/completeness/consistency across multiple OLTP systems require deliberate integration, reconciliation, and governance (e.g., ETL, master data management, replication). In practice, divergent update frequencies, business rules, schema mismatches and human entry errors lead to inconsistent or incomplete data across systems.

Why the correct answer is correct:
Because multiple OLTPs do not automatically ensure cross-system data quality; claiming they “always” store accurate, complete and consistent data is false.

Why the other options are not correct answers:
They describe plausible and common consequences of multiple OLTPs (separate views, duplication/inaccessibility, vendor heterogeneity), so they are true statements and therefore not the “NOT true” choice.

Conclusion: The statement that is NOT true is "Multiple OLTP databases in an organisation always store data that is accurate, complete and consistent," which matches the provided answer.

Which statement about multiple OLTP databases in an organisation is NOT true?单项选择题

类似问题

You own a bond that pays $64 in interest annually. The face value is $1,000 and the current market price is $1,021.61. The bond matures in 11 years. What is the yield to maturity?

Which of the following statements is CORRECT?

It will cost $9,600 to acquire an ice cream cart that is expected to produce cash inflows of $3,600 a year for three years. After the three years, the cart is expected to be worthless. What is the payback period?

A 3.25 percent Treasury bond is quoted at a price of 99.04. The bond pays interest semiannually. What is the current yield?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单