You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. Th

题目

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a report which is often executed during business time. There is a stored procedure that is used as the data source for the report. You get a report from users saying that they receive the data returned by the report but the data is inconsistent. As the technical support, you check and find that phantom reads cause this problem. You must make sure that consistent data is returned by the report while not affecting other users. So what action should you perform to achieve this goal?（）

A、You should configure the database for Read Committed Snapshot isolation.
B、You should modify the stored procedure to use the Snapshot isolation level
C、You should configure the database for Auto Update Statistics asynchronously
D、You should modify the stored procedure to use the Repeatable Read isolation level

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

你们怎样选拔参加保卫工作的人员?

A.How long will you select those employees for the security work?

B.Why do you select those employees for the security work?

C.How will you select those employees for the security work?

D.How do you select security guards for the World Expo?

正确答案：C

第2题：

You can hardly avoid ____ her if you both work in the same office.

A、to meet

B、meet

C、meeting

D、meeting with

正确答案:C

第3题：

— You seem to have a lot of work to do in your office.You’ve always been working overtime.— ____________

A.You are right, but don’t you know the meaning of work?

B.Sorry, I don’t think so.I get overpaid for overwork, you know.

C.That’s right.All work and no play make Jack a dull boy.

D.That’s right, but the work is interesting.I don’t mind some extra hours at

正确答案：D

第4题：

First you should switch the machine ____ before you stop your work.

a. on

b. off

c. up

参考答案：B

第5题：

-Larry is the biggest airhead I've ever met. He always makes careless mistakes, and he's a pain to work with. - ________ . You'll always have some co-workers that are harder to work with than others, you know.

：A I have the same feeling to you ;

B You really have it ;

C You shouldn't be so negative

参考答案:C

第6题：

I believe you can ________ the answer.

(A) work at

(B) work on

(D) work up

正确答案：C
解答参考：work at/on “从事于，致力于”，work out“想出，算出;解决”，work up“激发;制订出”。【译文】我相信你能想出答案

第7题：

You never work late, ________ you?

A.do

B.don’t

C.haven’t

D.are

正确答案：A

第8题：

() you’ve finished the work, you ought to have a good rest.

A、So far

B、Now that

C、Though

D、Even if

参考答案：B

第9题：

一You needn't do the work till after the New Year.

一__________

A. No，you needn't.

B. Oh, good!Thank you.

C. Happy New Year to you.

D. I like the work.

参考答案B

第10题：

You do not mind ()long hours, do you?

A、 working

B、 work

C、 to work

答案：A

解析：本句意思：你不介意长时间工作，是吗？本句考查mind固定搭配，通常mind+doing表示“介意做某事”，不与to do或do直接连用。

You work in a&

题目

相似问题和答案

更多相关问题

相关内容