20151228 ocp 053 1-30

4.which two statements about the sql management base(SMB) are true ?

c.it is part of the data dictionary and stored in the syssaux tablespace

e.it contains the statement log,the plan history,plan baselines ,and sql profiles

The SQL managementbase (SMB) is a part of the data dictionary that resides in the SYSAUX tablespace. Itstores statement logs, plan histories, SQL plan baselines, and SQL profiles. Toallow weekly purging of unused plans and logs, the SMB uses automatic spacemanagement.

You can also add plansmanually to the SMB for a set of SQL statements. This feature is especiallyuseful when upgrading the database from a version before Oracle Database11g because it helps to minimize plan regressions resulting from the useof a new optimizer version.

Because the SMB is located entirelywithin SYSAUX, the database does not use SQL planmanagement and SQL tuning features when this tablespace is unavailable.

 

6.which three statements about performance analysis by sql performance analyzer are true?

a.it detects changes in sql execution plans.

b.it produces results that can be used to create the sql plan nbaseline

d.it generates recommanedations to run sql tuning advisor to tune regressed sqls

7.when executing a sql workload,you choose to generate execution plans only,without collecting execution statistics

which two statements describe the implications of this?

a.it produces less accurate results of the comparison analysis

c.it shortens the time of execution and reduces the impact on system resources

8.which of these appropriately describes the results of a manual sq ltuning advisor 

a. a list of sql statements and recommendations for tuning

关键词 tuning

9.to view the results of a manual sql tuning advisor task,which steps should the dba take?

a.from the advisor central home page.select the tuning task from the advisor tasks section

10.to view the results of the most recent automatic sql tuning advisor task.which sequence should 

you follow?

b.em database home page.software and support .advisor cental.sql advisors automatic sql tuning advisor

c.em database home page ,software and surpport,support workbench,advisor central,sql advisors,automatic sql tuning advisor

进入指导中心就可以进去sql指导，然后在sql优化指导

11.which of the follolwing identifies and creates an index to minimize the DBtime for a particular sql statement

c.the sql tuning advisor

识别和创建索引以尽量减少db时间为特定的sql语句

sql优化指导，分析各个sql语句，并建议sql概要文件，统计信息，索引和重构以改善sql性能

12.which of the following advisors is run in every maintenance window by the auto-task system?

b.the sql tuning advisor

自动sql优化将在系统维护窗口期间作为自动维护任务运行，搜索改进高负载sql语句的执行计划的方法

14.you have a very large table that your users access fewquently .which of the following advisors will recommend any indexes to improve the performance of queries aganst this table

d.the sql access advisor

sql访问指导，评估sql的全部工作量，并建议索引，分区和实体化视图，他们将改善sql工作量的总体性能

15.which tasks are run automatically as part of the automated maintenance task by default?

a.segment advisor

b.sql access advisor

d.automatic sql tuning advisor

16.which statement most accrurately describe the implementation of as sql acdess advisor

b.individual sql access advisor recommnadations can be scheduled for implementation

18what two statemenbts are true regarding the recommendations received from the sql acess advisor

b.it can recommend partionaing on tables provided that the workloads have some predicates and joins on the culumns of the number or date type

c.it can recommend partioning only on tables that have at least 10000 rows

18.what recommendations does the sql access advisor provide for optimiziong sql aueries?

c.creation of index-organized tables

d.creation of bitmap,function-base and b_tree indexws

e.optimization pf materialized views for maxinum query usage and fast refresh