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!

Questions Picked-up For This Episode:

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

Why Rebuild Indexes? | #dailyDBA 20
1.05 GEEK