1.Which commands can be used to specify the number of histogram steps in systatistics?
A. create index B. optdiag C. update statistics D. reorg E. sp_modifystats
----explain create index可以通过with statistics using num_steps values来指定步长(梯级数),update statistics可以通过using step values来指定步长(梯级数)
2.What are the partition strategies that allow you to addpartitions using alter table? (Choose 2)
A.hash B.list C.range D.roundobin
--explan 仅有范围(range)和列表(list)分区可以增加分区
3.Cursors can now be declared as which of the following?
A. Scrollable B. forward_only C. Backward_only D. non-scrollable E. Insensitive F. semi-sensitive
--explain 声明游标可以通过insensitive和semi_sensitive来指定敏感性(即基础表的更改在游标的使用过程中影响不影响结果集) 可以通过scroll和 no scroll来指定游标是否滚动, 默认为不滚动。不滚动则一行一行顺序获取结果集,滚动则可以通过在 fetch 语句中指定选项 first、last、absolute、next、prior 或 relative,将游标位置设置到游标结果集中的任何位置
4.Which alter table clause will change an APL table to allow row level locking?
A. Lockdatarows B. lock datapages C. lock allpages D. withfillfactor = 1
--explain ASE锁类型 APL(allpage lock)全页锁、 DPL(datapage lock) 页锁和DOL(data only lock)行锁
5.Which of the following are true about using the load databasecommand?(Choose 3)
A. the database must be at least as large as the size of the database dump
B. the database must have been created with the for load option
C. the database must be exactly the same size as the database dump
D. the database must not be in use
E. the database need not exist because load database will create the database
F. The database must not be marked as suspect
--explain:load database 命令会让数据库状态变为脱机,在完成后发出online命令之前,所有人不能使用。load可以在for load数据库进行,也可以在正常数据库进行。经常由于非正常关机等导致数据库成为suspect状态,此时数据库不能被打开,需用dbcc dbrepair或其他方式修复后才能应用
6.Given that thefollowing set of commands are executed in a 2k serve