In this episode of daily DBA, I pick up 5 important #DBA related questions and give my answers! Do not forget to checkout BONUS QUESTION at the end of the video!

00:00 Performance Tuning
01:21 How to open database when archive log is missing?
07:06 Could you also explain about high water mark please?
17:33 #dba Challenge!
19:48 Why we need to rebuild the indexes?
24:39 #dba Challenge!
25:07 When you issue SELECT * FROM EMP; does it use Indexes on the table?
25:39 What is the difference between data file header and data block header? What it contains?
26:41 #dba Challenge!
Bonus Question
27:15 Why can't we give DBA access to developer team?

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis