首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
14
问题
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://kaotiyun.com/show/VuhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Whileyouenjoythesunlight,itcastsyourshadowontheground.Therehasbeenadiscussionrecentlyontheissueinanewspap
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
MireilleGuiliano,achampagnecompanyexecutive,capturedtheattentionoffrustrateddieterswithherjoyoflifeinthe2005
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
在用户管理组administrators中添加本地用户“sy”。
随机试题
能提呈外源性抗原的细胞有一个重要标志是
胎盘功能检查方法不包括
口腔健康教育的方法主要有A.提供经济支持B.提供组织保证C.进行口腔疾病的干预措施D.个别交谈和讨论会E.实施行政干预措施
好发于儿童的癣是
“备案号”栏应填()“件数”栏应填()
广大群众在配合公安机关开展工作,实现双方结合过程中应该()。
下列属于辩证否定的是()。
公民甲户籍地为湖北,去深圳亲戚家住了1个月,后来在北京做临时工达2年,根据民法通则的规定应以()为其住所。
AdamSmithwasmefounderofeconomicsasadistinctfieldofstudy.Hewroteonlyonebookonthesubject—TheWealthofNatio
Thegovernmenthastriedtoforge______withenvironmentalists.
最新回复
(
0
)