Which statement regarding the COMPATIBLE parameter is correct?
A.
It is a dynamic parameter.
B.
It is an advanced parameter.
C.
It is a new parameter in Oracle 10g.
D.
It can have any value between8.0.0 and 10.1.0 in Oracle 10g database.
E.
After it is set to 10.0.0 or greater and the database is opened, it cannot be set back.
Explanation:
The default value for the COMPATIBLE parameter is the release number of the most recent major release, in Oracle 10G R2 , 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