ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 042-105

042-105

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-15 10:01:21 0 删除 编辑
105. Which statement regarding the contents of the V$PARAMETER view is true?
A) displays only the list of default values
B) displays only the list of all basic parameters
C) displays the currently in effect parameter values
D) displays only the list of all advanced parameters
E) displays the list of all the parameter files of a database
F) displays the current contents of the server parameter file
答案:C
V$PARAMETER只是显示现在起作用的参数(currently in effect parameter values)
Editor’s note:V$PARAMETER displays information about the initialization parameters that are currently in effect for the session. A new session inherits parameter values from the instance-wide values displayed by the V$SYSTEM_PARAMETER view.
So,what’s the difference between v$parameter and v$system_parameter. If you execute the sql like that ‘alter session set parameter_name value.’ . You will see the difference with them by querying these two views.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718608/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 042-104
下一篇: 042-106
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    214038