D'signs Interview Questions and Answers

Oracle database architecture and multi-tenant architecture in Oracle 12c

• Oracle database architecture includes physical and logical structures

• Multi-tenant architecture in Oracle 12c allows multiple pluggable databases to share a single container database

• Each pluggable database has its own set of tablespaces, users, and schemas

• This architecture reduces hardware and software costs and simplifies database management

Golden Gate is a database replication technology used for high availability and disaster recovery.

• Golden Gate is used to replicate data in real-time from one database to another.

• It can be used for high availability and disaster recovery purposes.

• It supports heterogeneous database environments and can replicate data across different platforms.

• Golden Gate can also be used for data integration and migration.

• It provides real-time data synchronization and conflict detection and re...read more

ASM stands for Automatic Storage Management. It is a feature of Oracle Database that provides a file system and volume manager.

• ASM simplifies the management of Oracle database files by providing a single file system for all database files.

• It also provides redundancy and load balancing for the database files.

• The maximum limit for ASM disk groups is 63.

• ASM can be used with both single-instance and Oracle Real Application Clusters (RAC) databases.

Voting disk is a file used by Oracle Clusterware to manage cluster membership and node failure detection.

• It is a shared disk that is accessible to all nodes in the cluster.

• It contains information about the current state of the cluster and is used to determine the membership of the cluster.

• It is used to determine which nodes are active and which are inactive in case of a node failure.

• It is recommended to have at least three voting disks for high availability.

• Voting disks can b...read more

RAC is a cluster database that allows multiple instances to access a single database. DR is a disaster recovery database.

• RAC stands for Real Application Clusters

• RAC allows multiple instances to access a single database simultaneously

• DR stands for Disaster Recovery

• DR is a separate database used for backup and recovery in case of a disaster

• DR can be located in a different physical location than the primary database

• RAC and DR are often used together for high availability and dis...read more