Oracle Database Administration II — Question 93

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
1. Install the SALES_APP application, including the common tables, in the application root.
2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
3. Create an application seed.
4. Install the SALES_APP application in the application seed.
5. Create the SALES_APP1 and SALES_APP2 application PDBs.
6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

Answer options

• A. 3, 4, 1, 6, 8
• B. 2, 5, 6
• C. 1, 5, 6
• D. 1, 3, 5, 6, 7
• E. 1, 3, 5, 7

Correct answer: C

Explanation

The correct answer is C, which involves installing the SALES_APP application and then creating the PDBs, followed by syncing them. Options A, D, and E include unnecessary steps or sequences that do not ensure the common tables are set up before the PDBs are created. Option B skips the crucial installation of the application, which is essential for the PDBs to access the common tables.