Join the discussion
Question 20/32
Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?
Correct Answer: D,E
Automatic Maintenance Tasks (AMTs) in 23ai optimize database performance. Let's explore:
A .False. SQL Access Advisor exists but isn't an AMT; it's manual or invoked separately.
B .False. SQL Performance Analyzer assesses change impacts but isn't part of AMTs.
C .False. No "Automatic Index Advisor" exists as an AMT; Auto Index is a separate feature.
D .True. The SPM Evolve Advisor task (part of ORA$AUTOTASK) automatically evolves SQL plan baselines, testing and accepting new plans.
Mechanics:Runs in maintenance windows, managed by DBMS_SPM.
E .True. SQL Tuning Advisor (STA) runs automatically via AMTs, tuning high-load SQL.
Mechanics:Identifies candidates from AWR and suggests indexes, profiles, etc.
A .False. SQL Access Advisor exists but isn't an AMT; it's manual or invoked separately.
B .False. SQL Performance Analyzer assesses change impacts but isn't part of AMTs.
C .False. No "Automatic Index Advisor" exists as an AMT; Auto Index is a separate feature.
D .True. The SPM Evolve Advisor task (part of ORA$AUTOTASK) automatically evolves SQL plan baselines, testing and accepting new plans.
Mechanics:Runs in maintenance windows, managed by DBMS_SPM.
E .True. SQL Tuning Advisor (STA) runs automatically via AMTs, tuning high-load SQL.
Mechanics:Identifies candidates from AWR and suggests indexes, profiles, etc.
Add Comments
- Other Question (32q)
- Q1. Which three Oracle database space management features will work with both Dictionary and L...
- Q2. Which two statements are true about the configuration and use of UNDO?...
- Q3. Which two account management capabilities can be configured using Oracle profiles?...
- Q4. What are Oracle Database Metrics?
- Q5. Which three statements are true about Oracle Managed Files (OMF)?...
- Q6. Which two statements are true about the UNLIMITED TABLESPACE system privilege and space qu...
- Q7. Which two Oracle database space management features require the use of locally managed tab...
- Q8. Which two are benefits of external tables?
- Q9. Which of the following is true about the status of a PDB that has been unplugged from a CD...
- Q10. Which three tasks are part of the predefined Automated Maintenance Tasks?...
- Q11. Which two statements are true about database instances and Real Application Clusters (RAC)...
- Q12. Which three statements are true about resumable space allocation in Oracle databases?...
- Q13. What are Optimizer Statistics?
- Q14. Which two statements are true about the PMON background process?...
- Q15. Which three statements are true about row chaining and row migration done by Oracle databa...
- Q16. Which statement is true about database links?
- Q17. You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. Which of...
- Q18. Script abc.sql must be executed to perform a certain task. User HR with password HR exists...
- Q19. Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf...
- Q20. Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?...
- Q21. Examine these commands: [oracle@host01 ~]$ sqlplus u1/oracle SQL> SELECT * FROM emp; EN...
- Q22. What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;...
- Q23. You must create a tablespace of nonstandard block size in a new file system and plan to us...
- Q24. In one of your databases, you create a user, HR, and then execute this command: GRANT CREA...
- Q25. Which two AWR-based tools listed below are part of Oracle Database self-tuning components?...
- Q26. Which three statements are true about dynamic performance views?...
- Q27. One of your database instances was shut down normally and then started in NOMOUNT state. Y...
- Q28. Which three statements are true about UNDO and REDO?...
- Q29. Which three statements are true about a dedicated server configuration?...
- Q30. Which two statements describe why Database Auditing is a security requirement?...
- Q31. Which three are benefits of using temp UNDO when performing DML on global temporary tables...
- Q32. What memory structure caches the data dictionary providing access to all database user pro...
