当前位置:1Z0-052题库

问题:

[单选]

To make audit information more productive, the DBA executes the following command before startingan audit operation: 
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; 
Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()

A . It contains only the plan for the SQL statement executed by the user.
B . It contains the SQL text executed by the user and the bind variables used with it.
C . It contains the plan and statistics associated with the SQL statement executed by the user.
D . It contains the plan for the SQL statement executed by the user and the bind variables used with it.

A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation?() The keep pool is not configured.。 Automatic Workarea Management is not configured.。 Automatic Shared Memory Management is not enabled.。 The data blocks in the SUBSCRIBE_LOG table are rarely accessed.。 All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view。 中、小型往复式压缩机一般采用滑动轴承,大型往复式压缩机一般采用滚动轴承。 Oracle JRockit JVM uses -Xns option to set nursery size when the generational garbage collection mode is used.  Which two JVM properties are affected by changing its size ?()  compaction ratio limit。  garbage collection frequency。  garbage collection times。  fragmentation heap size。 Which code, inserted at line 14, will allow this class to correctly serialize and deserialize?() s.defaultReadObject();。 this = s.defaultReadObject();。 y = s.readInt(); x = s.readInt();。 x = s.readInt(); y = s.readInt();。 社会保险基金专款专用,除领导批准的外,任何个人和组织不得侵占或者挪用。

To make audit information more productive, the DBA executes the following command before startingan audit operation: 
SQL> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; 
Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase()

参考答案:

  参考解析

本题暂无解析

在线 客服