An administrator needs to roll back an Oracle patch on a database server VM using NDB. What is required for this action to be successful?

Question

Options

• AThe patch must have been applied using NDB.
• BThe database must be shut down.
• CThe patch must have been applied on Grid home only using NDB.
• DThe database must be in read-only mode.

• A
  89% (25)
• B
  4% (1)
• C
  7% (2)

Explanation

To roll back an Oracle patch on a database server VM using NDB, the patch must have been applied using NDB in the first place. This is because NDB maintains a patch inventory and history for each database server VM and database that it manages. NDB uses this information to determine which patches can be rolled back and how to revert the changes made by the patch. If the patch was applied outside of NDB, NDB would not have the patch information and would not be able to roll back the patch. Therefore, the patch must have been applied using NDB for the rollback action to be successful. The other options are not required for the rollback action. The database does not need to be shut down or in read-only mode, as NDB can perform the rollback operation online. The patch does not need to be applied on Grid home only, as NDB can roll back patches applied on both Grid home and Database home.

No community discussion yet for this question.