IBM
C2090-558 · Question #23
What are two ways to create table t1 with row level locking? (Choose two.)
The correct answer is C. Execute the command "create table t1 (c1 int) lock mode row". D. Set DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)". See the full explanation below for the reasoning.
Question
What are two ways to create table t1 with row level locking? (Choose two.)
Options
- AExecute the command "create table t1 (c1 int) locking row".
- BExecute the command "create table t1 (c1 int) lock level row".
- CExecute the command "create table t1 (c1 int) lock mode row".
- DSet DEF_TABLE_LOCKMODE to ROW in ONCONFIG before executing "create table t1(c1 int)".
- ESet the environment variable DEF_TABLE_LOCKMODE to ROW before executing "create table
How the community answered
(19 responses)- A16% (3)
- B5% (1)
- C74% (14)
- E5% (1)
Community Discussion
No community discussion yet for this question.