上学吧考试云平台
题库首页计算机类微软认证网络工程师考试辅导微软认证70-228模拟试卷9

微软认证70-228模拟试卷9

推荐等级:
  • 卷面总分:0分
  • 试卷类型:模拟试题
  • 测试费用:免费
  • 答案解析:有
  • 练习次数:10次
  • 作答时间:30分钟
  • 进入考试
  • 下载试卷
  • APP做题
  • 关注人数:2397

试卷简介

题型:

  • 1.单选题
会员专享

考点练习

快速练习

历年真题

试卷预览
1

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. Users report that several storage locations in the UnitsStored field contain negative numbers. You examine the database's table structure. The table properties are configured as shown in the exhibit.

You correct all the negative numbers in the table. You must prevent the database from storing negative numbers. You also want to minimize use of server resources and physical I/O.

Which transact-SQL statement should you execute?

A.ALTER TABLE dbo.storagelocations ADD CONSTRAINTS CK_storagelocations_UnitsStored CHECK (UnitsStored>= 0)

B.CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED, UnitsStored< 0 ROLLBACK TRAN

C.CREATE TABLE ck_unitsstored As @Units >= 0 GO Sp_bindrule ‘OK_UnitsStored’, ‘StorageLocations, UnitsStored’ GO

D.CREATE PROC UpdateUnitsStored (StorageLocationID int, @UnitsStored bigint)AS IF @UnitsStored< 0 DATSERROR (50099, 17) ELSE UPDATE storaheLocations SET UnitsStored = @UnitsStored WHERE StorageLocationID = @storageLocationID

2

You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. You perform. full database backups every two days. You also run regular database consistency checks on the server. The most recent check of the Sales database returns the following message.

“CHECKDB found 0 allocation errors and 9 consistency errors in the table 'Orders' (object ID 214575782).”

You want to correct the data integrity errors while minimizing the amount of data lost. What should you do?

A.Disconnect users from the Sales database. Enable the single user database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.

B.Disconnect users from the Sales database. Enable the DBO use only database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.

C.Disconnect users from the Sales database. Execute the RESTORE DATABASE statement for the Sales database

D.Execute the DBCC CLEANTABLE statement for the Orders table.

E.Execute the sp_table_validation stored procedure for the Orders table.

3

You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.

The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.

You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.

You want to enable the server in Sydney to connect to the mainframe. database. What should you do?

A.Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.

B.Modify the workflow in the DTS package so that the server in Sydney is included.

C.On the server in Sydney, install an OLE DB provider for the mainframe. database.

D.On the server in Sydney, delete and then re-create the DTS package.

4

You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.

A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors.

You want to ensure that the journalists can query the database. What should you do?

A.Create a new full-text catalog for the Articles database

B.Rebuild the full-text catalog for the Articles database

C.Create a new full-text index on the table that holds the text for the articles

D.Repopulate the full-text index on the table that holds the text for the articles

试卷评价(5条)

00****36   2013-12-17 15:12:42
题目挺多,希望可以给我的考试增加成功率。
00****46   2013-07-03 00:32:03
通过测试,发现自己还需要好好看教材和多做练习题
00****60   2013-03-26 05:44:15
不错,较全面,深度不算深
00****90   2013-03-09 05:46:17
试题质量还有待提高
00****20   2012-11-30 10:58:30
看起来不错,希望对我的考试有帮助。

其他考生还关注了这些

扫码免费做题
联系客服
APP下载
手机验证
温馨提示:输入手机号码获取验证码,验证后即测试该试卷。
图文验证:看不清?点击更换 换一换
手机号码:

下载试卷

收藏试题

此试题已成功加入收藏夹!

关闭窗口查看我的收藏夹
下载试卷
广告
上学吧找答案神器,懒人考试必备神器