单项选择题
You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers, in its current configuration, can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used?()
A.SQL3 with the OnlineReadOnly and HR databases
B.SQL4 with the TravelOnline and Storefront databases
C.SQL2 with the Storefront and TravelOnline databases
D.SQL2 with the Storefront and HR databases
点击查看答案
相关考题
-
单项选择题
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()
A.create a hash cluster to store the data
B.create an index cluster to store the data
C.create a partitioned table to store the data
D.create a sorted hash cluster to store the data
E.create a heap table with rowid to store the data -
多项选择题
需要在备忘录中记录的问题有()。
A.不合理的现象
B.不均匀的地方
C.不节省的环节
D.不安全的工艺
E.不明白的操作 -
单项选择题
Inyourdatawarehousingapplication,yougeneratereportsfrequently.Thedataisstaticinthetablesbeingusedtogeneratereports.Youarecurrentlyusingjoins,resultinginalargeperformanceoverhead.Whatkindofdatabasestructurewouldyouusetoreducetheresponsetimeofthequery?()
A.hash clusters
B.index clusters
C.partitioned tables
D.indexorganized table (IOT)
