题目内容

You work for a bank that uses a SQL Server 2005 database to store line items from customer banking transactions. The bank processes 50,000 transactions every day. The application requires a clustered index on the TransactionID column. You need to create a table that supports an efficient reporting solution that queries the transactions by date. What are the two ways to achieve this goal?()

A. Place a nonclustered index on the date column.
B. Add a unique clustered index on the date column.
C. Map each partition to a filegroup, with each filegroup accessing a different physical drive.
D. Create a partitioning scheme that partitions the data by date.

查看答案
更多问题

丰收贷记卡按发行对象不同分为单位卡和()。

A. 联名卡
B. 金卡
C. 普卡
D. 个人卡

亲子关系通常被分为三种类型:民主型、专制型和()。

A. 放任型
B. 溺爱型
C. 保护型
D. 包办型

JX-300XP系统回路的“P、I、D参数”是在()中调节的。

A. 调整画面
B. 该回路位号的调整画面
C. 分组画面
D. 总貌画面

邮储信用卡可以在网点柜面办理的业务()。

A. 提现
B. 存款
C. 挂失
D. 加办自动还款

答案查题题库