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!
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?
#dailyDBA #oracle #cloudDBA #dbaGenesis #dbaChallenge
Your comments encourage us to produce quality content, please take a second and say ‘Hi’ in the comments and let me and my team know what you thought of the video … p.s. It would mean the world to me if you hit the subscribe button ;)
Link to full course: https://dbagenesis.com/p/oracle-virtualbox-administration
Link to all DBA courses: https://dbagenesis.com/courses
Link to real-time projects: https://dbagenesis.com/p/projects
Link to support articles: https://support.dbagenesis.com
DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available with a challenging project to push you out of your comfort zone!!
DBA Genesis is currently the fastest & the most engaging learning platforms for DBAs across the globe. Take your database administration skills to next level by enrolling into your first course.
Start your DBA Journey Today !!
#rebuild indexes