The safer , easier way to help you pass any IT exams.
in data are not tracked. You decide to keep track of both the old data and new data in the table along with
记录；跟踪；与…保持联系
the user information.
What action would you take to achieve this task? A.Apply fine-grained auditing.
adj. 细粒的；有细密纹理的；细粒度
B.Implement value-based auditing.
C.Impose standard database auditing to audit object privileges. D.Impose standard database auditing to audit SQL statements. vt. 强加；征税；以…欺骗 vi. 利用；欺骗；施加影响
Answer: B
37. You execute the following command to audit database activities:
SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL; What is the effect of this command?
A.One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B.One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT. Answer: C
38. To make audit information more productive, the DBA executes the following command before starting
adj. 能生产的；生产的，生产性的；
an 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 the database?
A.It contains only the plan for the SQL statement executed by the user.
16 / 86
The safer , easier way to help you pass any IT exams.
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.
与…有关系；与…相联系；associate with v. 联合；与…联系在一起；和…来往
D.It contains the plan for the SQL statement executed by the user and the bind variables used with it. Answer: B
39. Which two statements are true about standard database auditing? (Choose two.) A.DDL statements can be audited.
B.Statements that refer to stand-alone procedure can be audited. n. 独立；单机 adj. 独立的；独立操作的
C.Operations by the users logged on as SYSDBA cannot be audited.
D.Only one audit record is ever created for a session per audited statement even though it is executed
虽然，即使
more than once. Answer: AB
40. You have statistics collected for some selected tables. Your requirement is that the statistics for the
v. 收集；聚集（collect的过去式）
tables and all dependent indexes must not be overwritten by further statistics collection until a certain
adj. 依靠的；依赖的；从属的；取决于…的
adj. 覆盖的；重写的
point of time.
How would you achieve this? A.Lock statistics for the tables.
可以使用DBMS_STATS.LOCK_TABLE_STATS过程
B.Change STALE_PERCENT to zero for the tables. C.Set the TIMED_STATISTICS parameter to TRUE. D.Set the STATISTICS_LEVEL parameter to BASIC.
E.Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE. Answer: A
41. You have recently collected statistics on certain objects of a schema in your database. But you
vt. 观察；注意到adj. 次最优的；最适度下的；
observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.
Which action would help to use the previous set of statistics on the objects? A.Restore statistics from statistics history.
B.Reduce the optimizer statistics retention period by 2 days.
17 / 86
The safer , easier way to help you pass any IT exams.
C.Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.
D.Reduce the Automatic Workload Repository (AWR) retention period by 2 days. Answer: A
42. Examine the command:
SQL> DBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH', 'false'); Which statement describes the effect of the above command? A.Automatic statistics collection is stopped for the CUSTOMERS table. B.Statistics for the CUSTOMERS table are locked and cannot be overwritten.
C.Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D.Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics. Answer: D
43. In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting?
n. 影响；效果；碰撞；冲击力
A.Optimizer statistics are collected automatically.
B.Only timed operating system (OS) statistics and plan execution statistics are collected. C.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically. D.Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package. E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization. Answer: C
44. Your database is functional with a peak load for the last one hour. You want to preserve the
最大负载
n. 比较；对照；
vt. 保存；保护；维持
performance statistics collected during this period to be used for comparison when you analyze the performance of the database in the future. What action would you take to achieve this task? A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period. vt. 跨越；持续；
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
18 / 86
The safer , easier way to help you pass any IT exams.
D.Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots. v. 清除（purge的ing形式）
Answer: B
45. Which statement is true about the Manageability Monitor (MMON) background process? A.It transfers statistics from memory to disk at regular intervals.
每隔一定时间（距离）
regular adj. 定期的；有规律的；合格的 interval n. 间隔；间距；幕间休息
B.It coordinates the rebalance activity for disk groups when ASM is used.
vt. 调整；整合
C.It communicates with the Automatic Storage Management (ASM) instance on behalf of the database 代表；为了
instance.
behalf n. 代表；利益
D.It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance. Answer: A
46. Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.)
A.The ADDM requires at least four AWR snapshots for analysis.
B.The ADDM runs after each AWR snapshot is collected automatically by MMON.
C.The results of the ADDM analysis are stored in the Automatic Workload Repository (AWR). D.The ADDM analysis provides only diagnostic information but does not provide recommendations. E.The ADDM calls other advisors if required, but does not provide recommendations about the advisors. Answer: BC
47. Your database instance is functional for the past one month. The Automatic Workload Repository (AWR) snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL.
You receive a complaint about the poor performance of the database between 7 PM and 9 PM of the
投诉；对…抱怨
previous day.
Choose two actions any of which can be referred to first to diagnose the problem. (Choose two.) A.Use the Active Session History report. B.Use the AWR Compare Periods report.
19 / 86
The safer , easier way to help you pass any IT exams.
C.Use an ADDM analysis between 7 PM and 9 PM of the previous day.
D.Use the AWR Compare Period report between 7 PM and 9 PM of the previous day. Answer: BC
48. The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?
A.The statistics collection continues until all objects are processed.
B.The job is terminated and the statistics collected are restored to a time before the job started.
C.This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
D.The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened. Answer: D
49. View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. 20 / 86
OCP题库及模拟考试2
