Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)
Database Upgrade Assistant (DBUA) performs several actions during the upgrade process. First, it empties the RECYCLE BIN to ensure that no obsolete or unnecessary data affects the upgrade process. Second, it performs prerequisite checks to verify that the Oracle database is ready for the upgrade, ensuring that the system meets all necessary conditions. Lastly, DBUA can set user tablespaces to read-only before starting the upgrade, particularly when a partial offline RMAN backup with user tablespaces is selected. These actions help ensure a smooth and successful upgrade process.
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..."
I think A is correct because it clearly mentions "by using utlrp.sql" implying that only all invalid code will be recompiled
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
F is true: 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. D is also true, but it is not performed implicitly by the DBUA unless you check that option unlike the case of F which is performed implicitly.
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.
A,D are optionals and correct B,C correct E wrong F correct if there is enough disk space with auto-extensible on, but not in automatic So i think the correct answer in this question is: BCF
agree with this argumentation
BCF correct: 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 B and C are correct> The Prerequisite Checks window opens. DBUA analyzes the databases, performing pre-upgrade checks and displaying warnings as necessary. The following is a list of examples of DBUA checks and actions DBUA performs on the database: Empty database recycle bin. F - correct: https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C A is optional.
F is incorrect according to your link: 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. (so is not doing it by itself, is prompting you)
During the prerequisite phase, DBUA runs the Pre-Upgrade Information Tool script, and 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.
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.
Yes correct answer is BCD ...
Hi, D has the same problem as F. It put the tablespace read-only "IF" you check the option. it's no automatic.
F has another problem though: DBUA doesn't directly increase the size of tablespaces, but rather it can enable autoextend or set maxsize to a higher value on their datafiles. In extreme cases: "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 in no case it directly resize tablespaces, hence I guess that D can be true and F false. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-oracle-database-upgrade-assistant-dbua.html#GUID-8BDDF859-1638-45AC-824D-78FC8154847C
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
It is indeed ACF.
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 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
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
see comment from Rogazan and read the Oracle docs ...
i agree with Rogazan
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.
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.
well documented.