首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which y
You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which y
admin
2009-05-19
18
问题
You are the administrator of a SQL Server 2000 computer. The server contains confidential information about contracts on which your company has placed bids.
Company policy requires that bid information be removed permanently from the database one year after the bid closes. You need to comply with this policy and minimize server overhead.
What should you do?
选项
A、Create a Data Transformation Services (DTS) package to remove bids that have a closing data older than one year.
B、Create a trigger to delete any bids that have a closing data older than one year. Bind the trigger to the bids table for all INSERT, UPDATE, and DELETE events.
C、Create a stored procedure to delete any bids that have a closing data order than one year. Use SQL server agent to schedule the stored procedure to run every night.
D、Create a view that contains a WHERE clause to exclude bids that have a closing date older than one year.
答案
C
解析
Explanation: This scenario requires us to remove old information on a regular basis. First we create a stored procedure which removes all rows where the bid information date is older than the current date minus one year. Then we schedule this procedure to run every day. We would then be sure to never have any rows older than a year in the table.
Note: Stored procedures also improve performance as the stored procedure is cached after it is run. This results in a reduction of physical I/O. We can further reduce Server overhead by scheduling the stored procedure to run during off-peak hours.
Incorrect Answers:
A: A Data Transformation Services (DTS) package provides a set of tools that allows us to extract, transform, and consolidate data stored in a variety of formats and in different locations into single or multiple destinations supported by DTS connectivity. This solution is inappropriate, as the data exists on the server and not in numerous locations and would thus be correctly formatted for use on an instance SQL Server 2000.
B: Triggers are a special type of stored procedure that executes automatically when an UPDATE, INSERT, or DELETE statement is run against a table or view. In this scenario however, the datestamp of the data in the database must be checked and the data deleted one year after the bid has closed. This cannot be accomplished through the use of constraints or triggers.
D: Creating a view that excludes the bids that have a closing date older than one year does not address the company policy that requires that bid information be removed permanently from the database one year after the bid closes. This data will still exist in the base tables.
转载请注明原文地址:https://jikaoti.com/ti/LwO7FFFM
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
[A]Thefirststepinpreparingamarketingplanisthatofproducingtheinformationnecessaryfordecision-making.Usually,a
[A]"Ijustdon’tknowhowtomotivatethemtodoabetterjob.We’reinabudgetcrunchandIhaveabsolutelynofinancialrewa
Fewthingssay"forgetI’mhere"quitesoeloquentlyastheposeoftheshy—theavertedgaze,thehunchedshoulders,thebodypi
Writealettertooneofyourfriends,apologizingtohim/herforyourmakinghis/hercomputerstopworking.Youshouldwrite
Writealettertoamuseum’sstafftoaskforsomeinformationaboutahistoricalexhibition.Youshouldincludethedetailsyou
Itstartedsmall.Justapoliticalslogan,pastedontoaposterinabackofficesomewhere;NOEUROin1999.Germany’smainoppo
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
Notlongago,chiefexecutiveofficers(CEOS)werelandedasheroes,leadersofthebraveneweconomy.BillGatesandJackWelchw
随机试题
阅读苏轼《前赤壁赋》中的一段文字,回答问题:壬戌之秋,七月既望,苏子与客泛舟,游于赤壁之下。清风徐来,水波不兴。举酒属客,诵明月之诗,歌窈窕之章。少焉,月出于东山之上,徘徊于斗牛之间。白露横江,水光接天。纵一苇之所如,凌万顷之茫然。浩浩乎如冯虚御
比较阳性植物与阴性植物的适应特点。
患儿,男,8岁,以急性肾炎收入院,入院后患儿眼睑水肿,尿为洗肉水样,疲乏无力。此时对患儿的首要护理措施是()。
有关苯妥英钠的论述下列哪项是错误的
巴比妥类药物为弱酸(二元酸),在pHl0介质中可发生一级电离;在pHl3介质中可发生二级电离巴比妥类药物分子结构中含酰亚胺基团,可于碱溶液中加热产生氨气,能使红色石蕊试纸变蓝
A.家庭病床B.普通病室C.隔离病室D.观察病室E.急救病室脑出血恢复期应住
下列关于地形图的精度说法正确的是()。
机械设备进场前,承包单位应向( )报送进场设备清单。
下面程序执行后,输出的值应是______。publicclasssTest10{publicstaticvoidmain(String[]args){
BeforeRebeccaclimbedEverest,sheworkedasa______.RebeccawenttoAsiato______in1993.
最新回复
(
0
)