IBM C2090-610 - DB2 10.1 Fundamentals Exam

Page:    1 / 28   
Total 136 questions

Which statement is true regarding constraints?

  • A. A table can only have one unique key constraint.
  • B. A table can have multiple primary key constraints.
  • C. Informational constraints tell DB2 what rules the data conforms to,but the rules are not enforced.
  • D. Foreign key constraints are enforced on the values within the rows of a table, or between the rows of two tables, by a unique index on a foreign key.


Answer : C

If a user has been granted SYSCTRL authority, which activities can they perform?

  • A. Load operations
  • B. Backup/copy table spaces
  • C. Create and drop databases
  • D. Monitordatabase performance


Answer : C

Which operation normally does NOT require an exclusivelock?

  • A. BIND
  • B. DROP
  • C. GRANT
  • D. SELECT


Answer : D

Which statement about BEFORE triggers is FALSE?

  • A. A BEFORE trigger can be used to perform validation of input data.
  • B. A BEFORE trigger can be used to automatically generate values for newly inserted rows.
  • C. A BEFORE trigger is fired for each row in the set of affected rows before the trigger event executes.
  • D. A BEFORE trigger is fired for each row in the set of affected rows instead of executing the trigger event.


Answer : D

Which statement regarding triggersis true?

  • A. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.
  • B. Triggers cannot be modified, they must be dropped and recreated with new definitions.
  • C. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.
  • D. Triggers can only be fired one time per statement irrespective of the number of rows affected.


Answer : B

Page:    1 / 28   
Total 136 questions