Microsoft
70-457 · Question #1
70-457 Question #1: Real Exam Question with Answer & Explanation
The correct answer is A. ALTER TABLE Inventory. See the full explanation below for the reasoning.
Question
You develop a Microsoft SQL Server 2012 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?
Options
- AALTER TABLE Inventory
- BALTER TABLE Inventory
- CALTER TABLE Inventory
- DALTER TABLE Inventory
Community Discussion
No community discussion yet for this question.