Question

which of the following is a key feature of a transactional database? a.) this type of database is used to analyze massive volumes of data. b.) this type of database is optimized to execute a small number of complex queries. c.) this type of database uses insert, update, and delete statements quickly. d.) this type of database is often denormalized with a focus on performance.

Answer 1

A transactional database's key feature is its ability to quickly execute insert, update, and delete operations, ensuring ACID properties for reliable transaction processing. The key feature of a transactional database is c.) this type of database uses insert, update, and delete statements quickly.

Step-by-step explanation:

Transactional databases are specifically optimized for OLTP (Online Transaction Processing) operations, which means they are designed to efficiently manage write-heavy workloads where data is frequently inserted, updated, or deleted. These databases ensure the ACID properties (Atomicity, Consistency, Isolation, Durability) to provide a reliable environment where transactions are processed safely and independently, preventing data corruption and ensuring data integrity in concurrent access scenarios.