Related Questions

With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
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?
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
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?
Nurse Kemp has worked more night shifts in a row than Nurse Rogers, who has worked five. Nurse Miller has worked fifteen night shifts in a row, more than Nurses Kemp and Rogers combined. Nurse Calvin has worked eight night shifts in a row, less than Nurse Kemp. How many night shifts in a row has Nurse Kemp worked?
You are the network administrator for your company. Mike Nash is a member of the Administration group, and Nate Sun is a member of the Intern group. Both groups are in the same domain. On the intranet server, the Administration group is placed in the Security group, and the Intern group is placed in the Nonsecurity group. The Security group is then granted Full Control permission for the Sales virtual directory. Nate needs to update new sales information that is located on the Sales virtual directory. What should you do so that Nate can perform this task?
Insert ও Update কমান্ড SQL এর কোন সুবিধার অন্তর্ভুক্ত?
Which of the following refers to a cursor type where changes of any type and from any source are visible?