C2090-616

C2090-616 practice questions, page 3 of 3, with answer review and explanations.

Question 11

Which of the following statements about triggers are TRUE? (Choose two.)

  1. There is a limit of 8 for the maximum number of cascading trigger activations
  2. Triggers can be activated as a result of changes due to referential constraint enforcement
  3. Multiple INSTEAD OF triggers are allowed for each kind of operation on a given subject view
  4. Constraints associated with a subject table are applied between execution of BEFORE and AFTER triggers
  5. The activation of the triggers for a particular table, event and activation time are conducted in descending order of trigger creation time

Question 12

Which of the following is TRUE about indexes on column organized tables?

  1. No indexes are allowed
  2. Indexes are only allowed on numeric columns
  3. Indexes are automatically created to enforce unique constraints
  4. An index is only allowed on the synopsis table supporting a column organized table