A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance

题目

A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）

A. Execute the query and view Active Session History (ASH) for information about the query.

B. Enable SQL trace for the query.

C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

相似考题

1.（ ）languages enable nonprogrammer to use certain easily understood commands to search and generate reports from a database.A. Machine B. Assembly C. High-level D. Query

2.A project is a[temporary]（请作答此空）of unique,complex,and connected activities having one goal or purpose and that must be completed by a specific time,within budget,and according to（ ）.Project management is the process of scoping,planning,staffing,organizing,directing,and controlling the development of a（n）（ ）system at a minimum cost within a specified time frame.For any systems development project,effective project management is necessary to ensure that the project meets the（ ）,is developed within an acceptable budget,and fulfills customer expectations and specifications,Project management is a process that starts at the beginning of a project,extends through a project,and doesn't culminate until the project is completed.The prerequisite for good project management is a well-defined system development process.Process management is an ongoing activity that documents,manages the use of,and improves an organization s chosen methodology（the“process”）for system development,Process management is concerned with the activities,deliverables,and quality standards to be applied to（ ）project（s）.A.task B.work C.sequence D.activity

3.A project is a[temporary]（ ）of unique,complex,and connected activities having one goal or purpose and that must be completed by a specific time,within budget,and according to（请作答此空）.Project management is the process of scoping,planning,staffing,organizing,directing,and controlling the development of a（n）（ ）system at a minimum cost within a specified time frame.For any systems development project,effective project management is necessary to ensure that the project meets the（ ）,is developed within an acceptable budget,and fulfills customer expectations and specifications,Project management is a process that starts at the beginning of a project,extends through a project,and doesn't culminate until the project is completed.The prerequisite for good project management is a well-defined system development process.Process management is an ongoing activity that documents,manages the use of,and improves an organization s chosen methodology（the“process”）for system development,Process management is concerned with the activities,deliverables,and quality standards to be applied to（ ）project（s）.A.specification B.rules C.estimates D.designs

4.( ) languages enable nonprogrammer to use certain easily understood commands to search and generate reports from a database.A.Machine B.Assembly C.High-level D.Query

参考答案和解析
参考答案：C
更多“A new report process containing a complex query is written, with high impact on the databa ”相关问题

  • 第1题：

    A project is a[temporary]（ ）of unique,complex,and connected activities having one goal or purpose and that must be completed by a specific time,within budget,and according to（ ）.Project management is the process of scoping,planning,staffing,organizing,directing,and controlling the development of a（n）（ ）system at a minimum cost within a specified time frame.For any systems development project,effective project management is necessary to ensure that the project meets the（请作答此空）,is developed within an acceptable budget,and fulfills customer expectations and specifications,Project management is a process that starts at the beginning of a project,extends through a project,and doesn't culminate until the project is completed.The prerequisite for good project management is a well-defined system development process.Process management is an ongoing activity that documents,manages the use of,and improves an organization s chosen methodology（the“process”）for system development,Process management is concerned with the activities,deliverables,and quality standards to be applied to（ ）project（s）.

    A.deadline
    B.specification
    C.expectation
    D.requirement

    答案：A
    解析：
    表示截止日期的意思。
    附（参考翻译）：一个项目是一个独特的、复杂的、相互关联的活动的[临时]序列，有一个目标或目的，必须在特定的时间、预算内和根据规范完成。项目管理是一个范围界定、计划、人员配置、组织、指导和控制可接受系统开发的过程，在规定的时间内以最低的成本进行。对于任何系统开发项目，有效的项目管理都是必要的，以确保项目在截止日期前完成，在可接受的预算内开发，并满足客户的期望和规范，项目管理是从项目开始时开始的过程，延伸到一个项目中，直到项目完成才达到顶点。良好的项目管理的先决条件是定义良好的系统开发过程。过程管理是一项持续的活动，它记录、管理和改进组织为系统开发所选择的方法（“过程”），过程管理涉及应用于所有项目的活动、可交付成果和质量标准。

  • 第2题：

    A project is a [temporary] （ ） of unique, complex, and connected activities having one goal or purpose and that must be completed by a specific time, within budget, and according to （ ）Project management is the process of scoping, planning, staffing, organizing, directing, and controlling the development of a（n） （请作答此空） system at a minimum cost within a specified time frame.
    For any systems development project, effective project management is necessary to ensure that the project meets the （ ）, is eveloped within an acceptable budget, and fulfills customer expectations and specifications, Project management is a process that starts at the beginning of a project, extends through a project, and doesn't culminate until the project is completed.
    The prerequisite for good project management is a well-defined system development process. Process management is an ongoing activity that documents, manages the use of, and improves an organization s chosen methodology （the"process"）for system development, Process management is concemed with the activities, deliverables, and quallty standards to be applled to （ ） project（s）.

    A.perfect
    B.acceptable
    C.controlle
    D.compl

    答案：B
    解析：

  • 第3题：

    A project is a [temporary] （请作答此空） of unique, complex, and connected activities having one goal or purpose and that must be completed by a specific time, within budget, and according to （
    Project management is the process of scoping, planning, staffing, organizing, directing, and controlling the development of a（n） （ ） system at a minimum cost within a specified time frame.
    For any systems development project, effective project management is necessary to ensure that the project meets the （ ）, is eveloped within an acceptable budget, and fulfills customer expectations and specifications, Project management is a process that starts at the beginning of a project, extends through a project, and doesn't culminate until the project is completed.
    The prerequisite for good project management is a well-defined system development process. Process management is an ongoing activity that documents, manages the use of, and improves an organization s chosen methodology （the"process"）for system development, Process management is concemed with the activities, deliverables, and quallty standards to be applled to （ ） project（s）.

    A.task
    B.work
    C.sequence
    D.activity

    答案：C
    解析：

  • 第4题：

    A project is a[temporary]（ ）of unique,complex,and connected activities having one goal or purpose and that must be completed by a specific time,within budget,and according to（ ）.Project management is the process of scoping,planning,staffing,organizing,directing,and controlling the development of a（n）（ ）system at a minimum cost within a specified time frame.For any systems development project,effective project management is necessary to ensure that the project meets the（ ）,is developed within an acceptable budget,and fulfills customer expectations and specifications,Project management is a process that starts at the beginning of a project,extends through a project,and doesn't culminate until the project is completed.The prerequisite for good project management is a well-defined system development process.Process management is an ongoing activity that documents,manages the use of,and improves an organization s chosen methodology（the“process”）for system development,Process management is concerned with the activities,deliverables,and quality standards to be applied to（请作答此空）project（s）.

    A.a single
    B.a particular
    C.some
    D.all

    答案：D
    解析：
    表示过程管理涉及应用于所有项目的活动。附（参考翻译）：一个项目是一个独特的、复杂的、相互关联的活动的[临时]序列，有一个目标或目的，必须在特定的时间、预算内和根据规范完成。项目管理是一个范围界定、计划、人员配置、组织、指导和控制可接受系统开发的过程，在规定的时间内以最低的成本进行。对于任何系统开发项目，有效的项目管理都是必要的，以确保项目在截止日期前完成，在可接受的预算内开发，并满足客户的期望和规范，项目管理是从项目开始时开始的过程，延伸到一个项目中，直到项目完成才达到顶点。良好的项目管理的先决条件是定义良好的系统开发过程。过程管理是一项持续的活动，它记录、管理和改进组织为系统开发所选择的方法（“过程”），过程管理涉及应用于所有项目的活动、可交付成果和质量标准。

  • 第5题：

    A project is a[temporary]（ ）of unique,complex,and connected activities having one goal or purpose and that must be completed by a specific time,within budget,and according to（ ）.Project management is the process of scoping,planning,staffing,organizing,directing,and controlling the development of a（n）（请作答此空）system at a minimum cost within a specified time frame.For any systems development project,effective project management is necessary to ensure that the project meets the（ ）,is developed within an acceptable budget,and fulfills customer expectations and specifications,Project management is a process that starts at the beginning of a project,extends through a project,and doesn't culminate until the project is completed.The prerequisite for good project management is a well-defined system development process.Process management is an ongoing activity that documents,manages the use of,and improves an organization s chosen methodology（the“process”）for system development,Process management is concerned with the activities,deliverables,and quality standards to be applied to（ ）project（s）.

    A.perfect
    B.acceptable
    C.controlled
    D.completed

    答案：B
    解析：
    表示可接受的、认可的、令人满意的意思。
    附（参考翻译）：一个项目是一个独特的、复杂的、相互关联的活动的[临时]序列，有一个目标或目的，必须在特定的时间、预算内和根据规范完成。项目管理是一个范围界定、计划、人员配置、组织、指导和控制可接受系统开发的过程，在规定的时间内以最低的成本进行。对于任何系统开发项目，有效的项目管理都是必要的，以确保项目在截止日期前完成，在可接受的预算内开发，并满足客户的期望和规范，项目管理是从项目开始时开始的过程，延伸到一个项目中，直到项目完成才达到顶点。良好的项目管理的先决条件是定义良好的系统开发过程。过程管理是一项持续的活动，它记录、管理和改进组织为系统开发所选择的方法（“过程”），过程管理涉及应用于所有项目的活动、可交付成果和质量标准。

  • 第6题：

    A project is a [temporary] （ ） of unique, complex, and connected activities having one goal or purpose and that must be completed by a specific time, within budget, and according to （请作答此空）Project management is the process of scoping, planning, staffing, organizing, directing, and controlling the development of a（n） （ ） system at a minimum cost within a specified time frame.
    For any systems development project, effective project management is necessary to ensure that the project meets the （ ）, is eveloped within an acceptable budget, and fulfills customer expectations and specifications, Project management is a process that starts at the beginning of a project, extends through a project, and doesn't culminate until the project is completed.
    The prerequisite for good project management is a well-defined system development process. Process management is an ongoing activity that documents, manages the use of, and improves an organization s chosen methodology （the"process"）for system development, Process management is concemed with the activities, deliverables, and quallty standards to be applled to （ ） project（s）.

    A.specifica
    B.rules
    C.estimates
    D.designs

    答案：A
    解析：

相关内容