Câu 3: 70-461: MCSA Querying Microsoft SQL Server 2012/2014

You develop a Microsoft SQL Server database that supports an application. The application contains a table that has the following definition:CREATE TABLE Inventory -(ItemID int NOT NULL PRIMARY KEY,ItemsInStore int NOT NULL,ItemsInWarehouse int NOT NULL)You need to create a computed column that returns the sum total of the ItemsInStore and ItemsInWarehouse values for each row. Which Transact-SQL statement should you use?

1. A. ALTER TABLE Inventory ADD TotalItems AS ItemsInStore + ItemsInWarehouse — đáp án hiện tại
2. B. ALTER TABLE Inventory ADD ItemsInStore - ItemsInWarehouse = TotalItemss
3. C. ALTER TABLEInventory ADD TotalItems = ItemsInStore + ItemsInWarehouse
4. D. ALTER TABLE Inventory ADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse);