Which of the Following Is True About the Database Engine

question 40

Multiple Choice

Which of the following is true about the Database Engine Tuning Advisor?

• A)the administrator must have detailed knowledge of the database schema to use it
• B)performance gains of less than 25% should be discounted
• C)it quantifies the expected performance gains for each recommendation
• D)it uses a different set of data than the query optimizer

---

Definitions:

Religion

A set of beliefs concerning the cause, nature, and purpose of the universe, often involving ritual observances and a moral code.

Spirituality

The quality or state of being concerned with religion or religious matters; the pursuit of personal, ethical, emotional, and intellectual growth.

Individual Level

A perspective that focuses on characteristics, behaviors, or outcomes pertaining to individual persons, as opposed to groups or populations.

Collectivity

A principle or practice where people come together and prioritize shared goals or common interests over individual desires.