Oracle Database Interview Question Set-34

My DBA Community,

My today’s post is very important for those who are looking for a job and preparing for an Interview. I am writing Oracle Database interview questions.

1. Can we recover Corrupted Block? Steps to recover?

2. If we do not have a backup, Can we recover a data file? if yes, then please tell steps to recover the data file?

3. Explain Architecture Of Oracle 12c Database?

4. what is a guaranteed restore point, normal restore point, and clean restore point?

5. When we do open reset logs and open no reset logs?

6. if we miss the control file (no backup), which is not multiplexed. then how can you recover?

7. If the developer required to do DML on a production-like database (consider physical standby), then what will be your approach?

8. Explain Architecture Of Oracle 19c Database?

9. Can we create a non-CDB database in 20c?

10. What are the new DBA features in 19c?

Thanks

With Best Wishes!!!!

Ahmad

ACE Associate
Cloud Architect
Oracle Database Consultant

Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |

My YouTube Channel (OracleRide)
http://www.youtube.com/c/OracleRide

Social Network Link
LinkedIn: https://linkedin.com/in/riaz-ahmad-ansari-62500997
LinkedIn Group: https://www.linkedin.com/groups/10506569
Linkedin Page: https://www.linkedin.com/company/68645722/admin/
Facebook: https://www.facebook.com/ahmad.oracleride
Facebook Group: https://www.facebook.com/groups/549665585939796/
Twitter: https://twitter.com/raansari77
Instagram: https://www.instagram.com/raansari20/