You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?() A. The statistics are stored in the pending statistics table in the data dictionary.B. The statistics are treated as the current statistics by the optimizer for all sessions.C. The statistics are treated as the current statistics by the optimizer for the current sessions only.D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.

You executed the following commands:Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?()

A. The statistics are stored in the pending statistics table in the data dictionary.

B. The statistics are treated as the current statistics by the optimizer for all sessions.

C. The statistics are treated as the current statistics by the optimizer for the current sessions only.

D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.


相关考题:

A small subsection of the society has managed to foist itself ___________ the rest of us as an arbiter of such matters. A. onB. downC. upD. above

[A] Around [B] Under [C] Above [D] Outside

(ii) Comment on the figures in the statement prepared in (a)(i) above. (4 marks)

(iii) Calculate the cash remaining in the company as a result of the salary and dividend payments made in(ii) above. (1 mark)

“in view of( )above, they need to find more sponsors.“ A. thatB. thisC. inD. the

You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following

__________ a wise king, people of this country lived a happy life. A.OnB.WithC.BeneathD.Above

There is a beautiful clock ________ the wall of her bedroom A.onB.overC.above

He bought the book __________ $20.A.inB.underC.forD.above

Above-normal tides near the center of a hurricane maybe caused by the ______.A.high barometric pressureB.jet streamC.storm surgeD.torrential rains