CompTIA
DA0-001 · Question #469
Which of the following database types is the best to use for transactional SQL?
The correct answer is C. Relational. Relational databases are best suited for transactional SQL because they efficiently handle structured data and support ACID properties needed for transactions.
Data Concepts and Environments
Question
Which of the following database types is the best to use for transactional SQL?
Options
- ASnowflake schema
- BHierarchical
- CRelational
- DStar schema
How the community answered
(24 responses)- B8% (2)
- C88% (21)
- D4% (1)
Explanation
Relational databases are best suited for transactional SQL because they efficiently handle structured data and support ACID properties needed for transactions.
Topics
#Database types#Relational databases#Transactional SQL#OLTP
Community Discussion
No community discussion yet for this question.