Oracle Multi Tenant Architecture interview Questions

 

1. What is Oracle Multitenant Architecture, and how does it differ from traditional single-tenant architecture?

• Follow-up: Can you explain the components of a Container Database (CDB) and Pluggable Database (PDB)?

2. What are the advantages of using Oracle Multitenant architecture in comparison to traditional non-CDB (non-multitenant) databases?

• Follow-up: How does multitenancy improve resource management, scalability, and consolidation in an enterprise environment?

3. Explain the concept of a Container Database (CDB) and a Pluggable Database (PDB). How do they relate to each other in Oracle Multitenant?

• Follow-up: What is the role of the root container (CDB$ROOT) and the seed container (PDB$SEED)?

4. What is the difference between "Pluggable Database" (PDB) and "Multitenant Database" (CDB)?

• Follow-up: Can a CDB exist without any PDBs? What happens in such a case?

5. How does the "unplugging" and "plugging" process work in Oracle Multitenant?

• Follow-up: What are the steps to unplug and plug a PDB from one CDB to another? Are there any prerequisites or limitations?

6. How does Oracle Multitenant architecture simplify database consolidation and management?

• Follow-up: What are the key administrative tasks that can be simplified by using multitenancy (e.g., backups, patching, provisioning)?

7. What are some of the challenges or limitations when working with Oracle Multitenant?

• Follow-up: Can you explain any scenarios where using multitenancy may not be the best choice?

8. How does Oracle handle security in a Multitenant environment?

• Follow-up: Can you explain how the root container (CDB$ROOT) and pluggable databases (PDBs) handle users, roles, and privileges? What are some common security practices in a CDB-PDB setup?

9. Explain the concept of "hot cloning" in Oracle Multitenant. How does it work and what are its use cases?

• Follow-up: What are the steps to clone a PDB from one CDB to another? Can this process be done online, and if so, what are the advantages?

10. Can you explain the concept of "PDB isolation" in Oracle Multitenant? How is isolation between PDBs maintained?

• Follow-up: In terms of database resource management (CPU, memory, etc.), how do you ensure optimal performance for individual PDBs within a CDB?