« previous next »

Author Question: Briefly describe how a developer defines the type of locking behavior to be used with SQL Server. ... (Read 220 times)

Bernana

  • Hero Member
  • *****
  • Posts: 530
on: Jul 7, 2018
Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.
 
  What will be an ideal response?

Question 2

Most DBMS products will let you define a primary key on a column that contains null values.
 
  Indicate whether the statement is true or false


Jbrasil

  • Sr. Member
  • ****
  • Posts: 337
Reply #1 on: Jul 7, 2018
Answer to Question 1

Locking behavior in SQL Server is determined by the interaction of transaction isolation level, cursor concurrency setting, and locking hints. Transaction isolation level can be defined to be Read Uncommitted, Read Committed, Repeatable Read, or Serializable. Read Committed is the default setting. Cursor concurrency can be set to Read-only, Optimistic, or Scroll_Lock. Scroll_Lock is a type of pessimistic locking. The cursor type determines the default type of cursor concurrency. Locking hints can be used by experienced developers to modify locking behavior. Locking hints can override transaction isolation level for a given transaction, or influence the types of locks that SQL Server uses for a given transaction. Locking hints are specified by the WITH parameter of the FROM clause in SELECT SQL statements.

Answer to Question 2

FALSE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

For about 100 years, scientists thought that peptic ulcers were caused by stress, spicy food, and alcohol. Later, researchers added stomach acid to the list of causes and began treating ulcers with antacids. Now it is known that peptic ulcers are predominantly caused by Helicobacter pylori, a spiral-shaped bacterium that normally exist in the stomach.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

During World War I, advancing armies unloosed ferocious artillery barrages to destroy deeply entrenc During World War I, advancing armies unloosed ferocious artillery barrages to destroy deeply entrenc
Noid lights are usually purchased as an assortment so that one is available for any type or size ... Noid lights are usually purchased as an assortment so that one is available for any type or size ...
Connections of a nitric acid plant, intermediate pressure type Connections of a nitric acid plant, intermediate pressure type
a) Type IV hypersensitivity reaction, contact dermatitis as the result of reaction to the nickel in ... a) Type IV hypersensitivity reaction, contact dermatitis as the result of reaction to the nickel in ...
Action of a type II topoisomerase Action of a type II topoisomerase
The behavior of the components during the triplet-binding assay The behavior of the components during the triplet-binding assay
Video: Summary of female reproductive cycle days 1-28

For a complete list of videos, visit our video library