A Command Used in Oracle to Display How the Query

question 115

Multiple Choice

A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the:

• A) explain plan.
• B) show optimization.
• C) explain query.
• D) analyze query.

---

Definitions:

Self-Serving Bias

The tendency to view one’s successes as stemming from internal factors and one’s failures as stemming from external factors.

Sternberg's Triangular Model

A theory of love suggesting that intimacy, passion, and commitment are the three components that define all human love relationships.

Amygdala

A part of the limbic system that apparently facilitates stereotypical aggressive responses.

Aggressive Reactions

Responses characterized by anger or hostility, often as a result of provocation or frustration.