Which of the Following Is True About Indexes and Index

question 25

Multiple Choice

Which of the following is true about indexes and index design?

• A)indexes should be created on columns used by WHERE and BY clauses
• B)a composite index is an index on a single column
• C)an index is created for every foreign key by default
• D)indexes usually speed up write operations

---

Definitions:

Abdominal

Pertaining to the abdomen, the body region that contains the primary organs of the digestive system.

Thoracic

Pertaining to the thorax, or chest region, which houses the heart and lungs among other vital organs.

Dorsal

Relating to the back or posterior part of an organism in contrast to the ventral, or front, side.

Mediastinum

The central compartment of the thoracic cavity, located between the lungs, containing the heart, thymus, esophagus, trachea, and major blood vessels.