IBM C2090-610 - DB2 10.1 Fundamentals Exam
Page: 1 / 28
Total 136 questions
Question #1 (Topic: Topic 1)
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
Question #2 (Topic: Topic 1)
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
Question #3 (Topic: Topic 1)
Which operation normally does NOT require an exclusivelock?
A. BIND
B. DROP
C. GRANT
D. SELECT
Answer: D
Question #4 (Topic: Topic 1)
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
Question #5 (Topic: Topic 1)
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
