Question

choose the correct options SQL provides which of the following benefits? (Choose all that apply)


strong data integrity


limitless indexing


works well with distributed data


horizontal scaling

Answer 1

Correct answer: strong data integrity

Explanations:
- Strong data integrity — Yes. Relational SQL databases provide ACID transactions, schemas, constraints and foreign keys that enforce data correctness.
- Limitless indexing — No. Indexes are powerful but incur storage and write-performance costs; they are not unlimited.
- Works well with distributed data — Generally no. Traditional RDBMSs are not designed for wide distribution/partitioning (though modern distributed SQL systems exist, this is not a native SQL benefit).
- Horizontal scaling — Generally no. Relational databases are typically easier to scale vertically; horizontal scaling (sharding) is more complex.