- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
96.
Which two options are not true with the STARTUP UPGRADE mode instance startup?
- A.It initiates the upgrade process automatically after the instance is started.
- B.It suppresses spurious and unnecessary error messages, especially the ORA-00942 .
- C.It handles certain system startup parameters that could interfere with the upgrade.
- D.This option is more of a documentation purpose when the database is started for upgrade. Its functionality is no different than the default STARTUP option.
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
| STARTUP UPGRADE is the only way you can bring up an instance prior to upgrading the database. You still need to upgrade the database using the upgrade scripts after start- ing up the database. This is not just for documentation; it differs from STARTUP NORMAL . |
97.
When you click the Restore Database button on the Upgrade Results page, which
options must be true to perform a complete restore?
- A.The database is upgraded from 11.2 release to Oracle Database 12c.
- B.The database must be backed up using DBUA.
- C.The COMPATIBLE parameter value must be 11.2.0.
- D.The database must be backed up prior to the upgrade.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| DBUA performs a restore from the backup it created prior to the upgrade; it restores the database files and configuration files from the backup location. For this, you should choose the Use RMAN backup option or the Use Flashback and Guaranteed Restore Point option in the Recovery Options screen |
98.
Which of the following database options must be upgraded individually when you’re
upgrading the database using the manual method?
- A.JServer Java Virtual Machine
- B.Oracle Real Application Clusters
- C.Oracle XML Database
- D.All of the above
- E.None of the above
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| Oracle Database 12c has a very simplified upgrade process that determines all the components of the database to be upgraded and automatically upgrades them. Oracle uses DBMS_REGISTRY to identify the components to be upgraded. |
99.
Which mechanism is used by Oracle to identify the components that need to be upgraded
while upgrading a database?
- A.V$OPTION
- B.V$LICENSE
- C.DBMS_REGISTRY
- D.DBMS_OPTIONS
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| DBMS_REGISTRY is used by Oracle to keep the status of components loaded to the database. You can query DBA_REGISTRY to see all the components and their status. It also provides the schema owner of the component and the script to run if a component is invalid. |
100.
Before manually upgrading an 11.1.0.7 database, what should be the appropriate value
of the COMPATIBLE parameter? The current value is the default and is not specified in
the parameter file.
- A.11.1.0.7
- B.10.2.0.5
- C.12.1.0
- D.Do not specify the COMPATIBLE parameter in the parameter file.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The minimum COMPATIBLE value for Oracle Database 12c is 11.0.0. Because the value is not set in the parameter file, the default value for the version of the database is 11.1.0. If you keep the parameter the same version as the upgraded database, you will have the opportunity to downgrade the database if something goes wrong after the upgrade; therefore, the best option is to keep the value at 11.1.0.7 during the upgrade. Option C and D are valid values, but you would lose the downgrade opportunity. The default value of the parameter is 12.0.0 if you do not specify the parameter explicitly. |
|
|
||||||||||||||||||||||||||||
