Which of the Following Is a Guideline to Follow That

question 28

Multiple Choice

Which of the following is a guideline to follow that can help you avoid blocking locks and deadlocks?

• A)use queries that perform multiple locks
• B)use random sequences to perform multiple-table updates
• C)use clustered indexes for frequently accessed tables
• D)use a single query to modify a large number of rows, if possible

---

Definitions:

Chemoreceptors

Sensory receptors in the body that respond to chemical stimuli, involved in processes like taste, smell, and internal bodily responses.

Odorants

Molecules that are detected by the olfactory system, leading to the perception of smells.

Thermoreceptors

Sensory nerve cells that respond to changes in temperature, enabling an organism to sense cold or warmth.

Temperature Extremes

Conditions where the environment experiences very high or very low temperatures, beyond the normal range most organisms can comfortably survive in.