查看: 3647|回复: 19

[题库] Oracle OCP题库解析（17）

发表于 2012-2-3 14:01:50 | 显示全部楼层 |阅读模式

View the Exhibit and examine the output.

Which statement describes the conclusion?

A) The users should use bind variables instead of literals in the query.

B) The dictionary cache is consuming more space than the library cache.

C) The shared pool size should be increased to accommodate the SQL statements.

D) Preparing indexes on the tables used in the SQL statements would improve the library cache performance.

Answer: A

从图中可以看出需要使用绑定变量。

发表于 2012-2-11 11:46:49 | 显示全部楼层

沙发 2012-2-11 11:46:49 回复收起回复

回复支持反对

发表于 2012-2-11 11:47:01 | 显示全部楼层

板凳 2012-2-11 11:47:01 回复收起回复

回复支持反对

账号		自动登录	找回密码
密码			论坛注册