Oracle database administrator Interview Questions
536
Oracle Database Administrator interview questions shared by candidates
Why do you want to work in IT?
3 Answers↳
I'm confidents that I can bring this type of success to this position. I am confident that I am good fit for this position for several reasons, but most specifically because of my dedication to going above and beyond in a job. I am committed to learning any new skills on my own to succeed in this role. THANK YOU Less
↳
I love to work with it. I just follow that the may be much success will not come, but I have to try untill get that. Less
↳
I want to work there in to have experince in it Thank you
How would you handle a difference of opinion between yours and a Senior technical member?
2 Answers↳
Depends: Is it in their area? Eg if the comms guy says the firewall must be set this way, all I can do is have my opinion heard and live with it. Get them to explain their opinion. Then explain my reasons. If they explain first hopefully they will listen to mine. Perhaps they are right. If they can't explain they may retract. See if we can compromise. Schema design is often influenced by technical background knowledge that hasn't been documented/shared yet. Software settings are often based on previous jobs, rather than current reasons. Less
↳
In every corporation I've been involved with, there are individual power plays. Those individuals will always seek to be right (no matter if they wrong, which they often are), so that they can gain power. The best choice is not to get involved with those power-politics. If a senior person's opinion differs with mine, I will explain the logical reasons for my opinion, and then let it go. I have no need to have a power-match with any senior person. If they are dug into their position, then I will defer. It is only a JOB--it's not my whole existence. Less
Oracle RAC Questions , Exadata Internal Hardware questions
2 Answers↳
Man you are 9+ years experience in Oracle DBA, how on earth you don't have RAC Installation Experience. Exadata I get it, it is expesive hardware and it installed by Oracle or Oracle vendors, but come on man, RAC...piece of cake :D Less
↳
Iam not a Exadata System Admin.. iam a Exadata DBA. Replacing disks is ok but if your company asks you to do other Unix SA tasks then they should hire someone who can do that. Less
How to check the current status of a cluster?
2 Answers↳
crsctl check cluster
↳
By the user_clusters data dictionary.
It depends what u have mentioned in CV and your work experience
2 Answers↳
It was vey well
↳
It's essential to demonstrate that you can really go deep... there are plenty of followup questions and (sometimes tangential) angles to explore. There's a lot of Oracle Database Administrator experts who've worked at Capgemini, who provide this sort of practice through mock interviews. There's a whole list of them curated on Prepfully. prepfully.com/practice-interviews Less
External tables. Can they have indexes
2 Answers
In a dataguard environment, say the primary database is having network issues and you failover to the standby database. Now the standby has become the new primary. Now if network issues were resolved on the old primary, how do you restore it and make it a physical standby ?
2 Answers↳
There seems to be a new Oracle 11g feature called RESUME which can achieve this. I also think that it can be done using flashback. Less
↳
The key in these questions is to cover the fundamentals, and be ready for the back-and-forth with the interviewer. Might be worth doing a mock interview with one of the StubHub or ex-StubHub Senior Oracle Database Administrator experts on Prepfully? They give real-world practice and guidance, which is pretty helpful. prepfully.com/practice-interviews Less