多项选择题X 纠错
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.
你可能喜欢
单项选择题
A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management (ASM) instance on behalf of the databaseinstance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
单项选择题
A.Insert finding directives for ADDM tasks in the future.
B.Create a baseline on a pair of snapshots spanning the peak-load period.
C.Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.
D.Set the snapshot retention period in the Automatic Workload Repository (AWR) to zero to avoid automatic purging of snapshots.
单项选择题
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.
单项选择题
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.
多项选择题
A.DDL statements can be audited.
B.Statements that refer to stand-alone procedure can be audited.
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 executedmore than once.
单项选择题
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.Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT.
B.Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users.
C.One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session.
D.One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E.One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.
单项选择题
A.Apply fine-grained auditing.
B.Implement value-based auditing.
C.Impose standard database auditing to auditobject privileges.
D.Impose standard databaseauditing to audit SQL statements.
单项选择题
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
多项选择题
A.the retention period to support flashback
B.the expected length of the longest-running query
C.the number of undo tablespaces in the database
D.the size of the Flash Recovery Area for the database instance