Spam and Abuse Watch

Donnie-Brown wrote:

Question:
You use a Microsoft SQL Server 2012 database.
You want to create a table to store Microsoft Word documents. You need to ensure that the documents must only be accessible via Transact-SQL queries. Which Transact-SQL statement should you use?
A. CREATE TABLE DocumentStore AS FileTable
B. CREATE TABLE DocumentStore([Id] [uniqueidentifier] ROWGUIDCOL NOT NULL UNIQUE,[Document] VARBINARY(MAX) FILESTREAM NULL)GO
C. CREATE TABLE DocumentStore([Id] [INT] NOT NULL PRIMARY KEY,[Document] VARBINARY(MAX) NULL)GO
D. CREATE TABLE DocumentStore([Id] hierarchyid,[Document] NVARCHAR NOT NULL);GO
Answer: C

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?
A. ALTER TABLE InventoryADD TotalItems AS SUM(ItemsInStore, ItemsInWarehouse)
B. ALTER TABLE InventoryADD TotalItems = ItemsInStore + ItemsInWarehouse
C. ALTER TABLE InventoryADD TotalItems AS ItemsInStore + ItemsInWarehouse
D. ALTER TABLE InventoryADD ItemsInStore + ItemsInWarehouse = TotalItems
Answer: D

...