Oracle Apps DBA Interview Questions

 

  • Explain the concept of “Rolling Patches” in Oracle EBS 12.2.
  • How do rolling patches work in Oracle EBS, and what are their benefits?

  • What is the difference between a “Full” and “Patch” backup in Oracle EBS 12.2?

  • What is recommended for database backups in a production environment?

  • What are the common methods to apply patches in Oracle EBS 12.2?

    • Explain methods like AD Patch, OAM, and the use of the latest patching tools.

  • What is the purpose of Oracle EBS Patch Wizard?

    • Describe how this tool simplifies the patching process for Oracle EBS.

  • What are the important things to check before applying a patch in Oracle EBS 12.2?

  • What is Database and Application Tier Upgrades in Oracle EBS?

    • How do you upgrade the database tier or the application tier independently?

  • Explain the purpose of adpreclone and adclone in Oracle EBS.

    • What are the cloning tools used for Oracle EBS, and how do you use them for database cloning?

  • What is Oracle EBS Database Cloning?

    • How do you perform database cloning in Oracle EBS 12.2?

  • What is the difference between adpreclone and adclone in Oracle EBS 12.2?

  • What are some common Oracle EBS DBA tasks for maintaining performance and availability?

  • Backup and Recovery:
  • How do you back up and restore Oracle EBS 12.2 database using RMAN?

  • What is the role of Oracle Data Guard in Oracle EBS?

  • How does Oracle Data Guard integrate with Oracle EBS for disaster recovery?
  • Can you explain the concept of “File System Backup” vs. “Database Backup” in Oracle EBS 12.2?
  • What is the difference between “Hot Backup” and “Cold Backup” in Oracle EBS 12.2?
  • How do you restore a database from a backup in Oracle EBS 12.2?
  • What is Oracle Recovery Manager (RMAN), and how does it help in Oracle EBS backup and recovery?

Leave a Reply

Your email address will not be published. Required fields are marked *