- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
91.
When you are upgrading a database to Oracle Database 12c, which of the following
options are true?
- A.Any version of an Oracle 10g or Oracle 11g database can be upgraded to Oracle Database 12c using DBUA.
- B.Only the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, and 11.2.0.4 can be upgraded to 12.1.0.
- C.Once upgraded to Oracle Database 12c, the upgraded database can only be downgraded to Oracle 11g.
- D.When a 10.2.0.5 database is upgraded to Oracle Database 12c, it cannot be downgraded.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Oracle Database 12c gives the option to do a direct upgrade for all versions mentioned in option B, and not all versions as specified in option A. Option C is not correct because you cannot downgrade to any version of Oracle 11g. The lowest version you can down- grade to is 11.1.0.7 if you upgrade an 11g R1 or 10g R2 database. For 11.2 databases, you can downgrade to the version from which you upgraded. Although a 10.2.0.5 data- base cannot be downgraded back to 10.2.0.5, it can be downgraded to 11.1.0.7, which might not be useful for your business. |
92.
Which is the best option for upgrading an Oracle 10g R2 database that is in its
terminal release to Oracle Database 12c?
- A.Use Data Pump utilities to export and import.
- B.Perform a direct upgrade using DBUA.
- C.Upgrade to 11g 11.1.0.7 or 11.2.0.2 using DBUA, and then upgrade the database to 12.1.0 using Oracle Database 12c DBUA.
- D.Run catctl.pl script on the Oracle 10g instance, and then start the instance in Oracle Database 12c.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The terminal release of Oracle 10g R2 is 10.2.0.5. Oracle Database 12c supports a direct upgrade from the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, and higher. |
93.
When you’re using DBUA to upgrade a database from Oracle 10g, which of the following
activities are not performed by DBUA? (Choose two.)
- A.Perform the pre-upgrade steps.
- B.Change listener.ora to configure the new Oracle home directory information.
- C.Disable archiving during the upgrade.
- D.Back up the database after the upgrade
- E.Recompile any invalid objects.
- F.Lock the new user accounts that were created.
- G.Adjust the initialization parameter values.
- H.Remove the deprecated initialization parameters.
- Answer & Explanation
- Report
Answer : [C, D]
Explanation :
Explanation :
| DBUA has an option to back up the database prior to the upgrade. It’s up to you to back up the database after the upgrade is completed. There is no option to disable archiving during the upgrade. In fact, Oracle encourages you to run the database in ARCHIVELOG mode with flashback on, and DBUA can create a guaranteed restore point as a backup method during the upgrade. |
94.
When you’re performing a manual upgrade to Oracle Database 12c, in what order are
the following steps performed?
1. Run catctl.pl .
2. Run preupgrd.sql .
3. Run utlu121s.sql .
4. Start the database using the STARTUP UPGRADE option.
5. Start the database using the STARTUP NORMAL option.
1. Run catctl.pl .
2. Run preupgrd.sql .
3. Run utlu121s.sql .
4. Start the database using the STARTUP UPGRADE option.
5. Start the database using the STARTUP NORMAL option.
- A.2, 5, 1, 4, 2
- B.2, 4, 1, 5, 3
- C.4, 2, 1, 5, 3
- D.5, 2, 4, 1, 3
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The first step is to run the Pre-Upgrade Information utility preupgrd.sql . When you are ready to upgrade, start the database using STARTUP UPGRADE . The catctl.pl script performs the database upgrade and shuts down the database. Then start up the database and perform utlu121s.sql . |
95.
Which of the following statements regarding the Pre-Upgrade utility preupgrd.sql are
correct? (Choose two.)
- A.It checks for space availability, user conflicts, role conflicts, initialization parameters, etc., and prepares fix-up scripts to take care of all issues.
- B.The Pre-Upgrade Information utility does not make any changes to the database, but merely reports results.
- C.preupgrd.sql is a standalone script and can be copied to another location to exe- cute on the database to be upgraded.
- D.It recommends the amount of free space required in the SYSTEM and SYSAUX tablespaces.
- Answer & Explanation
- Report
Answer : [B, D]
Explanation :
Explanation :
| The Pre-Upgrade Information utility does not make any changes to the database. The utility creates a fix-up script that can be used to make trivial changes to the data- base. Not all issues can be fixed by the fix-up script; therefore, option A is not correct. The tool is comprised of preupgrd.sql and utluppkg.sql scripts, so you need to copy both scripts. |
|
|
||||||||||||||||||||||||||||
