I'm actually appending to Kirti's answer below here. Before my students receive a passing grade in my class, they are required to do exactly what Kirti and Connor have laid out. They must each do this as part of their final exam.
Most of them have no difficulty. When they ask me how they should prepare for an interview, I've often told them that if they are not asked to stand up to a white board and lay everything out, they should offer to. Most of them do, and oftentimes they get the job, or they are told that they were one of the top five candidates. And to also add to Rachel's point, I tell them to carefully listen to any technical knowledge displayed by their hiring manager (if this is the person they are interviewing with). I once interviewed with someone who asked me to solve a potential problem they were currently having with their database. He told me they had recently added several indexes to such-and-such tables for such-and-such application, and it was *still* slow. I took a brief look and saw no statistics. I asked him if he had ever analyzed his tables or indexes. He told me they created explain plans all the time and still could not locate the problem. I asked him if he was using the cost-based optimizer. He informed me that he was not. He was in fact using optimizer=CHOOSE .... Yeaaaaahhhhh, you see where this is going. I ended up taking a job with a different company. I tell my students, that even if they are offered a job (and this is less potent advice in a failing economy) if at all possible, try to work for a person who is just as, if not more, knowledgeable than you are. If your boss is a good mentor you have a great potential to grow and further your knowledge. And if not, well, you could end up with the situation above. So, for the system manager who originally started this thread, hopefully you are just as knowledgeable as the candidates you hope to obtain? Or, you are forwarding the candidates on to someone who is? -----Original Message----- Rachel Carmichael Sent: Friday, October 24, 2003 11:10 AM To: Multiple recipients of list ORACLE-L wait, the people you interview can read? :) we've had this discussion off and on on this list over the last few years. I've been on interviews where one of the questions was about what "display" setting I needed to make in order to do an install. This is Oracle? This is also documented in the install guide. a better question would have been "what are the steps you take before doing an install?" Standardized tests have standardized answers. The tests end up published (or the interviewees publish the questions) and you get OCP. I ask things like "tell me the thing you've done that you are most proud of" and "tell me your nightmare situation and how did you recover from it" --- April Wells <[EMAIL PROTECTED]> wrote: > > That's the inherent problem with using those kinds of lists and books > is that both sets of people can read and glean. > > April Wells > Oracle DBA/Oracle Apps DBA > Corporate Systems > Amarillo Texas > /\ > / \ > / \ > \ / > \/ > >\< > \ > >\< > \ > Few people really enjoy the simple pleasure of flying a kite Adam > Wells age 11 > > > > -----Original Message----- > Sent: Friday, October 24, 2003 8:49 AM > To: Multiple recipients of list ORACLE-L > > > The problem with such lists is that the prospects also have those... A > few years ago Mike Ault published one. We used it to screen candidates > via phone interviews. > Two out of four I talked to gave me perfect answers: word to word > from > Mike's list. > > Use Conner's approach: Give the candidate a white/black board, and ask > him/her to draw the SGA > with all it interal structures, all background processes, and explain > how > all this works > together..... > > - Kirti > > > --- system manager <[EMAIL PROTECTED]> wrote: > > Dear List, Can anyone send me a list of dba interview questions? > > > > Thanks, > > > > > > _____________________________________________ > > Free email with personality! Over 200 domains! > > http://www.MyOwnEmail.com Looking for friendships,romance and more? > > http://www.MyOwnFriends.com > > > > > > __________________________________ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Kirtikumar Deshpande > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L (or the > name of mailing list you want to be removed from). You may also send > the HELP command for other information (like subscribing). > > The information contained in this communication, including > attachments, is strictly confidential and for the intended use of the > addressee only; it may also contain > proprietary, price sensitive, or legally privileged information. > Notice is hereby given that > any disclosure, distribution, dissemination, use, or copying of the > information by anyone > other than the intended recipient is strictly prohibited and may be > illegal. If you have > received this communication in error, please notify the sender > immediately by reply e-mail, > delete this communication, and destroy all copies. > > > Corporate Systems, Inc. has taken reasonable precautions to ensure > that any attachment to this e-mail has been swept for viruses. We > specifically disclaim all liability and will > accept no responsibility for any damage sustained as a result of > software viruses and advise > you to carry out your own virus checks before opening any attachment. > __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
