What happens when a row is inserted into a list partitioned table but the key value is not within the list?
A. The row is inserted into the last partition.
B. The insert fails with an error message.
C. The row is inserted into the first partition.
D. The insert is discarded without an error message.
正解:B
質問 2:
Based on the command "dump database pubs2 to pubs2.dmp with compression = 6", which commands could be used to load it? (Choose two.)
A. load database pubs2 from "pubs2.dmp"
B. load database pubs2 from "compress::6::pubs2.dmp"
C. load database pubs2 from "pubs2.dmp" with compression level 6
D. load database pubs2 from "pubs2.dmp" with compression = 6
E. load database pubs2 from "pubs2.dmp" with compression
正解:A,D
質問 3:
How large can a table, column and index name be?
A. 128 bytes
B. 32 bytes
C. 255 bytes
D. 64 bytes
正解:C
質問 4:
Which of the following commands allow you to specify the partition? (Choose three.)
A. update statistics
B. insert
C. truncate table
D. reorg rebuild tablename
E. bcp in
正解:A,C,E
質問 5:
Given that the following commands are successfully executed:
use mydb go select * into #myusers from sysusers go
In which database does #myusers exist?
A. model
B. mydb
C. tempdb
D. master
正解:C
質問 6:
Which commands can be used to specify the number of histogram steps in systatistics? (Choose two.)
A. update statistics
B. create index
C. sp_modifystats
D. reorg
E. optdiag
正解:A,B
町田** -
Pass4Testの問題集の新鮮のところは、図解を豊富に取り入れて、知識を整理できるように工夫しています。