Note the points about data dictionary views and dynamic performance views：  1.These are stored in the SYSTEM tablespace.  2.These are the based on the virtual tables.  3.These are owned by the SYSuser.  4.These can be queried by a normal user only if O7_

题目

Note the points about data dictionary views and dynamic performance views：  1.These are stored in the SYSTEM tablespace.  2.These are the based on the virtual tables.  3.These are owned by the SYSuser.  4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE.  5.V$FIXED_TABLE view can be queried to list the names of these views.  Which statements listed describe the data dictionary views（）

  • A、1 and 3
  • B、2，3，and 5
  • C、1，2，and 3
  • D、2，3，4，and 5
相似考题

1.Which two statements about the SQL Management Base (SMB) are true?()A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.

2. Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.A、1 and 3B、2， 3， and 5C、1， 2， and 3D、2， 3， 4， and 5

3.Which statement is true regarding virtual private catalogs?（）A、A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.B、The virtual private catalog owner cannot create and modify the stored scripts.C、The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.D、To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

4.Which statements are true regarding the Query Result Cache? ()A. It can be set at the system, session, or table level.B. It is used only across statements in the same session.C. It can store the results from normal as well as flashback queries.D. It can store the results of queries based on normal, temporary, and dictionary tables.

更多“Note the points about data dictionary views and dynamic performance views：  1.These are stored in the SYSTEM tablespace.  2.These are the based on the virtual tables.  3.These are owned by the SYSuser.  4.These can be queried by a normal user only if O7_D”相关问题

  • 第1题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? （）(Choose two)

    • A、All the related indexes and views are automatically dropped
    • B、The flashback drop feature can recover only the table structure
    • C、Only the related indexes are dropped whereas views are invalidated
    • D、The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第2题：

    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)

    • A、It contains only SQL profiles generated by SQL Tuning Advisor.
    • B、It stores plans generated by the optimizer using a stored outline.
    • C、It is part of the data dictionary and stored in the SYSAUX tablespace.
    • D、It is part of the data dictionary and stored in the SYSTEM tablespace.
    • E、It contains the statement log, the plan history, plan baselines, and SQL profiles.

    正确答案:C,E

  • 第3题：

    Which two statements about bigfile tablespaces are true？ （）

    • A、The bigfile tablespace have only one data file.
    • B、The segment space management is automatic.
    • C、The extent management is dictionary managed.
    • D、The database can have only one bigfile tablespace.
    • E、The bigfile tablespace can be converted to a smallfile tablespace.

    正确答案:A,B

  • 第4题：

    The customer and order tables are often used in joins， thereby resulting in complex queries. You created views to simplify the writing of queries. These views are stored in（）.

    • A、user tables
    • B、view segment
    • C、table segment
    • D、data dictionary
    • E、object segment
    • F、performance tables

    正确答案:D

  • 第5题：

    Which two statements are true about simple views？（）

    • A、Views can be created as read only.
    • B、Views are data segments like tables.
    • C、Views can be created on the basis of more than one table.
    • D、Data manipulation language （DML） operations cannot be performed on views.

    正确答案:A,C

  • 第6题：

    Which three statements are true about Automatic Workload Repository (AWR)?（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR data is stored in memory and in the database.
    • C、The snapshots collected by AWR are used by the self-tuning components in the database
    • D、AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
    • E、AWR contains system wide tracing and logging information.

    正确答案:B,C,E

  • 第7题：

    多选题
    Which  statements are correct about temporary tables（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables


    正确答案： D,E
    解析： 暂无解析

  • 第8题：

    多选题
    Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)
    A

    It contains only SQL profiles generated by SQL Tuning Advisor.

    B

    It stores plans generated by the optimizer using a stored outline.

    C

    It is part of the data dictionary and stored in the SYSAUX tablespace.

    D

    It is part of the data dictionary and stored in the SYSTEM tablespace.

    E

    It contains the statement log, the plan history, plan baselines, and SQL profiles.


    正确答案： D,A
    解析： 暂无解析

  • 第9题：

    多选题
    Which three statements are correct about temporary tables？（）
    A

    Indexes and views can be created on temporary tables.

    B

    Both the data and the structure of temporary tables can be exported.

    C

    Temporary tables are always created in a user’s temporary tablespace.

    D

    The data inserted into a temporary table in a session is available to other sessions.

    E

    Data manipulation language （DML） locks are never acquired on the data of temporary tables.


    正确答案： E,C
    解析： 暂无解析

  • 第10题：

    单选题
    You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）
    A

    The trace file

    B

    The fixed views

    C

    The data dictionary views

    D

    The operating system log fields

    E

    The dynamic performance views.


    正确答案： A
    解析： 暂无解析

  • 第11题：

    多选题
    Which two statements are true about simple views？（）
    A

    Views can be created as read only.

    B

    Views are data segments like tables.

    C

    Views can be created on the basis of more than one table.

    D

    Data manipulation language （DML） operations cannot be performed on views.


    正确答案： D,B
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements about bigfile tablespaces are true？ （）
    A

    The bigfile tablespace have only one data file.

    B

    The segment space management is automatic.

    C

    The extent management is dictionary managed.

    D

    The database can have only one bigfile tablespace.

    E

    The bigfile tablespace can be converted to a smallfile tablespace.


    正确答案： D,B
    解析： 暂无解析

  • 第13题：

    Which statements are true regarding the Query Result Cache？（） 

    • A、 It can be set at the system， session， or table level.
    • B、 It is used only across statements in the same session.
    • C、 It can store the results from normal as well as flashback queries.
    • D、 It can store the results of queries based on normal，temporary，and dictionary tables.

    正确答案:A,C

  • 第14题：

    Which two statements are true about the Automatic Workload Repository （AWR）（）

    • A、All AWR tables belong to the SYSTEM schema.
    • B、The AWR contains systemwide tracing and logging information.
    • C、The snapshots collected by the AWR are accessible through data dictionary views.
    • D、The snapshots collected by the AWR are used by self-tuning components in the database.

    正确答案:C,D

  • 第15题：

    Which  statements are correct about temporary tables（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

    正确答案:A,C,E

  • 第16题：

    You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）

    • A、The trace file
    • B、The fixed views
    • C、The data dictionary views
    • D、The operating system log fields
    • E、The dynamic performance views.

    正确答案:E

  • 第17题：

    The RECYCLEBIN parameter is set to ON for your database. You drop a table，PRODUCTS，from the SCOTT schema.  Which two statements are true regarding the outcome of this action？（）

    • A、 All the related indexes and views are automatically dropped
    • B、 The flashback drop feature can recover only the table structure
    • C、 Only the related indexes are dropped whereas views are invalidated
    • D、 The flashback drop feature can recover both the table structure and its data

    正确答案:C,D

  • 第18题：

    Which three statements are correct about temporary tables？（）

    • A、Indexes and views can be created on temporary tables.
    • B、Both the data and the structure of temporary tables can be exported.
    • C、Temporary tables are always created in a user’s temporary tablespace.
    • D、The data inserted into a temporary table in a session is available to other sessions.
    • E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

    正确答案:A,C,E

  • 第19题：

    单选题
    Note the points about data dictionary views and dynamic performance views：  1.These are stored in the SYSTEM tablespace.  2.These are the based on the virtual tables.  3.These are owned by the SYSuser.  4.These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set toTRUE.  5.V$FIXED_TABLE view can be queried to list the names of these views.  Which statements listed describe the data dictionary views（）
    A

    1 and 3

    B

    2，3，and 5

    C

    1，2，and 3

    D

    2，3，4，and 5


    正确答案： B
    解析： 暂无解析

  • 第20题：

    单选题
    Which statements listed below describe the data dictionary views（） 1） These are stored in the SYSTEM tablespace. 2） These are the based on the virtual tables. 3） These are owned by the SYS user. 4） These can be queried by a normal user only if O7_DICTIONARY_ACCESSIBILTY parameter is set to TRUE. 5） The V$FIXED_TABLE view can be queried to list the names of these views.
    A

    1 and 3

    B

    2， 3， and 5

    C

    1， 2， and 3

    D

    2， 3， 4， and 5


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    Which statement is true regarding virtual private catalogs？（）
    A

     A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script.

    B

     The virtual private catalog owner cannot create and modify the stored scripts.

    C

     The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.

    D

     To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or  SYSOPER privilege on the target database.


    正确答案： D
    解析： 暂无解析

  • 第22题：

    多选题
    Which two statements are true about the Automatic Workload Repository （AWR）（）
    A

    All AWR tables belong to the SYSTEM schema.

    B

    The AWR contains systemwide tracing and logging information.

    C

    The snapshots collected by the AWR are accessible through data dictionary views.

    D

    The snapshots collected by the AWR are used by self-tuning components in the database.


    正确答案： B,D
    解析： AWR 基础结构由两个主要部分组成：  • 一个内存中统计信息收集工具，Oracle Database 11g组件使用它来收集统计信息。出于性能方面的考虑，这些统计信息存储在内存中。可以通过动态性能(V$) 视图访问存储在内存中的统计信息。  • 代表该工具持久部分的AWR 快照。AWR 快照可以通过数据字典视图和EnterpriseManager Database Control 来访问。  它为内部Oracle 服务器组件提供服务来收集、处理、维护和使用性能统计信息，以便进行问题检测和自优化。 AWR 中包含数百个表，所有这些表均属于SYSMAN方案且存储在SYSAUX表空间中。

  • 第23题：

    多选题
    Which statements are true regarding the Query Result Cache？（）
    A

    It can be set at the system， session， or table level.

    B

    It is used only across statements in the same session.

    C

    It can store the results from normal as well as flashback queries.

    D

    It can store the results of queries based on normal，temporary，and dictionary tables.


    正确答案： A,C
    解析： 暂无解析

相关内容