Sample Interview Questions

1. for standby – which one is used archive log or redo log?

2. steps to apply patchset  

5. steps for disaster recovery

5. Asm – to add space  is required  shutdown?

6. How to add datafiles to database ?

6. why stats is important?

7. steps to clone a database

8. one morning got the performance issues. What do you do ?

9. change management process

10.education and certification

Hope this help. Regards Rupam

Interview Guide

These are general guidelines for any interview. Always, prepare for interview and Practice, Practice and Practice 

Disclaimer : These question are not in any order or importance

General

Q. Tell us about yourself

     Prepare to speak up for at least 3 minutes

Q. Tell us why you are interested in this job –

     Do the research about the company and prepare your answer

Q. Do you read any Oracle Magazine/blogs/papers

Q. Are you member of any User Group

Q. Last Question of Interview is always, Do you have question 

    Prepare your question in advance

Technical

There are two types of technical questions

a) Similar to what is what is being asked at OCA/OCP – terms etc

b) Situation based, such as,

User is getting password expired, what action you are going to take