You create a view named OrderSummary by using the following Transact-SQL statement: For each of the following statements, select Yes if the statement is true. Otherwise, select No

Posted by: Pdfprep Category: 70-461 Tags: , ,

HOTSPOT

You have a database that contains the following related tables:

You create a view named OrderSummary by using the following Transact-SQL statement: For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Answer:

Explanation:

The SalesOrderID column is used in a join statement and cannot be updated. The Status column is used can be updated. The SubTotal column is an aggregate column and cannot be updated.

Leave a Reply

Your email address will not be published.