Do you think those are being needed to clear job interview?
Off course yes because you have knowledge of Oracle database administration but
you don’t have experience about how to face technical questions. Sometimes,
interviewer is very keen in recruitment and he or she is having good technical
knowledge in database administration then interview will be toughest. Sometimes,
interviewer is facing any database related issue or faced any problem then obviously
he or she can be expect proper solution from candidate then he or she will be
asking Oracle DBA interview questions related with same issues.
- What is SGA?
- What are background processes?
- What is ASM?
- What is RAC?
- If I will be kill SMON then what would be happening?
- My Oracle doesn’t bring up with error out of memory how can I resolve it?
- What is relation between schema and Oracle user?
- I am altering datatype of table column does synonym will be invalidated?
- How can I recover database when datafile got corrupted?
- Which command should need to execute for unmounting ASM disk where 3 instances are running?
- What is command of checking last backup of RMAN?
- How to check defragmentation in database?
- What is the solution to remove defragmentation of tables?
- What is the command to remove connected user from database?
- Log file sync wait event is constantly appearing in top 5 wait event with high resource consumption in AWR report then what is the issue and how can I solve it?
You can see above Oracle DBA interview questions are very
easy but some of those should need more concentration. Some of are tricky and
those require more attention because you might be trapped. If any tricky
question will be asked first during interview starting time and you will give
wrong answer then what will be happening? First impression is last impression.
You might be loose impression and chance of job too. Sometime your answer will
be correct from your side but it won’t be expected by interviewer and
interviewer is expecting something else answer then also you would be rejected.
Use smart technique for replying those tricky and real time
scenario based Oracle DBA interview questions. If you will be act smart then
you can be create good impression during technical interview or discussion. Chances
of getting job become easier.
You can find out so
many technical interview related dba questions from web but all were outdated
and some of having wrong answers. You should need to prepare yourself what
interviewer expecting. Real time scenario based Oracle DBA interview Questions
are available very rare with explanation on web. Off course, grabbing Oracle
DBA job is dream of every DBAs but without proper preparation they get failure
for getting job.
