Author:

(A) A system file
(B) Log file
(C) Data dictionary
(D) Metadata

(A) Index can be defined even when there is no data in the table
(B) It can be created using ‘Create Index’ statement
(C) It support Range selections
(D) It can not be created on composite attributes

(A) Multiple indexes for the same key can not be set
(B) It will increase complexity as the access time will be increased
(C) It increases efficiency
(D) It decreases efficiency