Multiple choice technology databases

What database object is used to increase performance for accessing data within a database?

  1. Roles

  2. Sequences

  3. Synonyms

  4. Index
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

An index is a database object specifically designed to improve query performance by creating a data structure that allows faster data retrieval without scanning the entire table. Roles manage security permissions, sequences generate unique numeric values, and synonyms provide alternate names for objects.

Keep practicing — related questions