Aptara SQL DBA Administrator Interview Questions and Answers for Experienced

Replication is the process of copying and distributing data from one database to another.

• Replication is used to improve data availability and increase scalability.

• It can be done in real-time or on a schedule.

• There are different types of replication, such as snapshot replication, transactional replication, and merge replication.

• Examples of replication software include Oracle GoldenGate, Microsoft SQL Server Replication,

Upgradation refers to the process of upgrading or updating a system or software to a newer version or better quality.

• Upgradation involves replacing an older version of a system or software with a newer version.

• It can also involve adding new features or improving the existing ones.

• Upgradation is important to ensure that the system or software remains secure and compatible with other systems.

• Examples of upgradation inclu...read more

Backup and recovery is the process of creating and restoring data in case of data loss or corruption.

• Backup involves creating a copy of data to protect against data loss or corruption.

• Recovery involves restoring the data from the backup in case of data loss or corruption.

• There are different types of backups such as full, incremental, and differential backups.

• Backup and recovery is important for ensuring business contin...read more