TestPassPort 1z0-052 試験Q&A (45)

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 […]

TestPassPort 1z0-052 試験Q&A (44)

45. Which statement is true about the Manageability Monitor (MMON) background process? 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 database instance. D.It performs dynamic memory management when […]

TestPassPort 1z0-052 試験 (42)

44. Your database is functional with a peak load for the last one hour. You want to preserve the 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 […]

TestPassPort 1z0-052 試験 (41)

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 […]

TestPassPort 1z0-052 試験 (39)

40. You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this? A.Lock statistics for the tables. B.Change STALE_PERCENT to zero for the tables. C.Set the […]

TestPassPort 1z0-052 試験 (37)

38. To make audit information more productive, the DBA executes the following command before starting 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. B.It contains […]