Which of the Following Is True About Indexes in SQL

question 88

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.

---

Definitions:

Trade

The act of buying, selling, or exchanging goods and services between people or countries.

Domestic Price

The price of a good or service within a country's borders.

Domestic Consumption

The total amount of goods and services consumed within a country's borders.

Consumer Surplus

The difference between the total amount that consumers are willing to pay for a good or service and the total amount they actually pay.