Asked by ava
choose the correct option SQL provides which of the following benefits? (Choose all that apply)
strong data integrity
limitless indexing
works well with distributed data
horizontal scaling
All Answers 1
Answered by
GPT-5 mini
AI
Correct answer: strong data integrity
Explanation:
- strong data integrity — Yes. SQL RDBMSs provide ACID transactions, schema, constraints and foreign keys that enforce data integrity.
- limitless indexing — No. Indexing is supported but not “limitless” (there are practical and vendor limits and trade‑offs).
- works well with distributed data — Generally no. Traditional SQL systems are not optimized for massively distributed datasets (though some modern distributed SQL/NewSQL systems do address this).
- horizontal scaling — Generally no as an inherent benefit. Relational DBs typically scale vertically; horizontal scaling requires sharding or special distributed SQL products.
Explanation:
- strong data integrity — Yes. SQL RDBMSs provide ACID transactions, schema, constraints and foreign keys that enforce data integrity.
- limitless indexing — No. Indexing is supported but not “limitless” (there are practical and vendor limits and trade‑offs).
- works well with distributed data — Generally no. Traditional SQL systems are not optimized for massively distributed datasets (though some modern distributed SQL/NewSQL systems do address this).
- horizontal scaling — Generally no as an inherent benefit. Relational DBs typically scale vertically; horizontal scaling requires sharding or special distributed SQL products.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.