Which statement regarding the COMPATIBLE parameter is correct?
A.
It is a new parameter in Oracle 10g.
B.
It can have any value between 8.0.0and 10.1.0 in Oracle 10g database.
C.
After it is set to 10.0.0 or greater and the database is opened, it cannot be set back.
D.
It is a dynamic parameter.
E.
It is an advanced parameter.
Explanation: