Page 1 of 1

You have a database hosted on SQL Azure. You are developing a script to create a view that will be used to update the da

Posted: Mon Oct 17, 2022 4:49 pm
by answerhappygod
You have a database hosted on SQL Azure.
You are developing a script to create a view that will be used to update the data in a table.
The following is the relevant portion of the script. (Line numbers are included for reference only.)

You need to ensure that the view can update the data in the table, except for the data in Column1.
Which code segment should you add at line 06?
You Have A Data 1
You Have A Data 1 (16.67 KiB) Viewed 109 times
A. WITH CHECK OPTION
B. WITH VIEW_METADATA
C. WITH ENCRYPTION
D. WITH SCHEMABINDING