Which of the Following Is True About Indexes in SQL

question 33

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.

---

Definitions:

Increase Spending

A policy or action that leads to a higher level of expenditure by individuals, businesses, or the government to stimulate economic activity.

Depression

A prolonged period of significant economic downturn, marked by high unemployment, low output, and declining prices.

Aggregate Demand

The cumulative demand for goods and services within an economy, reflecting the total spendable money available at various price points.

Government Economic Policy

The strategies and measures employed by a government to manage its economy, including taxation, spending, and interest rate settings.