Asked by ava
multiple choice 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 only.
- Strong data integrity — Yes. SQL/RDBMS provide ACID transactions, constraints, and referential integrity.
- Limitless indexing — No. Indexes improve performance but incur storage and write overhead and practical limits.
- Works well with distributed data — Generally no. Traditional SQL systems are designed for centralized deployments; distributed setups need special architectures.
- Horizontal scaling — Generally no. Relational DBs typically scale vertically; horizontal scaling (sharding/distributed SQL) is possible but complex and not an inherent SQL benefit (though some modern distributed SQL systems do provide it).
- Strong data integrity — Yes. SQL/RDBMS provide ACID transactions, constraints, and referential integrity.
- Limitless indexing — No. Indexes improve performance but incur storage and write overhead and practical limits.
- Works well with distributed data — Generally no. Traditional SQL systems are designed for centralized deployments; distributed setups need special architectures.
- Horizontal scaling — Generally no. Relational DBs typically scale vertically; horizontal scaling (sharding/distributed SQL) is possible but complex and not an inherent SQL benefit (though some modern distributed SQL systems do provide it).
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.