解释materialized views的作用

题目

解释materialized views的作用

相似考题

1.要使摄像机的构图与透视视口的构图一样,需要使用哪个命令()。A、Views/Match Camerato ViewB、Views/Show Transform. GizmoC、Views/Show BackgroundD、Views/Show Key Times

2.What recommendations does the SQL Access Advisor provide for optimizing SQL queries?()A. selection of SQL plan baselinesB. partitioning of tables and indexesC. creation of index-organized tablesD. creation of bitmap, function-based, and B-tree indexesE. optimization of materialized views for maximum query usage and fast refresh

3.To generate recommendations to improve the performance of a set of SQL queries in an application, you execute the following blocks of code:The blocks of code execute successfully; however, you do not get the required outcome. What could be the reason?（）A. A template needs to be associated with the task.B.A workload needs to be associated with the task.C. The partial or complete workload scope needs to be associated with the task.D. The type of structures (indexes, materialized views, or partitions) to be recommended need to be specified for the task.

4.In Oracle 11g, which recommendations does the SQL Access Advisor generate?()A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations

参考答案和解析
正确答案：
 
更多“解释materialized views的作用”相关问题

  • 第1题：

    What recommendations does the SQL Access Advisor provide for optimizing SQL queries? ()(Choose all that apply.)

    A. selection of SQL plan baselines

    B. partitioning of tables and indexes

    C. creation of index-organized tables

    D. creation of bitmap, function-based, and B-tree indexes

    E. optimization of materialized views for maximum query usage and fast refresh


    参考答案：B, D, E

  • 第2题：

    Your database supports an online transaction processing (OLTP) application.The application is undergoing some major schema changes, such as addition of new indexes and materialized views.You want to check the impact of these changes on workload performance.What should you use to achieve this?（）

    A. Database replay

    B. SQL Tuning Advisor

    C. SQL Access Advisor

    D. SQL Performance Analyzer

    E. Automatic Workload Repository compare reports


    参考答案：E

  • 第3题：

    哪个后台进程刷新materialized views?


    正确答案：
     

  • 第4题：

    在3dmax中，要使摄像机的构图与透视视口的构图一样，需要使用哪个命令（）

    • A、Views/Match Camera to view
    • B、Views/Show Transform Gizmo
    • C、Views/Show Background
    • D、Views/Show Key Times

    正确答案:A

  • 第5题：

    要在所有视口中以明暗方式显示选择的对象，需要使用哪个命令（）。

    • A、Views/Show Selected
    • B、Views/Show Transform Gizmo
    • C、Views/Show Background
    • D、Views/Show Key Times

    正确答案:A

  • 第6题：

    Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

    • A、Database replay
    • B、SQL Tuning Advisor
    • C、SQL Access Advisor
    • D、SQL Performance Analyzer
    • E、Automatic Workload Repository compare reports

    正确答案:E

  • 第7题：

    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

  • 第8题：

    Your application regularly issues the following statement: SELECT * FROM BANK_ACCT WHERE ACCT_BALANCE BETWEEN 1000 and 10000; Which of the following database objects would be inappropriate for use with this statement?（）

    • A、Materialized views 
    • B、Indexes 
    • C、Index-organized tables 
    • D、Hash clusters

    正确答案:D

  • 第9题：

    What recommendations does the SQL Access Advisor provide for optimizing SQL queries？（）  

    • A、 selection of SQL plan baselines
    • B、 partitioning of tables and indexes
    • C、 creation of index-organized tables
    • D、 creation of bitmap， function-based，and B-tree indexes
    • E、 optimization of materialized views for maximum query usage and fast refresh

    正确答案:B,D,E

  • 第10题：

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


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

  • 第11题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）
    A

    Create new indexes.

    B

    Modify existing indexes.

    C

    Implement partitioning on a nonpartitioned table.

    D

    Create materialized views.

    E

    All of the above


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

  • 第12题：

    单选题
    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）
    A

     Create new indexes.

    B

     Modify existing indexes.

    C

     Implement partitioning on a nonpartitioned table.

    D

     Create materialized views.

    E

     All of the above


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

  • 第13题：

    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?()

    A. Create new indexes.

    B. Modify existing indexes.

    C. Implement partitioning on a nonpartitioned table.

    D. Create materialized views.

    E. All of the above


    参考答案：E

  • 第14题：

    views on language and ___ both influence theories on how language should be taught.

    A、views on language learning

    B、views on culture learning

    C、values of life

    D、styles of life


    参考答案：A

  • 第15题：

    在场景中，打开和关闭对象的变换坐标系统的命令是（）。

    • A、Views/Viewport Background
    • B、Views/Show Transform Gizmo
    • C、Views/Match Camera to View
    • D、Views/Show Key Times

    正确答案:B

  • 第16题：

    在场景中打开和关闭对象的关联显示的命令是（）。

    • A、Views/Show Dependencies
    • B、Views/Show Transform Gizmo
    • C、Views/Show Background
    • D、Views/Show Key Times

    正确答案:A

  • 第17题：

    Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?（）

    • A、Create new indexes.
    • B、Modify existing indexes.
    • C、Implement partitioning on a nonpartitioned table.
    • D、Create materialized views.
    • E、All of the above

    正确答案:E

  • 第18题：

    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）  

    • A、 Segment Advisor
    • B、 SQL Access Advisor
    • C、 Undo Advisor
    • D、 SQL Tuning Advisor

    正确答案:B

  • 第19题：

    In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）

    • A、partitioning recommendations
    • B、statistics collection recommendations
    • C、index creation recommendations
    • D、materialized view recommendations
    • E、materialized view log recommendations

    正确答案:A,C,D,E

  • 第20题：

    What recommendations does the SQL Access Advisor provide for optimizing SQL queries? （）(Choose all that apply.)

    • A、selection of SQL plan baselines
    • B、partitioning of tables and indexes
    • C、creation of index-organized tables
    • D、creation of bitmap, function-based, and B-tree indexes
    • E、optimization of materialized views for maximum query usage and fast refresh

    正确答案:B,D,E

  • 第21题：

    In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)

    • A、partitioning recommendations
    • B、statistics collection recommendations
    • C、index creation recommendations
    • D、materialized view recommendations
    • E、materialized view log recommendations

    正确答案:A,C,D,E

  • 第22题：

    单选题
    The ADMIN_EMP table has columns EMPNO， ENAME， DEPTNO， and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.  What action is required for the dependent objects when you perform online redefinition on the table？（）
    A

     The materialized view should have a complete refresh performed after the online table redefinition is completed.

    B

     The materialized view should have a fast refresh performed after the online table redefinition is completed.

    C

     The materialized view，materialized log，and the index should be dropped and re-created after the online table redefinition is complete.

    D

     The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.


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

  • 第23题：

    单选题
    Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature？（）
    A

     Segment Advisor

    B

     SQL Access Advisor

    C

     Undo Advisor

    D

     SQL Tuning Advisor


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

相关内容