Which two statements regarding a SQL profile are true?（）

• A、It is built by Automatic Tuning Optimizer.
• B、It cannot be stored persistently in the data dictionary.
• C、It can be used by the query optimizer automatically.
• D、It can be created manually by using the CREATE PROFILE command.