Архитектура «Клиент-сервер». Обзор компонентов SQL Server 2000. - презентация

1 Архитектура «Клиент-сервер»

2 Обзор компонентов SQL Server 2000

3 Пример вопроса из экзамена #2. 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. #2. 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. 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. 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? Which Transact-SQL statement should you execute? A. ALTER TABLE dbo.StorageLocations ADD CONSTRAINT CK_StorageLocations_UnitsStored CHECK (UnitsStored >= 0) A. ALTER TABLE dbo.StorageLocations ADD CONSTRAINT CK_StorageLocations_UnitsStored CHECK (UnitsStored >= 0) B. CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED.UnitsStored < 0 ROLLBACK TRAN B. CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED.UnitsStored < 0 ROLLBACK TRAN C. CREATE RULE CK_UnitsStored >= 0 GO sp_bindrule 'CK_UnitsStored' 'StorageLocations.UnitsStored' GO C. CREATE RULE CK_UnitsStored >= 0 GO sp_bindrule 'CK_UnitsStored' 'StorageLocations.UnitsStored' GO D. CREATE PROC UpdateUnitsStored bigint) AS < 0 RAISERROR (50099, 17) ELSE UPDATE StorageLocations D. CREATE PROC UpdateUnitsStored bigint) AS < 0 RAISERROR (50099, 17) ELSE UPDATE StorageLocations