You work as a Database Administrator (DBA) at ABC.com. All databases are hosted on Windows
Server 2012 servers running SQL Server 2012.
A database named CorpDB1 has many tables containing historical data about customers,
products and sales. CorpDB1 is 200GB in size.
You are creating a script that uses the CREATE VIEW statement to create a view. Data in a table
in CorpDB1 will be updated using the view. You need to ensure that the view can update all data
in the table except the data in a column specified in a SELECT statement in the view.
How can you achieve this?
A.
By including WITH SCHEMABINDING in the script.
B.
By including WITH CHECK OPTION in the script.
C.
By including WITH DEFAULT in the script.
D.
By including WITH VIEW_METADATA in the script.
E.
By including WITH ENCRYPTION in the script.
Explanation: