Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?
A) SCROLL_LOCK
B) Optimistic
C) Serializable
D) Read only
Correct Answer:
Verified
Q82: Briefly describe how a developer defines the
Q83: Specifying locking hints in which parameter in
Q84: Discuss the Microsoft PowerShell utility.
Q85: Briefly explain the different SQL Server recovery
Q86: Explain two ways of creating tables in
Q88: Which of the following is not a
Q89: Describe the database files that are automatically
Q90: Briefly explain the different SQL Server backup
Q91: Explain how to work around the SQL
Q92: Explain the SQL Server IDENTITY constraint.
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents