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:

Humane Setting

An environment that ensures the well-being and ethical treatment of all individuals.

Long-Term Care

A variety of services designed to meet a person's health or personal care needs during a short or long period of time.

Individual Choice

The freedom or ability of an individual to make decisions based on personal preferences, desires, or beliefs.

Privacy

The right or condition of being free from unauthorized intrusion or disclosure of personal information.