{"id":6926,"date":"2019-10-07T10:53:52","date_gmt":"2019-10-07T10:53:52","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=6926"},"modified":"2020-05-29T08:56:17","modified_gmt":"2020-05-29T08:56:17","slug":"dba-interview-questions-and-answer-part-1","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/dba-interview-questions-and-answer-part-1\/","title":{"rendered":"DBA Interview Questions and Answer &#8211; Part 1"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li>What\u2019s ACID ? How is it implemented ?<\/li><li>What is row level locking ? Table level locking ?<\/li><li>How do you check which jobs are running?<\/li><li>Imagine you have a filesystem that supports snapshots &#8211; how do you take hot backups using volume managers (LVM\/EBS)?<\/li><li>What is the need for master\/slave replication in MySQL ? What about master\/master replication ? How does replication work in MySQL ?<\/li><li>How would you handle DB migrations? How would you automate DB migration process?<\/li><li>What pros\/cons could you tell about MySQL\/PostgreSQL?<\/li><\/ul>\n","protected":false},"excerpt":{"rendered":"<p>What\u2019s 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&#8230; <\/p>\n","protected":false},"author":1,"featured_media":7814,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[52],"tags":[],"class_list":["post-6926","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-interview-questions-answers"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/6926","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=6926"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/6926\/revisions"}],"predecessor-version":[{"id":6927,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/6926\/revisions\/6927"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media\/7814"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=6926"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=6926"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=6926"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}