Oracle Database Interview Question Set-15

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 the Archiver process killed, then what will be the impact on the database?

2. Why do you prefer the data pump over exp/imp?

3. What is the parameter to make data pump operation faster?

4. What is the parameter used to take consistent backup?

5. What flashback_scn does?

6. If you came in shift and you have to monitor an ongoing import job, how will you do it?

7. How to resume a data pump job and from where it will take info?

8. Tell me common wait events in the database?

9. What precautions will you take before upgrading the production database?

10. If your upgrade is failed for some reason, and the client wants the database to be running ASAP, how can you do that?

Thanks