IBM
C2090-558 · Question #59
Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)
The correct answer is A. create table t1 (c1 int) D. create table t1 (c1 int) lock mode page. See the full explanation below for the reasoning.
Question
Which two commands would create a table t1 with page level locking assuming default configuration parameter settings? (Choose two.)
Options
- Acreate table t1 (c1 int)
- Bcreate table t1 (c1 int) locking page
- Ccreate table t1 (c1 int) lock level page
- Dcreate table t1 (c1 int) lock mode page
- Ecreate table t1 (c1 int) locking mode page
How the community answered
(22 responses)- A82% (18)
- B9% (2)
- C5% (1)
- E5% (1)
Community Discussion
No community discussion yet for this question.