当前位置:1Z0-060题库

问题:

[单选]

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.

影响绝缘油的绝缘强度的主要因素是()。 油中含杂质水分。 油中含酸值偏高。 油中氢气偏高。 简述电子签名与传统签名的功能比较。 You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?() Event Viewer gives more details on the failure.。 The alert log file gives detailed information about the failure.。 PMON rolls back the transaction and releases the locks.。 SMON rolls back the transaction and releases the locks.。 The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.。 Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.。 丁烷罐在冬季由于罐压及罐温度都比较低,故为保证丁烷配比泵正常运行需() 打开液化气罐和丁烷罐平衡气管线上阀门充压。 控制丁烷配比泵出口流量。 简述命名空间的两种引用方式。

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?()

参考答案: C

  参考解析

本题暂无解析

在线 客服