当前位置:1z0-043题库

问题:

[单选] In your test database, you find that a user’s session is executing a lot of SQL statements, resulting in the generation of a large number of trace files. While investigating the reason, you find that SQL trace has been enabled at the instance level. You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data being generated.How do you achieve this objective?()

A .  by setting the SQL_TRACE parameter to FALSE in the parameter file
B .  by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C .  by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D .  by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user sessio

A PL/SQL procedure queries only those columns of a redefined table that were unchanged by the online table redefinition.  What happens to the PL/SQL procedure after the online table redefinition?()  It remains valid.。  It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used.。  It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table.。  It becomes invalid only if the storage parameters have been modified and it automatically gets  revalidated the next time it is used.。 简要叙述机器设备评估的基本步骤。 Which two Oracle products come pre-packaged with Oracle’s JRockit JDK ?()  Oracle WebLogic Server。  Oracle Coherence。  Oracle Database。  Oracle Real Time Operations Control。 ()浆体在硬化初期,体积发生微小膨胀。 生石灰。 建筑石膏。 水泥。 三合土。 Observe the information in the columns:  1: The SGA     a. Text and parsed forms of all SQL statements  2: The cursor state   b. Run-time memory values for the SQL statement, such as rows retrieved  3: User-session data   c. Security and resource usage information  4:The stack space   d. Local variables for the process  Which option has the correct match between the memory areas and their contents() 1-c,2-b,3-d,4-a。 1-c,2-b,3-c,4-a。 1-a,2-b,3-c,4-d。 1-a,2-b,3-d,4-c。 In your test database, you find that a user’s session is executing a lot of SQL statements, resulting in the generation of a large number of trace files. While investigating the reason, you find that SQL trace has been enabled at the instance level. You want to disable SQL trace, remotely, only for that user session to reduce the volume of trace data being generated.How do you achieve this objective?()
参考答案:

  参考解析

本题暂无解析

在线 客服