PrepAway - Latest Free Exam Questions & Answers

You need to create a view named uv_CustomerFullNames

You need to create a view named uv_CustomerFullNames. The view must prevent the underlying
structure of the customer table from being changed. Part of the correct T-SQL statement has been
provided in the answer area. Provide the complete code.

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation

Explanation:
CREATE VIEW sales.uv_CustomerFullNames
WITH SCHEMABINDING
AS SELECT
FirstName,
LastName
FROM Sales.Customers


Leave a Reply