Which Statement About Triggers Is Correct

question 20

Multiple Choice

Which statement about triggers is correct?

• A) In a trigger, the action that should cause the procedure to execute appears between BEGIN and END commands.
• B) In SQL Server, you create triggers using T-SQL.
• C) In a trigger, the actions the database should perform automatically appear in the AFTER clause.
• D) In Oracle, you cannot create triggers.

---

Definitions:

Deadweight Losses

Economic inefficiencies that arise when market equilibrium is not achieved, often resulting from monopolies, taxes, subsidies, or price controls, leading to lost welfare for consumers or producers.

X-inefficiency

The difference between efficient behavior of businesses under competitive environments versus the inefficiency that arises in the absence of competition.

Competitive Firms

Companies that operate in markets where no single firm has the power to influence the price of goods and services significantly.

Monopolistic Firms

Companies that have significant control over the market for a particular good or service, allowing them to influence price and production levels.