Oracle database administrator Interview Questions

495

Oracle Database Administrator interview questions shared by candidates

Top Interview Questions

Sort: Relevance|Popular|Date
Meta
Oracle Database Administrator was asked...May 9, 2009

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

UST

Oracle voting disk how many

2 Answers

It is two. I answered one. (It was one)

This is a condition where a node is evicted when the heartbeat condition is not satisfied. Node eviction happens to avoid split brain condition and avoid data corruption. Less

Cognizant Technology Solutions

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

Black & White Business Solutions

How to check the current status of a cluster?

2 Answers

crsctl check cluster

By the user_clusters data dictionary.

Capgemini

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

In-N-Out Burger

Why do you want to work in IT?

2 Answers

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

Google

External tables. Can they have indexes

2 Answers

Actually you answered incorrectly. External tables in Oracle are read only and cannot have indexes built upon them. Their main use is a data source for more traditional Oracle table structures. Less

I said yes. Though I mentioned that I hadn't worked with external tables extensively Less

Tata Consultancy Services

How do you diagnose slow query performance

2 Answers

Check memory/CPU usage

based on the situation and criticality, check the following things: status of the database Is it specific to single query Check memory/CPU usage Check statistics Chec the plan and see if there is any deviation Use hints Less

StubHub

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

Viewing 1 - 10 of 495 Interview Questions

See Interview Questions for Similar Jobs

database engineerdatabase administratororacle dbadba manager