单选题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_DICTI

题目
单选题
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

相似考题

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 two statements correctly describe the relation between a data file and the logical databasestructures（）A、An extent cannot spread across data files.B、A segment cannot spread across data files.C、A data file can belong to only one tablespace.D、A data file can have only one segment created in it.E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

3.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）A、SQL statements that are part of the AWR baseline only B、SQL statements based on the AWR top SQL identificationC、SQL statements that are part of the available SQL Tuning Set (STS) only D、SQL statements that are available in the cursor cache and executed by a user other than SYS 

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.

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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_DICTI”相关问题

  • 第1题：

    Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）

    • A、All objects in the database
    • B、Tables owned by SYS and SYSTEM
    • C、Data dictionary tables
    • D、NCHAR columns
    • E、CHAR columns

    正确答案:E

  • 第2题：

    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

  • 第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题：

    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

  • 第5题：

    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

    正确答案:A

  • 第6题：

    These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done（）

    • A、1 and 2
    • B、2 and 5
    • C、1，3，and 4
    • D、3，4，and 5
    • E、1，2，3，and 4

    正确答案:C

  • 第7题：

    单选题
    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
    解析： 暂无解析

  • 第8题：

    单选题
    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
    解析： 暂无解析

  • 第9题：

    单选题
    You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）
    A

    Use the DESCRIBE command in the EMP_DEPT VU view.

    B

    Use the DEFINE VIEW command on the EMP_DEPT VU view.

    C

    Use the DESCRIBE VIEW command on the EMP_DEPT VU view.

    D

    Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

    E

    Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.

    F

    Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.


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

  • 第10题：

    多选题
    Which two statements are true about the roles in the Oracle database？（）
    A

    A role can be granted to itself.

    B

    Roles are owned by the SYS user.

    C

    Roles can be granted to other roles.

    D

    A role cannot be assigned external authentication.

    E

    A role can contain both system and object privileges.


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

  • 第11题：

    多选题
    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
    解析： 暂无解析

  • 第12题：

    多选题
    Which two statements correctly describe the relation between a data file and the logical database structures（）
    A

    An extent cannot spread across data files.

    B

    A segment cannot spread across data files.

    C

    A data file can belong to only one tablespace.

    D

    A data file can have only one segment created in it.

    E

    A data block can spread across multiple data files as it can consist of multiple operating system （OS）blocks


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

  • 第13题：

    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

    正确答案:A

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Which two statements are true about the roles in the Oracle database？（）

    • A、A role can be granted to itself.
    • B、Roles are owned by the SYS user.
    • C、Roles can be granted to other roles.
    • D、A role cannot be assigned external authentication.
    • E、A role can contain both system and object privileges.

    正确答案:C,E

  • 第18题：

    Which two statements are true regarding single row functions?（）

    • A、They accept only a single argument 
    • B、They can be nested only to two levels 
    • C、Arguments can only be column values or constants 
    • D、They always return a single result row for every row of a queried table 
    • E、They can return a data type value different from the one that is referenced

    正确答案:D,E

  • 第19题：

    多选题
    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
    解析： 暂无解析

  • 第20题：

    多选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）
    A

    SQL statements that are part of the AWR baseline only 

    B

    SQL statements based on the AWR top SQL identification

    C

    SQL statements that are part of the available SQL Tuning Set (STS) only 

    D

    SQL statements that are available in the cursor cache and executed by a user other than SYS 


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

  • 第22题：

    多选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done（）
    A

    1 and 2

    B

    2 and 5

    C

    1，3，and 4

    D

    3，4，and 5

    E

    1，2，3，and 4


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

  • 第24题：

    单选题
    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


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

相关内容