Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and consistently when there are multiple applications and developers?

Question

Accepted Answer

A. Use a trigger.

Answer

B. Create a foreign key.

Answer

C. Use a nightly batch process.

Answer

D. Define a task in the sysadmin database.

Business rules require that every time a row in table A is updated in your OLTP database, a row in table B must also be updated. How can you guarantee this rule will be maintained correctly and…

Question

Options

How the community answered

Community Discussion