exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 152 discussion

Actual exam question from Oracle's 1z0-083
Question #: 152
Topic #: 1
[All 1z0-083 Questions]

Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database? (Choose three.)

  • A. The Pre-Upgrade Information Tool script is executed by DBUA.
  • B. DBUA must be launched from the target Oracle Home.
  • C. All pluggable databases are automatically upgraded as part of a container database upgrade.
  • D. A whole database backup must exist before upgrade
  • E. The database must be opened in read-only mode.
  • F. Multiple databases with the same ORACLE_HOME can be upgraded simultaneously.
Show Suggested Answer Hide Answer
Suggested Answer: ACD 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
ObserverPL
Highly Voted 2 years, 8 months ago
ABC is correct. D is not correct - you just need restore point and no backup is required E is not correct - DBUA will restart your DB in UPGRADE mode automatically F is not correct - you need to choose only one database
upvoted 9 times
...
_gio_
Most Recent 6 months, 3 weeks ago
Selected Answer: ABC
Ok you can unplug a PDB and avoid to upgrade it, but I think asnwer is ABC
upvoted 1 times
...
Omnisumem
7 months, 3 weeks ago
Selected Answer: ABC
ABC is correct.
upvoted 1 times
...
mtnetmaker
1 year, 10 months ago
19c : not use Pre-Upgrade Information Tool script , 19c use AutoUpgrade using the preupgrade parameter During the prerequisite phase, DBUA runs AutoUpgrade using the preupgrade parameter (autoupgrade.jar -preupgrade -mode), which runs database checks and preupgrade fixups that fix most issues before you start an upgrade. so, A incorrect
upvoted 2 times
...
fiko666
2 years, 1 month ago
HI . WHat is the new questions in exam ? Do you have any idea?
upvoted 1 times
...
Felix_br
2 years, 3 months ago
So, as this was the last question .... Who passed the exam ? any comments ? I will be doing mine in 5 days ..
upvoted 2 times
fiko666
2 years, 1 month ago
HI.Did you pass exam?
upvoted 1 times
...
marameo
2 years, 3 months ago
i'll take the exam. how did the exam go? is the same the questions?
upvoted 1 times
Felix_br
2 years, 2 months ago
I finally did the test and passed . We have 85 questions and i had around 60 questions very similar with the questions here . the other questions all new, but easy if you study the question topics from exam. good luck
upvoted 2 times
...
...
...
nobody347
2 years, 4 months ago
Not F You can select only one database at a time. https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-307DACD9-ECEE-4079-B767-B22620B99900
upvoted 1 times
...
nobody347
2 years, 4 months ago
I am not sure about A ou can run the tool from the operating system command line. The Pre-Upgrade Information Tool creates preupgrade scripts, which fix some issues before you start an upgrade, and postupgrade scripts, which fix some issues after an upgrade is completed.
upvoted 1 times
...
Neil107
2 years, 6 months ago
ABC. I'm quite sure.
upvoted 1 times
...
wiprooracle
2 years, 7 months ago
I think its A,B.C based on https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-307DACD9-ECEE-4079-B767-B22620B99900
upvoted 1 times
...
Rogazan
2 years, 8 months ago
From https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-BBF591A5-EB02-405A-9F99-572429838C73 A True. "During the prerequisite phase, DBUA runs the Pre-Upgrade Information Tool script" B True. "You can start DBUA as part of the database software installation, or you can start it manually after installing the software" C False. "By default, CDB$ROOT, PDB$SEED, and all PDBs that are plugged into the CDB are upgraded. If you do not want some PDBs to be upgraded at this time, then unplug those PDBs" D. True. "Select Recovery Options... To recover the database if a failure occurs during upgrade, select from one of the following options: Use RMAN Backup..., Use Latest Available RMAN Backup..., Use Flashback and Guaranteed Restore Point..., I have my own backup and restore strategy... E. False. The database does NOT have to be in read only. F. False. "You can select only one database at a time."
upvoted 1 times
brolem
1 year, 10 months ago
D is false as it is not MANDATORY ("MUST") that a whole database backup exist. However, the Select Recovery Options window allows you to select a recovery method to recover the database if a failure occurs during upgrade. This includes Flashback and Guaranteed Restore Point, Use RMAN Backup, and I have my own backup and restore strategy.
upvoted 1 times
...
...
mporislav
2 years, 8 months ago
A, B, C same as ObserverPL
upvoted 1 times
...
ssseee
2 years, 8 months ago
i think ABF
upvoted 1 times
...
dunhill
2 years, 8 months ago
I think ABC
upvoted 1 times
dunhill
2 years, 8 months ago
Sorry, I change my answers. I think BCF. A looks wrong... precheck is provided by a jar file. https://oracle-base.com/articles/19c/multitenant-upgrading-to-19c I am still not sure but full backup is important but not must be?
upvoted 1 times
...
RinD
2 years, 8 months ago
B is wrong. If you have earlier release Oracle Database installations, then these installations are listed as available to upgrade. I tested in lab too.
upvoted 1 times
ssseee
2 years, 8 months ago
why B is wrong? I dont und. We launch the dbua from the new database home.
upvoted 2 times
...
...
...
RinD
2 years, 8 months ago
ACD correct
upvoted 2 times
brolem
1 year, 10 months ago
C is incorrect. By default, CDB$ROOT, PDB$SEED, and all PDBs that are plugged into the CDB are upgraded. If you do not want some PDBs to be upgraded now, then unplug those PDBs.
upvoted 1 times
...
navingupta52
2 years, 7 months ago
D is incorrect. A backup can be created by DBUA itself before the upgrade. ABC seems correct answers as DEF are incorrect.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago