You need to recommend a change to sp3 to ensure that the procedure completes only if all of the UPDATE statements complete. Which change should you recommend?
A. Set the IMPLICIT_TRANSACTIONS option to off.
B. Set the XACT_ABORT option to off
C. Set the IMPLICIT_TRANSACTIONS option to on.
D. Set the XACT_ABORT option to on.
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 Columnl.
Which code segment should you add at line 06?
A. WITH VIEW_METADATA
B. WITH ENCRYPTION
C. WITH CHECK OPTION
D. WITH SCHEMABINDING
Drag and Drop Question
You have a SQL Azure database named Database1. You need to design the schema for a table named table1. Table1 will have less than one million rows. Table1 will contain the following information for each row:
The solution must minimize the amount of space used to store each row. Which data types should you recommend for each column? To answer, drag the appropriate data type to the correct column in the answer area.