A surrogate key may be appropriate under which of the following circumstances?
A) The available candidate keys would produce a lot of data duplication when representing relationships.
B) The primary key is numeric.
C) The available candidate keys would be prone to typographical errors.
D) The available candidate keys have little meaning to the users.
E) Both A and C
Question 2
Which of the following is not an SQL trigger?
A) BEFORE UPDATE
B) INSTEAD OF UPDATE
C) BEFORE INSERT
D) INSTEAD OF CONSTRAINT
E) AFTER DELETE
