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:

Full Retirement Age

Age at which a person receives full retirement Social Security benefits.

IRA

An Individual Retirement Account, a saving tool that allows individuals to set aside money for retirement with tax advantages.

401k

A retirement savings plan that is sponsored and set up by an employer for its employees; like other retirement plans, there are strict rules as to when the money can be withdrawn without a penalty and strict contribution limits which change from year to year.

Mortality Table

A statistical table showing the probability of death for each age, used primarily by insurance companies to determine premiums.