Oracle Database Interview Question Set-16

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.

I hope these IQ will help you.

1. If your current redo member got corrupted, will the database hang? If yes, how will you overcome this situation?

2. If you have increment level 0 backup and you have to restore it on a fresh server, how will you do it?

3. When do you propose a RAC solution to your business client? Why RAC environment is beneficial over a single instance database?

4. What is the difference between maximum performance, maximum protection & maximum availability in Data Guard?

5. What is the Default mode in Data Guard?

6. What is the Difference between Incremental Differential and Incremental Cumulative backup?

7. If LOB object is taking much time to export what will be your action?

8. If node evictions occur? what will be your approach?

9. How many voting disks are required to set up the RAC?

10. If you have added datafile in the primary database but it was not added in standby due to space issue, then what will you do to correct it?

Thanks