Which statement regarding the COMPATIABLE parameter is correct?
A.
It is dynamic parameter.
B.
It is an advanced parameter
C.
It is a new parameter in Oracle 10G
D.
It can have any value between 8:0:0 and 10.1.0 in Oracle 10G database
E.
After is set to 10.0.0 or greater and the database is opened, it cannot be set back.
Explanation:
The default value is 10.2.0. The minimum value is 9.2.0. If you create an Oracle Database using the default value, you can immediately use all the new features in this
release, and you can never downgrade the database.REF: Oracle(r) 10g Administrator Guide , 2-34