Companyxyz.com has two SQL Server 2005 computers named SQL1 and SQL2. A database
named DB1 is located on SQL1. DB1 contains a table named Companyxyz4. Companyxyz4 is
replicated to a database named DB1Repl, which is located on SQL2. Full-Text Search is not
being used. Users report that the queries they run against Companyxyz4 in DB1Repl are very
slow. You investigate and discover that only the clustered index of Companyxyz4 is replicated. All
other indexes in DB1Repl are missing. You examine the Companyxyz4 article properties. The
current Companyxyz4 article properties are shown in the exhibit. You need to change the article
properties so that all indexes of Companyxyz4 in DB1 are replicated when the subscription is
reinitialized. Which two article properties should you change? (Each correct answer presents part
of the solution. Choose two.) 这个怎么翻译好呀,我翻译半天,都不太通,大家帮看看A. Copy clustered index
B. Copy nonclustered indexes
C. Copy extended properties
D. Copy unique key constraints
E. Copy index partitioning schemes
F. Copy XML indexes 还有,答案应该有F吗??为什么?
named DB1 is located on SQL1. DB1 contains a table named Companyxyz4. Companyxyz4 is
replicated to a database named DB1Repl, which is located on SQL2. Full-Text Search is not
being used. Users report that the queries they run against Companyxyz4 in DB1Repl are very
slow. You investigate and discover that only the clustered index of Companyxyz4 is replicated. All
other indexes in DB1Repl are missing. You examine the Companyxyz4 article properties. The
current Companyxyz4 article properties are shown in the exhibit. You need to change the article
properties so that all indexes of Companyxyz4 in DB1 are replicated when the subscription is
reinitialized. Which two article properties should you change? (Each correct answer presents part
of the solution. Choose two.) 这个怎么翻译好呀,我翻译半天,都不太通,大家帮看看A. Copy clustered index
B. Copy nonclustered indexes
C. Copy extended properties
D. Copy unique key constraints
E. Copy index partitioning schemes
F. Copy XML indexes 还有,答案应该有F吗??为什么?
解决方案 »
- 哪里有可在XP下使用的SQL2005下载?
- 深入分析SQL Server 表的主键(上)
- SQL 郁闷的问题。。。
- sql 2005 Report Builder如何运行?
- sqlplus在命令行上删除当前的输入
- 又一个逻辑问题:外键约束
- 新手提问:表与表之间关联问题,谢谢回答~分不够再加~
- 在select 语句中,表名是个变量行不行???
- 怪现象,请高手解决?
- 我的网站被黑了,网站内尽是:“</title></pre>><script src=http://sb.5252.ws:88/107/1.js></script><”,网页内容都没了,请教怎么处理,谢谢!
- 请教个分隔字符的语句
- 怎么样才能给SQL SERVER 2005 新开一个单独的帐户
答案是B,F
默认非聚集索引跟XML索引是不被拷贝的