ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 047-006

047-006

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-16 15:54:12 0 删除 编辑
6. Which two statements are true? (Choose two.)
A. The USER_SYNONYMS view can provide information about private synonyms.
B. The user SYSTEM owns all the base tables and user-accessible views of the
data dictionary.
C. All the dynamic performance views prefixed with V$ are accessible to all
the database users.
D. The USER_OBJECTS view can provide information about the tables and views
created by the user only.
E. DICTIONARY is a view that contains the names of all the data dictionary
views that the user can access.
Answer: AE
Accessible:可达到,可访问 investigation:调查,研究
USER_SYNONYMS view, which only shows private synonyms.
The USER_OBJECTS view contains information about all objects owned by the
user.(d为什么不对?) ALL the objects created by the user can be found in view
USER_OBJECTS, not only tables and views.
DICTIONARY view is a great starting point for any investigation of the data
dictionary. If we DESCRIBE the view, we get the following:
Name Null Type
-------------- ---------------
TABLE_NAME VARCHAR2(30)
COMMENTS VARCHAR2(4000)
select * from dba_data_files 静态的 来自数据文件
select * from v$datafile 动态的 来自控制文件 或 内存

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

上一篇: 047-004
下一篇: 047-013
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204155