Question

A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
A.forward only
B.static
C.keyset
D.dynamic

Answer 1

______✨ HEY MATE ✨______

➡️Option (C) Keyset is the right answer ✔️

$<marquee>✌️ I THINK IT HELPED YOU ✌️$

Answer 2

Keyset is a cursor type in which the application sees the data as they were at the time the cursor was opened.

So, the right answer is option C. keyset.  

A keyset cursor is also responsible to take a snapshot of the data.

It then stores it in tempdb.

However, here only the set of columns which are in a unique way identify each row that are stored in the snapshot table.