Which three are true about the SQL Tuning Advisor? (Choose three.)
Which three are true about the SQL Tuning Advisor? (Choose three.)
The SQL Tuning Advisor checks each query being analyzed for stale and missing statistics to ensure optimal execution plans. It can recommend semantic changes to SQL statements, addressing logic and structural issues that could lead to suboptimal performance. While it can consider multiple SQL statements as a group, it does not exclusively build SQL profiles for each poorly performing SQL statement.
I think ABD
Agree with ABD
Semantic changes????? I think is ABF, because can build SQL profiles
depends on who SQL Prof. is runing, it's only true for auto mode , in manual it is only recomendation.
ABD https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/sql-tuning-advisor.html#GUID-CB843CA1-6160-4918-BC71-86E36775EF15 AB - If these statistics are stale or missing, then the optimizer can generate suboptimal plans. Automatic Tuning Optimizer checks for missing or stale statistics, and recommends gathering fresh statistics if needed. D - During structural analysis, Automatic Tuning Optimizer tries to identify syntactic, semantic, or design problems that can lead to suboptimal performance. The goal is to identify poorly written SQL statements and to advise you how to restructure them. not c - only recommends syntactic changes
i think this is well answered, ABF
ABD https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning-advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673
Agree, it is ABD.
Correct:A,B,D
abf is correct
I vote for ABD
Not F "for improving performance of high-load SQL statements" NOT "for each poorly performing SQL statement" https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning-advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673 SQL Tuning Advisor is a mechanism for resolving problems related to suboptimally performing SQL statements. Use SQL Tuning Advisor to obtain recommendations for improving performance of high-load SQL statements, and prevent regressions by only executing optimal plans.
ABF https://docs.oracle.com/en/database/oracle/oracle-database/18/tgsql/sql-tuning-advisor.html#GUID-6677340C-7DB3-4F0E-9921-46687E5EDC78
https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/sql-tuning-advisor.html#GUID-73AB38C1-A7F6-401E-9010-B4476E173673
B and D
abf it is!
i change to ABD! it will not create a profile for EACH poorly, e.g. one time queries. further: µµThe Automatic Tuning Optimizer identifies common problems with structure of SQL statements than can lead to poor performance. These could be syntactic, semantic, or design problems with the statement.
It's ABF.
i think abd
A B F: "F" because the question is related to "SQL Tuning Advisor" not to the "Automatic" one. Therefore the following applies: "SQL profiles are created when a DBA invokes SQL Tuning Advisor." (https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/managing-sql-profiles.html#GUID-1AC3C45E-331A-4016-8FE8-7FEFFD8D7220) "D" is false because it can recommend syntactic, not semantic, restructuring
F is saying for each poor ... D. Is saying "can" Probably they are A, B, D the correct answers.
i think this is well answered, ABF
D should be correct according to: https://docs.oracle.com/en/database/oracle/oracle-database/19/tgsql/sql-tuning-advisor.html#GUID-982EB0FC-AADD-4741-B0AA-79005C3AF657