Which of the Following Is True About Indexes and Index

Multiple Choice

Which of the following is true about indexes and index design?

A) indexes should be created on columns used by WHERE and BY clauses
B) a composite index is an index on a single column
C) an index is created for every foreign key by default
D) indexes usually speed up write operations