A

Arogya • 3.19K Points
Extraordinary

Q. You must automatically generate a primary key using a sequence while inserting rows. What is the best approach?

  • (A) Procedure
  • (B) Before Insert Trigger
  • (C) After Insert Trigger
  • (D) Cursor
Explanation by: Arogya
BEFORE INSERT trigger assigns sequence value to :NEW.id before record is saved.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.