PdfPrep.com

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

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.

Exit mobile version