Exam 1z0-083 topic 1 question 50 discussion

https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C A. False. Only "...This option recompiles all INVALID PL/SQL modules after the upgrade is complete B. True. "...The following is a list of examples of DBUA checks, and of actions that DBUA performs on the database: Empty database recycle bin..." C. True. "... DBUA runs the Pre-Upgrade Information Tool as part of the prerequisite checks it performs before starting the upgrade..." D. False. Only true for option Partial Backup "...Select among the following RMAN backup options:... Create a New Partial Offline RMAN Backup with User Tablespace. If you select this option, then user tablespaces are placed into read-only mode during the upgrade...." E. False. These elements are not mentioned in the description of the DBUA process. F. True. DBUA only continues if the check phase verifies that it can increase the size of tablespaces "... uses the following logic to modify or create new required tablespaces..."

B,C,D come on guys A is not correct because it says "ALL stored PL/SQL CODE" DBUA recompiles only all invalid objects not all stored all stored PL/SQL F is also not correct It increases tablespace size, if required, to meet upgrade requirements. increasing tablespace size means adding more datafiles DBUA dont do this "If there is not enough disk space to grow, then DBUA prompts you to create space by adding more data files. DBUA does not automatically add new data files, because DBUA cannot determine where to create the files.: so B, C and D

according to documentation: A and E wrong B and C are correct. D is partially correct, as setting tablespaces to read only is an option that can be done during silent more. F is more correct as DBUA have a specific logic to modify or create new required tablespaces https://docs.oracle.com/en/database/oracle/oracle-database/18/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C

guretto 9 months, 2 weeks ago F is true https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C

well documented.

F is true https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C DBUA uses the following logic to modify or create new required tablespaces: If the data files are auto-extensible and have enough disk space to grow, then DBUA continues with the upgrade. If the data files are not auto-extensible, then DBUA prompts you and makes the files auto-extensible. If the tablespaces are auto-extensible and the MAXSIZE initialization parameter needs adjustment, then DBUA prompts you to for this adjustment, and adjusts the MAXSIZE parameter. If there is not enough disk space to grow, then DBUA prompts you to create space by adding more data files. DBUA does not automatically add new data files, because DBUA cannot determine where to create the files.

I was searching about this one and i presume BCD are true, all in this link: https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-F929338D-48EE-434F-A5F9-A9E7CD61B17F B and C: The Prerequisite Checks window opens. DBUA analyzes the databases, performing preupgrade checks and displaying warnings as necessary. The following is a list of examples of DBUA checks, and of actions that DBUA performs on the database: Empty database recycle bin. Identify invalid objects. Identify deprecated and desupported initialization parameters. Identify time zone data file version. D: Create a New Partial Offline RMAN Backup with User Tablespace. If you select this option, then user tablespaces are placed into read-only mode during the upgrade.

BCD Are true all are B and C are definitely true but D is optional which is through RMAN. https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-307DACD9-ECEE-4079-B767-B22620B99900 The thing about E it's mentioned that "If there is not enough disk space to grow, then DBUA prompts you to create space by adding more data files. DBUA does not automatically add new data files, because DBUA cannot determine where to create the files." It does not create the tablespace automatically but prompts to create the space.

i agree with Rogazan

see comment from Rogazan and read the Oracle docs ...

Question is not clearly formed A - FALSE I agree, DBUA could compile invalid objects (and not only PL/SQL, because synonyms too) B - TRUE - as a task of prerequisite mandatory checking task C - TRUE - this step is mandatory it perform always, but result can be skippable (using -ignorePreReqs option) D - TRUE - but ... it's OPTIONAL because we can choose f.g. "I have my own backup strategy" then D is FALSE E - FALSE F - FALSE it's only check but it will have never changed anything

I vote for ABC: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-307DACD9-ECEE-4079-B767-B22620B99900 Using DBUA to Upgrade the Database on Linux, UNIX, and Windows Systems -> point 5

It is indeed ACF.

ACF seems to be true. Language has some nuances but A is correct. B is wrong. It doesn't empty recycle bin by itself. It increases tablespace is needed, but on prompt, not automatically. but it does increased the size.

utlrp.sql compiles only invalid objects. So is not true https://docs.oracle.com/en/database/oracle/oracle-database/18/rilin/recompiling-all-invalid-objects.html#GUID-1023C5FB-B409-4F16-BCA1-C14CB9B7E625

Yes correct answer is BCD ...

A. It recompiles all stored PL/SQL code by using utlrp.sql. B. It empties the RECYCLE BIN. C. It performs prerequisite checks to verify if the Oracle database is ready for upgrade. D. It sets all user tablespaces to "read-only" before starting the upgrade. E. It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles F. It increases tablespace size, if required, to meet upgrade requirements. I think it is ABC. F does not seem right, *DBUA will increase the size of TS _only_ if the data files are auto-extensible and have enough disk space to grow, then DBUA continues with the upgrade. If the data files are not auto-extensible, then DBUA prompts **you** and makes the files auto-extensible. It is not capable to do by its own when auto-ext is disabled. Even if there are no space on the filesystem then DBUA prompts **you** to increase it.