Correct Ans: B
ATP honors optimizer hints in SQL statement by default, while ADW ignores.
Reference:
ADW ignores Hints:
https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-optimizer-stats.html#GUID-69906542-4DF6-4759-ABC1-1817D77BDB02
ATP honors Hints:
https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-optimizer-stats.html#GUID-69906542-4DF6-4759-ABC1-1817D77BDB02
Answer is B
run below query in ATP and ADW. ATP gets you FALSE and ADW gets you TRUE
select value from v$parameter where name ='optimizer_ignore_hints'
ANS : B
Autonomous Data Warehouse ignores optimizer hints and PARALLEL hints in SQL statements by default.
From <https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/manage-optimizer-stats.html#GUID-69906542-4DF6-4759-ABC1-1817D77BDB02>
Autonomous Transaction Processing honors optimizer hints and PARALLEL hints in SQL statements by default.
From <https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/manage-optimizer-stats.html#GUID-69906542-4DF6-4759-ABC1-1817D77BDB02>
This section is not available anymore. Please use the main Exam Page.1z0-931 Exam Questions
Log in to ExamTopics
Sign in:
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.
tell2ami
Highly Voted 4 years, 11 months agoace03
Highly Voted 4 years, 11 months agoDhirenA
Most Recent 4 years, 9 months agoOjas_Layaskar
4 years, 10 months agojones4u
4 years, 10 months agopipolo
4 years, 11 months agovictor007
4 years, 11 months agotell2ami
4 years, 11 months ago