OCA OCP Oracle Certification Exam Braindumps

1 You executed the following SQL statement to change the goal of the cost-based optimizer (CBO): What will be the result of this statement?
A.The goal of the CBO for the current session is set to best throughput.
B.The optimizer uses a cost-based approach for all SQL statements in the session   provided the statistics are available.
C.It will result in an error because the goal of the CBO cannot be changed at the session level.
D.The goal of the CBO for the current session is set to find the best plan for fast delivery of all the rows while using a mix of cost and heuristics.
ANSWER: A

High quality and Value for the1z0-033 Exam.Killtest Practice Exams for Oracle9i Database:Performance Tuning 1z0-033 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.100% Guarantee to Pass Your 9i DBA exam and get your 9i DBA Certification.We guarantee your success in the first attempt. If you do not pass the 1z0-033 exam (Oracle9i Database:Performance Tuning) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. TestPassport will help you to pass the 1z0-033 exam. TestPassport 1z0-033 contains 192 questions, multiple choice answers.

2. Which two statements are true regarding the statistics used by the optimizer to   generate an optimal plan? (Choose two.)
A.The statistics collected through a histogram are not useful for better selectivity estimates of unevenly distributed data.
B.Dynamic sampling is preferred when the cost of collecting the sample statistics outweighs the advantage of a better execution plan.
C.The maximum and minimum values collected by the column statistics leads to an optimal plan if there is an even distribution of data between those two values.
D.The statistics collected through a histogram are useful if the data distribution is skewed between minimum and maximum values.
ANSWER: CD