Curioustab

Home » Technical Questions » Database

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

READ_ONLY
SCROLL_LOCK
OPTIMISTIC
PESSIMISTIC

Correct Answer: OPTIMISTIC

← Previous Question Next Question→

More Questions from Database

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
A shared database should:
A transitive dependency is which of the following?
It is necessary to sort a file before searching a particular item
Parenthesis is never required in Postfix or Prefix expressions
Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
To eliminate definition duplication, XML Schemas define:
When an entity instance may be a member of multiple subtypes or it does not have to be a member of a subtype, it is which of the following?
The HAVING clause does which of the following?
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

Discussion & Comments

No comments yet. Be the first to comment!

Join Discussion