Oracle Database Interview Question Set-21

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 to do schema refresh?
2. How to check the backup completed or not?
3. How to check which query is taking a long time?
4. How to check tablespace is full or not?
5. How to unlock the schema?
6. How you will check about the patch?
7. What is the snapshot too old error?
8. If we take a full backup on Wednesday and after that, we take incremental backup on Tuesday and Friday, and on Sunday database crashed so how you will perform recovery?
9. How to add datafile?
10. How to resize tablespace?

Thanks