单项选择题
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.
单项选择题 Examine the command: SQL> DBMS_STATS.SET_TABLE_PREFS(’SH’, ’CUSTOMERS’, ’PUBLISH’, ’false’); Which statement describes the effect of the above command()
多项选择题 Whichtwostatementsaretrueaboutstandarddatabaseauditing()
单项选择题 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()