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.
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.
相关考题：
（ ）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
( ) languages enable nonprogrammer to use certain easily understood commands to search and generate reports from a database.A.MachineB.AssemblyC.High-levelD.Query
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.taskB.workC.sequenceD.activity
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.specificationB.rulesC.estimatesD.designs
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.deadlineB.specificationC.expectationD.requirement
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 singleB.a particularC.someD.all
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.perfectB.acceptableC.controlleD.compl
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.perfectB.acceptableC.controlledD.completed
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.taskB.workC.sequenceD.activity
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.specificaB.rulesC.estimatesD.designs