Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?

READ_ONLY
SCROLL_LOCK
OPTIMISTIC
READCOMMITTED

LohaHridoy

4 views

2025-01-04 04:42

1 Answers

AhmedNazir

Answer: Option 4

Let'

4 views Answered 2022-09-01 13:21

Related Questions

An empty fuel tank of a car was filled with A type petrol. When the tank was half-empty, it was filled with B type petrol. Again when the tank was half-empty, it was filled with A type petrol. When the tank was half-empty again, it was filled with B type petrol. What is the percentage of A type petrol at present in the tank?

1 Answers 5 Views

An empty fuel tank of a car was filled with A type petrol. When the tank was half-empty, it was filled with B type petrol. Again when the tank was half-empty, it was filled with A type petrol. When the tank was half-empty again, it was filled with B type petrol. What is the percentage of A type petrol at present in the tank ?

1 Answers 7 Views

Maria needs to install software on a Windows NT Server computer which is a backup domain controller. When she attempts to log on to the server, she receives the message "Unable to log on locally". What must you do to enable Maria to log on to the server?

1 Answers 5 Views

Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?

1 Answers 5 Views

With SQL Server optimistic locking, an update lock is placed on the row when the row is read.?

1 Answers 4 Views

A network consists of eight NT servers. You are planning to move servers to different segments of your network, what utility should be used at each server to determine which server generates the most traffic?

1 Answers 6 Views

What mode of authentication does SQL Server NOT provide?

1 Answers 5 Views

In a lock-gate, the reaction between two gates is (where P = Resultant pressure on the lock gate, and α = Inclination of the gate with the normal to the side of the lock)?

1 Answers 9 Views

Which of the following refers to a cursor type where changes of any type and from any source are visible?

1 Answers 5 Views

The Indian Railways has launched which virtual server to optimise server usage and faster connectivity?

1 Answers 5 Views

এক্সাম দিয়ে মেধা যাচাই করুন

Job Preparation (1125)

Admission (754)

এসএসসি (10)

এইচএসসি (5)