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:

Essentialist Idea

The belief that certain phenomena are naturally and fundamentally determined by intrinsic properties rather than constructed or variable.

Gender

The physical, behavioral, and personality traits that a group considers normal for its male and female members.

Social Construction

A concept or perception that has been created and accepted by the members of a society through cultural or social practice.

Constructionist Perspective

A theoretical viewpoint that suggests knowledge and reality are not inherently natural but are constructed through social processes and interactions.