« previous next »

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

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

More than nineteen million Americans carry the factor V gene that causes blood clots, pulmonary embolism, and heart disease.

Did you know?

Street names for barbiturates include reds, red devils, yellow jackets, blue heavens, Christmas trees, and rainbows. They are commonly referred to as downers.

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
a) Avoid locking your elbows. b) To avoid locking your elbows, keep your elbows facing sideways. a) Avoid locking your elbows. b) To avoid locking your elbows, keep your elbows facing sideways.
Comparison of Type 1 and Type 2 Diabetes Mellitus Comparison of Type 1 and Type 2 Diabetes Mellitus
Water consumption by type of use Water consumption by type of use
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
Neither heat-killed S-type nor live R-type bacteria can kill mice, but simultaneous injection of bot Neither heat-killed S-type nor live R-type bacteria can kill mice, but simultaneous injection of bot
Video: Fractures Animation

For a complete list of videos, visit our video library