« previous next »

Author Question: Briefly describe how a developer defines the type of locking behavior to be used with SQL Server. ... (Read 221 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 training of an anesthesiologist typically requires four years of college, 4 years of medical school, 1 year of internship, and 3 years of residency.

Did you know?

Ether was used widely for surgeries but became less popular because of its flammability and its tendency to cause vomiting. In England, it was quickly replaced by chloroform, but this agent caused many deaths and lost popularity.

Did you know?

Pregnant women usually experience a heightened sense of smell beginning late in the first trimester. Some experts call this the body's way of protecting a pregnant woman from foods that are unsafe for the fetus.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

It is believed that the Incas used anesthesia. Evidence supports the theory that shamans chewed cocoa leaves and drilled holes into the heads of patients (letting evil spirits escape), spitting into the wounds they made. The mixture of cocaine, saliva, and resin numbed the site enough to allow hours of drilling.

Canada Total Energy Consumption by Fuel Type Canada Total Energy Consumption by Fuel Type
Describe how fat is digested, absorbed, and transported in the body Describe how fat is digested, absorbed, and transported in the body
Describe the Conceptual Forecasting Framework in your own words. Describe the Conceptual Forecasting Framework in your own words.
The components of the wild-type lac operon The components of the wild-type lac operon
Type of entry grade 1 Type of entry grade 1
Video: Ventilation - phases and driving forces

For a complete list of videos, visit our video library