Multiple choice technology databases

DB2 Indexes i ) Unique Index can be created only on Primary Key. ii) Query will execute faster if predicates are applied on Indexed column.

  1. Both are True

  2. i) Is Only True

  3. ii) is only True

  4. Neither is True
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Statement i is false because unique indexes can be created on any column or combination of columns that require uniqueness, not exclusively on primary keys. Statement ii is true because indexes allow the database engine to locate rows quickly when predicates are applied to indexed columns.

Keep practicing — related questions