Asked by ava
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
- strong data integrity — Yes. SQL databases provide ACID transactions, constraints, foreign keys and schema enforcement that help ensure strong data integrity.
- limitless indexing — No. Indexing has costs and practical limits (write overhead, storage, and query trade-offs).
- works well with distributed data — Not generally. Traditional SQL/RDBMS are not inherently designed for distributed/partitioned data (though some modern distributed SQL systems do address this).
- horizontal scaling — No (not by default). Relational databases typically scale vertically; horizontal scaling (sharding/scale-out) is possible but complex and not an inherent SQL benefit.
- limitless indexing — No. Indexing has costs and practical limits (write overhead, storage, and query trade-offs).
- works well with distributed data — Not generally. Traditional SQL/RDBMS are not inherently designed for distributed/partitioned data (though some modern distributed SQL systems do address this).
- horizontal scaling — No (not by default). Relational databases typically scale vertically; horizontal scaling (sharding/scale-out) is possible but complex and not an inherent SQL benefit.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.