Multiple choice technology databases

Which of the following statement is true?

  1. a table is an ordered set of data records

  2. an index always accesses data in ascending order

  3. a view stores the data on a different tablespace

  4. an index can be used to enforce uniqueness in a table

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Indexes can enforce uniqueness via unique constraints, ensuring no duplicate values. Tables are unordered sets (ordered only via ORDER BY), indexes can be ascending or descending, and views are virtual tables storing no data themselves (queries run on demand).