Which two statements are true in this situation?

While creating an Oracle 10g Release 1 (10.1) database, you set the COMPATIBLE parameter to 10.0.0 in the initialization parameter file. Which two statements are true in this situation? (Choose two)

While creating an Oracle 10g Release 1 (10.1) database, you set the COMPATIBLE parameter to 10.0.0 in the initialization parameter file. Which two statements are true in this situation? (Choose two)

A.
You can use all the new features in 10g.

B.
You can change the setting of the COMPATIBLE parameter to 9.2.0.2.

C.
You can advance the compatibility of your database with the COMPATIBLE initialization parameter.

D.
You can assign any value to the COMPATIBLE parameter, but the parameter would still take the default values as 10.0.0.

Explanation:
The COMPATIBLE initialization parameter enables or disables the use of features in the database that affect file format on disk. For example, if you create an Oracle Database 10 g database, but specify COMPATIBLE = 9.2.0.2 in the initialization parameter file, then features that requires 10.0 compatibility will generate an error if you try to use them.
Such a database is said to be at the
9.2.0.2 compatibility level. You can advance the compatibility level of your database. If you do advance the compatibility of your database with the COMPATIBLE initialization parameter, there is no way to start the database using a lower compatibility level setting, except by doing a point-in-time recovery to a time before the compatibility was advanced..

REF: Oracle(r) 10g Administrator Guide , 2-34



Leave a Reply 1

Your email address will not be published. Required fields are marked *


networkmanagers

networkmanagers

Correct answer is