Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/checklists-for-oracle-database-upgrade.html#GUID-2DB48303-DC1E-41CD-831D-864D76BD8061
Use this checklist to prepare your server with the earlier Oracle Database release before you start the upgrade:
Clean up the database: Empty the recycle bin,Check for INVALID objects in SYS and SYSTEM, Check for duplicate objects in SYS and SYSTEM
Gather dictionary statistics: To decrease Oracle Database downtime, gather optimizer statistics.
I would definitely choose D,E
A- just not correct
B- while this can be done it is not an action that MUST be done prior to beginning in upgrade. You will have to do this again post-upgrade anyway as best practice
C- definitely wrong. You set this parameter post-upgrade. Even then, it is best practice not to set this parameter immediately after an upgrade but for some time after. Waiting to set it ensures we can downgrade to our previous version if needed in case of an error.
D- Oracle doc states this as a task to complete before an upgrade
E- same as above
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/database-preparation-tasks-to-complete-before-upgrades.html#GUID-58C1A4B9-32F4-44E5-B82B-5D0EC78A6AE2
i will choose DE
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/database-preparation-tasks-to-complete-before-upgrades.html#GUID-6719608D-F145-403C-8CCE-CF23120BCC2A
DE
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/database-preparation-tasks-to-complete-before-upgrades.html#GUID-46F09541-C36A-4790-B3D3-E0E336A7BBC3
I think its BD
Gather dictionary statistics
Purge the recycle DBA_RECYCLEBIN NOT USER_RECYCLEBIN
https://oracle-base.com/articles/12c/upgrading-to-12c#prerequisites
C is correct
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/what-is-oracle-database-compatibility.html#GUID-7FCE8614-8163-4393-AE66-2ADD1F73934F
I do not think C is correct. The link you posted states "Compatibility Initialization parameter to be set to at least 11.2.0" so I think B and E are the correct answers.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Ray520
1 year, 10 months agoRay_gk
1 year, 11 months agojackymak
1 year, 11 months agoKhel
2 years, 4 months agoboardgames
2 years, 4 months agokatetel
2 years, 7 months agomuchiry
2 years, 9 months agoRaschold
3 years, 4 months agoIamGo0ke
2 years, 11 months agoexampro46
2 years, 9 months agotaiyang
4 years agotaiyang
4 years agohggz
3 years, 11 months ago