« previous next »

Author Question: Briefly describe how a developer defines the type of locking behavior to be used with SQL Server. ... (Read 163 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 use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Allergies play a major part in the health of children. The most prevalent childhood allergies are milk, egg, soy, wheat, peanuts, tree nuts, and seafood.

Did you know?

The first oral chemotherapy drug for colon cancer was approved by FDA in 2001.

Did you know?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Four main models that describe the relationship between ecosystem function and biodiversity. Four main models that describe the relationship between ecosystem function and biodiversity.
Blood typing and cross-reactions. The blood type depends on the presence of surface antigens ... Blood typing and cross-reactions. The blood type depends on the presence of surface antigens ...
In a gear-type oil pump, the oil flows through the pump around the outside of each gear. This is an ... In a gear-type oil pump, the oil flows through the pump around the outside of each gear. This is an ...
The Molecular Structure and Behavior of Lipids The Molecular Structure and Behavior of Lipids
Drugs, Behavior, and Modern Society (8th Edition) Drugs, Behavior, and Modern Society (8th Edition)
Mutations in the MAOA gene cosegregate with aggressive behavior Mutations in the MAOA gene cosegregate with aggressive behavior
Video: Decubitus Ulcer

For a complete list of videos, visit our video library