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
Seems to me that both expressions are the same, one is <= and the other is < and difference is one day
0
0
Difference is one day so they are not the same. Answer with <= is correct answer
0
0
these date functions are only dealing with the first second of the day and not the following 24 hours… you need to add one more day and use < only to include the entire 24 hours of the last day of the month…
1
0
In order to have 4 statements then instead of alter view, you drop and create the view and then add the grant select.
2
0
Correct answer here:
http://www.aiotestking.com/microsoft/which-four-transact-sql-statements-should-you-use-5/
0
0
Its 1 5 4 6
0
0
grant select is missing at the end part
0
0
Guys,
The question answer options were recorded wrong for this one, but the listed answer is correct.
You do not need to drop the view because it was not create WITH SCHEMABINDING.
Because you do not need to drop the view, you also do not need to grant any rights to User1.
Given this info, you only need ALTER, a SELECT statement, and a WHERE clause.
Follow Enrique’s link for the correct layout of the answer.
0
0
2, 5, 4 according to JENSON dump
0
0
2, 5, 4, 6
Read the Question exacly, it says that you need four statements… also you need a batch seperator b….
0
0
yeah Thomas is right! FOUR statements! greetz to bavaria 😉
0
0
Grant Select on SCHEMA::vwItemList TO USER1 => is wrong because the schema is dbo.
to grant select on SCHEMA use: GRANT SELECT ON SCHEMA::dbo TO USER1
to grant select on object use: GRANT SELECT ON dbo.vwItemList TO USER1
0
0
That is the awesome wonderful search engine in the planet
http://google.com
0
0