A

Arogya • 3.49K Points
Extraordinary

Q. You need to prevent employees from inserting salary greater than 100000 in EMP table automatically. What should you use?

  • (A) Check Constraint
  • (B) Before Insert Trigger
  • (C) After Insert Trigger
  • (D) Procedure

Explanation by: Arogya

A BEFORE INSERT trigger can validate the salary and raise an exception before data is inserted.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.