This topic contains a solution. Click here to go to the answer

Author Question: Which of the following is a type of cursor concurrency that causes SQL Server to place an update ... (Read 78 times)

fasfsadfdsfa

  • Hero Member
  • *****
  • Posts: 554
Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read?
 
  A) SCROLL_LOCK
  B) Optimistic
  C) Serializable
  D) Read only

Question 2

We have obtained access to the company's operational data. We have been asked to produce a report with an item by item analysis of sales, but the only sales figure available is the total sale value for each order. This is an example of ________.
 
  A) dirty data
  B) inconsistent data
  C) nonintegrated data
  D) a wrong format problem



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

cclemon1

  • Sr. Member
  • ****
  • Posts: 312
Answer to Question 1

A

Answer to Question 2

D




fasfsadfdsfa

  • Member
  • Posts: 554
Reply 2 on: Jul 7, 2018
:D TYSM


ghepp

  • Member
  • Posts: 361
Reply 3 on: Yesterday
Great answer, keep it coming :)

 

Did you know?

Many supplement containers do not even contain what their labels say. There are many documented reports of products containing much less, or more, that what is listed on their labels. They may also contain undisclosed prescription drugs and even contaminants.

Did you know?

An identified risk factor for osteoporosis is the intake of excessive amounts of vitamin A. Dietary intake of approximately double the recommended daily amount of vitamin A, by women, has been shown to reduce bone mineral density and increase the chances for hip fractures compared with women who consumed the recommended daily amount (or less) of vitamin A.

Did you know?

Lower drug doses for elderly patients should be used first, with titrations of the dose as tolerated to prevent unwanted drug-related pharmacodynamic effects.

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

The top 10 most important tips that will help you grow old gracefully include (1) quit smoking, (2) keep your weight down, (3) take supplements, (4) skip a meal each day or fast 1 day per week, (5) get a pet, (6) get medical help for chronic pain, (7) walk regularly, (8) reduce arguments, (9) put live plants in your living space, and (10) do some weight training.

For a complete list of videos, visit our video library