Which of the Following Is True About Indexes in SQL

Multiple Choice

Which of the following is true about indexes in SQL Server?

A) SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries.
B) SQL Server pads all indexes.
C) SQL Server supports filling up to a limit of 70 percent.
D) SQL Server automatically creates indexes for foreign keys.
E) All of the above.