单项选择题
A.Create a trigger that rolls back changes to the Price column that violate company policy.
B.Create a stored procedure that disallows changes to the Price column that violate company policy.
C.On the Price column， create a check constraint that requires a specified minimum value.
D.On the Price column， create a foreign key constraint to a table that contains valid prices.
单项选择题 You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）
单项选择题 Youareadatabaseadministratorforyourcompany.ThecompanyhastwoSQLServer2005computersnamedSQL1andSQL2.SQL1islocatedonthelocalnetwork.SQL2islocatedatavendorssiteandisconnectedbyusingaVPNovertheInternet.YouneedtowriteheterogeneousqueriesonSQL1thataccessdatafrombothSQL1andSQL2.Toensurethatyourqueriesarefunctional，youmustconfigureaccesstothevendorssite.Whatshouldyoudo？（）
多项选择题 Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005application.Eachnight，dataisimportedintoadatabase，andthedatabaseisthensettoberead-only.Duringbusinesshours，usersrunpredefinedandadhocqueries.Youneedtomonitortheserversperformanceduringtheday.Whataretwopossiblewaystoachievethisgoal？（）