« previous next »

Author Question: Briefly describe how a developer defines the type of locking behavior to be used with SQL Server. ... (Read 214 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?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

Did you know?

Opium has influenced much of the world's most popular literature. The following authors were all opium users, of varying degrees: Lewis Carroll, Charles, Dickens, Arthur Conan Doyle, and Oscar Wilde.

Did you know?

In 2010, opiate painkllers, such as morphine, OxyContin®, and Vicodin®, were tied to almost 60% of drug overdose deaths.

Did you know?

Limit intake of red meat and dairy products made with whole milk. Choose skim milk, low-fat or fat-free dairy products. Limit fried food. Use healthy oils when cooking.

Did you know?

Barbituric acid, the base material of barbiturates, was first synthesized in 1863 by Adolph von Bayer. His company later went on to synthesize aspirin for the first time, and Bayer aspirin is still a popular brand today.

Type C killer whales in the Ross Sea. The eye patch slants forward. Type C killer whales in the Ross Sea. The eye patch slants forward.
The Taung Child, the first of the australopithecines to be discovered, is the type specimen for Aust The Taung Child, the first of the australopithecines to be discovered, is the type specimen for Aust
Children with insecure attachments may show angry behavior with peers, which can lead to peer ... Children with insecure attachments may show angry behavior with peers, which can lead to peer ...
Likelihood of Developing Type 2 Diabetes Mellitus Based on BMI Likelihood of Developing Type 2 Diabetes Mellitus Based on BMI
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 ...
Induration measurement in a tuberculin skin test, a type IV hypersensitivity. Induration measurement in a tuberculin skin test, a type IV hypersensitivity.
Video: Membrane transport proteins - pores, gated channels and pumps

For a complete list of videos, visit our video library