单项选择题
You are a database administrator for your company. The company uses a SQL Server 2005 database that includes a table named Inventory. The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation. Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced.
What should you do?()
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?()
A.Configure a Linked Server connection to the application database.
B.Write a query that uses an OPENDATASOURCE command.
C.Write a query that uses an OPENQUERY command.
D.Configure a Remote Server connection to the application database. -
单项选择题
Youareadatabaseadministratorforyourcompany.ThecompanyhastwoSQLServer2005computersnamedSQL1andSQL2.SQL1islocatedonthelocalnetwork.SQL2islocatedatavendorssiteandisconnectedbyusingaVPNovertheInternet.YouneedtowriteheterogeneousqueriesonSQL1thataccessdatafrombothSQL1andSQL2.Toensurethatyourqueriesarefunctional,youmustconfigureaccesstothevendorssite.Whatshouldyoudo?()
A.Configure an HTTP endpoint for SQL2 on SQL1.
B.Configure SQL2 as a linked server on SQL1.
C.Configure an HTTP endpoint for SQL1 on SQL2.
D.Configure SQL1 as a linked server on SQL2. -
多项选择题
Youareadatabaseadministratorforyourcompany.ThecompanyusesaSQLServer2005application.Eachnight,dataisimportedintoadatabase,andthedatabaseisthensettoberead-only.Duringbusinesshours,usersrunpredefinedandadhocqueries.Youneedtomonitortheserversperformanceduringtheday.Whataretwopossiblewaystoachievethisgoal?()
A.Use the Lock Waits/sec performance counter.
B.Use the Number of Deadlocks/sec performance counter.
C.Use the Transactions/sec performance counter.
D.Use the Full Scans/sec performance counter.
E.Use the Batches/sec performance counter.
