Multiple choice technology databases

What are some benefits of using a USI?

  1. They eliminate Full Table Scans.

  2. Duplicate row checks are avoided.

  3. There is no overhead involved.

  4. They are best used for range queries.

  5. You cannot insert rows with a duplicate USI value.
Reveal answer Fill a bubble to check yourself
A,B,E Correct answer
Explanation

USI indexes eliminate full‑table scans, avoid duplicate‑row checks, and enforce uniqueness, preventing insertion of duplicate values. These three benefits are accurately marked as correct; the other choices either claim nonexistent overhead elimination or misuse of range queries, which are incorrect.

Keep practicing — related questions