Home » Other » Training & Certification » Interview questions
Interview questions [message #572002] Wed, 05 December 2012 05:45 Go to next message
Messages: 1
Registered: December 2012
Location: banglore
Junior Member

This is Sudhrshan S can u send me few interview questions might it will work for me

Sudhrshan S
Re: Data to be taken in different format [message #572011 is a reply to message #572002] Wed, 05 December 2012 06:18 Go to previous messageGo to next message
Messages: 732
Registered: May 2009
Location: United Arab Emirates
Senior Member

dear sudharshan, what type of questions you want , put it on the forum as new case you will find response, there is one site which provided interview question its geekinterview.com try on that.
Re: Interview questions [message #572090 is a reply to message #572002] Thu, 06 December 2012 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can find an infinite number of interview questions on the web, just use Google.

Re: Interview questions [message #572256 is a reply to message #572002] Sat, 08 December 2012 18:59 Go to previous messageGo to next message
Messages: 258
Registered: May 2012
Location: Orlando, FL
Senior Member

There's actually a set here on ORAFaq: http://www.orafaq.com/wiki/Interview_Questions

However, there's are several inherent problems with using lists of interview questions to prepare for an interview. The root of them is that generally the only candidates that use them are people who don't really know enough about Oracle to be applying for the position. I've been working with Oracle for seventeen years. I don't know everything about it. There are certainly questions that someone could ask in an interview that I wouldn't be able to answer without looking at a manual. I don't really worry about that because I'm confident of my ability to demonstrate that I am knowledgeable.

If you memorize a bunch of Question-Answer combinations from an interview list, you might gain a surface veneer of Oracle knowledge, but it will be paper-thin. Almost any follow-on question will trip you up. Take one of the questions from the OraFAQ list:

Q: What background process refreshes materialized views?
A: Job Queue Process (CJQ)

This falls into the 'very nearly useless' category of information. It's useful as a DBA to know the Oracle architecture and where background processes fit in. You should certainly know what the big players are and what they do: PMON, SMON, DBWR, ARCH. However, memorizing the names of the bit players is definitely secondary information. That said, if a candidate were able to answer the above question, and then I were to ask some followup questions like:

What is the difference between a view and a materialized view?
What is a fast refresh?
What are the tradeoffs involved in using materialized views?

Knowing the answers to the three questions above is much more inherently useful than the first question. If I have a candidate that can answer the first, but not these, then I'm certainly going to suspect they have been using lists like this to conceal their lack of Oracle knowledge.

As Michel said, the internet contains huge numbers of these lists, and books on the subject are common. However, be aware that if you prepare for an interview using Oracle Interview Answers for Dummies, you'd better hope that the person running the interview is working directly from their copy of Idiot's Guide to Interviewing Oracle Professionals.
Re: Interview questions [message #572263 is a reply to message #572256] Sun, 09 December 2012 01:03 Go to previous message
Michel Cadot
Messages: 65143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Very good post, Matthew, I hope many that ask for these lists will read and take profit of it.

Previous Topic: Oracle E-Business Suite Financial Management Support Specialist
Next Topic: SQL Help needed
Goto Forum:

Current Time: Fri Aug 18 18:50:29 CDT 2017

Total time taken to generate the page: 0.15668 seconds