Question: With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.

Options

A : READ_ONLY

B : SCROLL_LOCK

C : OPTIMISTIC

D : PESSIMISTIC

Click to view Correct Answer

Previous || Next

SQL Server 2000 - General Questions more questions

Which type of SQL Server cursor concurrency places an update....

Which of the three possible types of triggers does SQL....

Which of the following is a way to create and....

With which type of SQL Server recovery model, is no....

SQL Server 2000 stored procedures can:

An SQL Server 2000 language that adds programming elements like....

With this type of index, the data are stored in....

In SQL Server 2000, which of the following makes a....

With this type of index, the bottom level of an....

With which type of SQL Server recovery model are all....

Advanced SQL - General Questions more Online Exam Quiz

Introduction to Database - General Questions

Introduction to SQL - General Questions

JDBC, Java Server Pages, and MySQL - General Questions

Logical Database Design - General Questions

Managing Databases with Oracle - General Questions

Managing Multiuser Databases - General Questions

Modeling Data in the Organization - General Questions

Object-Oriented Database - General Questions

Object-Oriented Data Modeling - General Questions

ODBC, OLE DB, ADO, and ASP - General Questions