Oracle Database Interview Question Set-25

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. Data-pump is an optional process in GG, then why Oracle recommends it to use?

2. How you will log in to the GG console?

3. How will you check GG is running on the server or not?

4. What you will check if the SELECT query is running slow?

5. You generate an explain plan and found that full table scan, how you can avoid that, what is your suggestion on this?

6. What is the difference between a full table scan and an index scan?

7. Which one is better, a full table scan, or Index scan?

8. What are db file sequential read  Wait Event & db file scattered read  Wait Event?

9. If I have to update one column value, what will happen in the background? How many memory components and processes will involve in this transaction?

10. Can we increase the DB writer process and MAX DB writer processes? What will be the benefit I will get if I increase it?

Thanks

With Best Wishes!!!!

Ahmad
Cloud Architect
Oracle Database Consultant

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

YouTube Channel: https://www.youtube.com/c/OracleRide