Oracle Database Interview Question Set-26

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. How does authentication happen in Oracle Database? Where it will authenticate in DB and OS system?

2. Tell me about Oracle Architecture? & What are the Instance and Database?

3. What is LGWR? How many LGWR is there, can we increase LGWR?

4. If LGWR is slow then what could be the reason for that? How you will troubleshoot? What would the solution you could give?

5. How you will export the 8i database to 12c? In testing, it is taking 2 hours and in production, now it is taking 4 hours what you will check? how you could improve the performance of this activity?

6. How you will migrate the database using RMAN? If it is slow, how you will increase the performance?

7. How you will Migrate using a Data pump?

8. What is the prerequisite required for data pump export and Import?

9. If performance is slow in the Data pump, what will you do?

10. How you will monitor this Data pump activity?

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