Related Questions

With SQL Server optimistic locking, an update lock is placed on the row when the row is read.
A True
B False
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?
A Forward only
B Static
C Keyset
D Dynamic
Which of the following is not a factor in determining the concurrency control behavior of SQL Server?
A Lock level
B Transaction isolation level
C Cursor concurrency setting
D Locking hints
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
Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?
A REPEATABLE READ
B SERIALIZABLE
C READ COMMITTED
D READ UNCOMMITTED
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?
A In User Manager for Domains, define Maria as a local account
B In User Manager for Domains, assign Maria to a group that has the right to log on locally
C In the System option in Control Panel, select the setting that allows users to log on locally
D In the System option in Control Panel, set the user environment variables to allow Maria to log on locally
E None of the above
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?
A eight
B nine
C ten
D eleven
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?
A Enable Anonymous access for the intranet server
B Enable Anonymous access for the Sales virtual directory
C Remove Nate fmm the Intern group
D Make Nate a member of the Security group
E None of above
Insert ও Update কমান্ড SQL এর কোন সুবিধার অন্তর্ভুক্ত?
A DDL
B DCL
C DML
D DOL
Which of the following refers to a cursor type where changes of any type and from any source are visible?
A Forward only
B Static
C Keyset
D Dynamic

Next steps