Huawei Certified ICT Professional – Storage v5.5 (HCIP-Storage) — Question 19

OLTP is a major application in a traditional relational database and mainly used to process basic and routine transactions. Which of the following statements is false about OLTP?

Answer options

• A. From the database perspective, reading, writing, and changing of each transaction involve a small amount of data, and access requests from many users are processed simultaneously.
• B. From the storage perspective, data is usually read in sequence, and data of write operations is stored in the temporary tablespace when read operations are being performed.
• C. In the OLTP service, the back-end port bandwidth does not need to be monitored.
• D. In the OLTP service, special attention is usually required for the average I/O response time and average CPU usage of controllers.

Correct answer: C

Explanation

The statement marked as C is false because monitoring back-end port bandwidth is crucial in an OLTP environment to ensure performance and reliability. The other statements are true, as they accurately describe the characteristics of OLTP transactions and their data handling processes.