QUESTION: 1
Which commands can be used to specify the number of histogram steps in systatistics?
(Choose 2)
A. create index
B. optdiag
C. update statistics
D. reorg
E. sp_modifystats
Answer(s): A, C
QUESTION: 2
What are the partition strategies that allow you to add partitions using alter table?
(Choose 2)
A. hash
B. list
C. range
D. round obin
Answer(s): B, C
QUESTION: 3
Cursors can now be declared as which of the following? (Choose 4)
A. scrollable
B. forward_only
C. backward_only
D. non-scrollable
E. insensitive
F. semi-sensitive
Answer(s): A, D, E, F
QUESTION: 4
Which alter table clause wil change an APL table to allow row level locking?
A. lock datarows
B. lock datapages
C. lock allpages
D. with fil factor = 1
Answer(s): A
QUESTION: 5
2