DBA Interview Questions and Answer – Part 1

  • What’s ACID ? How is it implemented ?
  • What is row level locking ? Table level locking ?
  • How do you check which jobs are running?
  • Imagine you have a filesystem that supports snapshots – how do you take hot backups using volume managers (LVM/EBS)?
  • What is the need for master/slave replication in MySQL ? What about master/master replication ? How does replication work in MySQL ?
  • How would you handle DB migrations? How would you automate DB migration process?
  • What pros/cons could you tell about MySQL/PostgreSQL?
Rajesh Kumar