Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.

Exam 1z0-062 topic 1 question 13 discussion

Actual exam question from Oracle's 1z0-062
Question #: 13
Topic #: 1
[All 1z0-062 Questions]

Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

  • A. the optimizer_mode initialization parameter
  • B. operating system (OS) statistics
  • C. cardinality estimates
  • D. object statistics in the data dictionary
  • E. fixed baselines
Show Suggested Answer Hide Answer
Suggested Answer: ACD 🗳️
References:

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
hggz
Highly Voted 3 years, 7 months ago
I think ADE Init parameter (A) Fixed Baseline (E) https://docs.oracle.com/database/121/TGSQL/tgsql_spm.htm#TGSQL618 C is not true. Remember, cardinality is a fancy word for “number of rows returned” by a SQL operation. http://www.dba-oracle.com/t_sql_tuning_cardinality_plan.htm
upvoted 9 times
TuxBingo
3 years ago
Agree with hggz, correct answer is: ADE
upvoted 3 times
...
...
yosiw96816
Highly Voted 3 years, 4 months ago
I agree with ACD https://docs.oracle.com/cd/E18283_01/server.112/e16638/optimops.htm
upvoted 6 times
...
jokerking
Most Recent 2 years, 5 months ago
I think ACE
upvoted 1 times
...
luizyto
2 years, 8 months ago
I think that C it's correct " Cardinality estimates must be as accurate as possible because they influence all aspects of the execution plan" https://docs.oracle.com/database/121/TGSQL/tgsql_optcncpt.htm#GUID-5D925135-6CF3-40B8-8AEF-12159055DE1F
upvoted 1 times
luizyto
2 years, 8 months ago
Ok I think is D instead of C.
upvoted 2 times
...
...
luizyto
2 years, 8 months ago
I think that C it's correct " Cardinality estimates must be as accurate as possible because they influence all aspects of the execution plan" https://docs.oracle.com/database/121/TGSQL/tgsql_optcncpt.htm#GUID-5D925135-6CF3-40B8-8AEF-12159055DE1F
upvoted 2 times
...
yukclam9
3 years, 1 month ago
C is incorrect. First we have plans then we have cardinality estimates.
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...