Microsoft Exam Questions

Which four Transact-SQL statements should you use?

DRAG DROP
You create a view based on the following statement:

You grant the Select permission to User1 for this view.
You need to change the view so that it displays only the records that were processed in the
month prior to the current month. You need to ensure that after the changes, the view
functions correctly for User1.
Which four Transact-SQL statements should you use? (To answer, move the appropriate
SQL statements from the list of statements to the answer area and arrange them in the correct order.)

Answer:

Explanation:

Reference:
http://msdn.microsoft.com/en-us/library/hh213020.aspx
Reference:
http://msdn.microsoft.com/en-us/library/ms186819.aspx
Reference:
http://msdn.microsoft.com/en-us/library/ms173846.aspx