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
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.
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
select * from dba_data_files 静态的 来自数据文件
select * from v$datafile 动态的 来自控制文件 或 内存
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11312660/viewspace-718770/，如需转载，请注明出处，否则将追究法律责任。