You work as a database developer at ABC.com. You are developing a SQL server 2012 database
for ABC.com’s e-Commerce application. The application allows ABC.com employees from
different regions to execute a store procedure based on their location.
The location of the ABC.com employees are determined by an input parameter named @location.
You want to develop a process that will execute the correct stored procedure for every ABC.com
employee based on their location.
How would you accomplish this?
A.
You should make use of a client cursor.
B.
You should make use of a static cursor.
C.
You should make use of a forward-only cursor.
D.
You should make use of a dynamic cursor.
E.
You should make use of a keyset cursor.
Explanation:
Ref: http://msdn.microsoft.com/en-us/library/ms191179.aspx
I am thinking a forward_only read_only cursor is the best.
0
0
keyset is fine because there are employeeID’s on which the cursor moves freely
0
0
?
0
0
E
0
0
C
http://www.dotnet-tricks.com/Tutorial/sqlserver/RLID060512-SQL-Server-Different-Types-of-Cursors.html
0
0