Pages

Subscribe:

Ads 468x60px

Showing posts with label oracle dba interview questions answers. Show all posts
Showing posts with label oracle dba interview questions answers. Show all posts

Tuesday 10 December 2013

Oracle DBA Interview Questions



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.

Monday 19 March 2012

Can Oracle DBA Interview Questions help to clear Technical Interview?

How to Clear Tough Technical Interview Of Oracle DBA?


Different Oracle version has different kind of features. Every time Oracle changes version and introduces new features with new version. But company’s basic requirement is same. It cannot change with version changes. Due to this reason, interviewer thinks first company’s requirement and tries to ask those kinds of interview questions. Candidate should have superb knowledge of Oracle fundamentals and basic architecture. Candidate should need to keen about company’s basic requirement of opening.

We cannot say that interviewer would ask you same question from any book but interviewer always tries to test your skills and ask questions start from basics to advance. Real time scenario based Oracle DBA interview questions are very tough to understand and crack it. Those are based on practical hands on or experience. If you are able to understand those queries then easily crack it.

Sometimes interviewer tries to ask those questions, which are not related with their requirement. This time, interviewers attempt to read candidate’s mind about in toughest condition or situation how he or she would act. Take example, candidate acts normally any disaster recovery scenario. This kind of situation might not occur in company any time but they are asking this kind of questions to candidate.
Some good and nice book which contains only Oracle DBA Interview Questions Answers, then it would useful to candidate as well as interviewer too. Because using this kind of book, it becomes easier to judge candidate for all expectations without making prior home work. Interviewer always prefers this kind of book and use in any kind of interviews from junior level of interview to senior level of interview.

Every candidate fears about real time scenario based interview questions in technical interview of Oracle. They are not assuming which kind of questions is being asked. Due to this reason, they are losing self confidence before interview and finally they failed in technical interview. For avoiding this kind of situation, you need to prepare yourself using some nice quick ready reference book. Prepare with real time scenario based questions and think about another which kind of questions would be asked. Once you get basic idea and concept of this, you can easily judge another questions too. This situation would build your confidence.

Be careful about your preparation; take help of any good nice Oracle DBA Interview Questions book. Appear in your technical interview without hesitation, you would get success. Today, latest edition of Oracle DBA interview questions answers Book has been released with 4th edition. Discount rate is being offered for very limited time.