RE: Developer Interview Questions?
Jay, I would feel that PL/SQL tuning is the same as SQL tuning. Just pull out one of your complicated Explain Plan or TKProf outputs and ask the Interviewee (is there such a word?) to explain the meaning. Also quiz him/her about the various joins and the approach he/she would take when a DBA/User complains of a slow query - If 'trace file', 'tkprof' and 'explain plan' don't appear in the answer, then you may as well stop the interview :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: Developer Interview Questions? I've been asked to conduct a technical interview for a new PL/SQL developer, with an emphasis on performance tuning issues (which is why I'm doing it instead of one of the existing developers who seem to have some difficulty with the idea of running something through Explain Plan before sending it to me to go into production - I usually do all the SQL tuning). I've put together a few things but wondered if anyone could point me to a document with some good interview questions (I've only conducted DBA technical interviews in the past). Thanks! Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Developer Interview Questions?
In addition to SQL tuning, the prospective employee should know what cursor variables are, bind variables, and the advantages of using them. The hopeful candidate should also know how to minimize opening cursors through reuse, or at least not look like a scared deer in the headlights when asked about it. Excellent paper on this by Bjorn Engsig at http://otn.oracle.com/deploy/performance Jared John Kanagaraj [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/15/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Developer Interview Questions? Jay, I would feel that PL/SQL tuning is the same as SQL tuning. Just pull out one of your complicated Explain Plan or TKProf outputs and ask the Interviewee (is there such a word?) to explain the meaning. Also quiz him/her about the various joins and the approach he/she would take when a DBA/User complains of a slow query - If 'trace file', 'tkprof' and 'explain plan' don't appear in the answer, then you may as well stop the interview :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: Developer Interview Questions? I've been asked to conduct a technical interview for a new PL/SQL developer, with an emphasis on performance tuning issues (which is why I'm doing it instead of one of the existing developers who seem to have some difficulty with the idea of running something through Explain Plan before sending it to me to go into production - I usually do all the SQL tuning). I've put together a few things but wondered if anyone could point me to a document with some good interview questions (I've only conducted DBA technical interviews in the past). Thanks! Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Help - DBA interview questions I faced
Dharan, Read the Concepts Manual again. If you can, go through the DBA 101 book and perhaps some of those Starter Kits Oracle Press has been cranking out lately. Are you administering Oracle database(s) now? Take time to poke around and see what is happening. Create a user account for yourself to experiment with, being careful not to cripple the rest of the system. You can do that by ensuring you don't have rights / privileges that give you too much freedom on the database. To understand, you need to read (know), but you also need to practice (experience). Once you will have done both, you will have learned from mistakes and you will understand what is happening. That will also give you a handle on which questions are relevant and which are not during interviews. Your next Oracle interview might be administered by someone who knows little or nothing about Oracle. (i.e. they are looking for a DBA, because their previous one left in disgust or they never had one). If you understand the basics of Oracle and you demonstrate during the interview that you do not consider saving face (putting up appearances) being more important than learning and fixing problems, you will have an honest chance at being hired as a junior DBA. At first you will have to live, eat, breathe, dream Oracle. You have to decide on this path and never give up. Never giving up is a crucial DBA trait. You have to be more stubborn than the server(s) you administer. You also have to be willing to change your approach if the previous one didn't work, the end result is what you aim for, and it is what you keep striving for until you get there. You have to take personal responsibility for the systems you administer. You must be reliable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Dharani Ravi [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 25, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject:Re: Help - DBA interview questions I faced Dear Rachel, Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two years ago. I am working for a small company where there are no seperate DBAs, System Administrators and Network Admins. Only three staff are identified to look after the abovementioned jobs in addition to development job. Most of our time goes for report generation, foxpro programs and other activities. I do not have a senior person from whom I can learn the job. Jobs like DB creation, maintanence, backup and recovery are done by me and I learned the job from manuals and by experience. I wanted to work in a production env where I can learn more about DBA job. I need your guidance and seniors guidance from this group. Hope you will appreciate my position and I sincerely request you to clarify my doubts. I will be grateful to you If you can clarify my mistakes made by me in the interview. I seek the support from this group to develop myself as a DBA. Merry Christmas. Regards. Dharan. --- Rachel Carmichael [EMAIL PROTECTED] wrote: Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about the database. Rachel --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked me around 20 questions and the following are the questions where I have not fared well. Could Seniors help me by giving the appropriate answers
Re: Help - DBA interview questions I faced
Ramesh, Don't be sorry, I just don't want people buying my book and expecting Gaja and Kirti's wonderful stuff. Thank you -- we tried hard to make the book a good one. We're in the beginning stages of revising it for 9i and hope to make it even better. Rachel --- [EMAIL PROTECTED] wrote: Rachel, I'm Sorry for quoting wrong book. Actually I have both books and both are excellent! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] dba 101 is not by gaja and kirti -- that's performance tuning 101 which is indeed an excellent book dba 101 is theriault, carmichael and viscusi. --- [EMAIL PROTECTED] wrote: Dear Ravi DBA 101 book - BY Gaja and kirti is available in India (indian edition). I already have one. Excelent book!! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] Dear Rachel, Thanks for your reply and guidance. Also thanks to Kirti Deshpande and Jenny Jacobson for their replies. In India Oracle DBA 101 book is not yet released. Once it is released I will defently purchase the book. Regarding Question No.1, I told that Server Process is the background process and sysauth or objauth view is used to check for username and password. The employer told me that I am wrong. Could you pl clarify. 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? Regards. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
RE: Help - DBA interview questions I faced
Patrice, This is excellent! Thanks capsulizing the essence of a DBA. Make that a *good* DBA. :) Jared Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: mpo.gc.ca Subject: RE: Help - DBA interview questions I faced Sent by: [EMAIL PROTECTED] 12/27/01 04:55 AM Please respond to ORACLE-L Dharan, Read the Concepts Manual again. If you can, go through the DBA 101 book and perhaps some of those Starter Kits Oracle Press has been cranking out lately. Are you administering Oracle database(s) now? Take time to poke around and see what is happening. Create a user account for yourself to experiment with, being careful not to cripple the rest of the system. You can do that by ensuring you don't have rights / privileges that give you too much freedom on the database. To understand, you need to read (know), but you also need to practice (experience). Once you will have done both, you will have learned from mistakes and you will understand what is happening. That will also give you a handle on which questions are relevant and which are not during interviews. Your next Oracle interview might be administered by someone who knows little or nothing about Oracle. (i.e. they are looking for a DBA, because their previous one left in disgust or they never had one). If you understand the basics of Oracle and you demonstrate during the interview that you do not consider saving face (putting up appearances) being more important than learning and fixing problems, you will have an honest chance at being hired as a junior DBA. At first you will have to live, eat, breathe, dream Oracle. You have to decide on this path and never give up. Never giving up is a crucial DBA trait. You have to be more stubborn than the server(s) you administer. You also have to be willing to change your approach if the previous one didn't work, the end result is what you aim for, and it is what you keep striving for until you get there. You have to take personal responsibility for the systems you administer. You must be reliable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
Thanks Patrice! That was an outstanding synopsis! And it explains why I am behind the curve...I have been a little reluctant (such an understatement) to make the time commitment. Guess there's nothing to it but to do it. Thanks for the encouragement/push! -D- On Thursday 27 December 2001 07:55 am, Boivin, Patrice J wrote: Dharan, Read the Concepts Manual again. If you can, go through the DBA 101 book and perhaps some of those Starter Kits Oracle Press has been cranking out lately. Are you administering Oracle database(s) now? Take time to poke around and see what is happening. Create a user account for yourself to experiment with, being careful not to cripple the rest of the system. You can do that by ensuring you don't have rights / privileges that give you too much freedom on the database. To understand, you need to read (know), but you also need to practice (experience). Once you will have done both, you will have learned from mistakes and you will understand what is happening. That will also give you a handle on which questions are relevant and which are not during interviews. Your next Oracle interview might be administered by someone who knows little or nothing about Oracle. (i.e. they are looking for a DBA, because their previous one left in disgust or they never had one). If you understand the basics of Oracle and you demonstrate during the interview that you do not consider saving face (putting up appearances) being more important than learning and fixing problems, you will have an honest chance at being hired as a junior DBA. At first you will have to live, eat, breathe, dream Oracle. You have to decide on this path and never give up. Never giving up is a crucial DBA trait. You have to be more stubborn than the server(s) you administer. You also have to be willing to change your approach if the previous one didn't work, the end result is what you aim for, and it is what you keep striving for until you get there. You have to take personal responsibility for the systems you administer. You must be reliable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Dwayne Cox[EMAIL PROTECTED] DBA, Development Department, Info Tech, Inc. 5700 SW 34th Street, Suite 1235 phone: (352) 381.4521 Gainesville, FL 32608 fax: (352) 381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Help - DBA interview questions I faced
In some organisations I have worked for you get to be a manager by longevity so you could be a programmer one day and because you stuck it out, the next one your an IT manager for everything IT, Dont laugh one of the guys there now got to be the IT manager just that way. I didnt want to stick it out long enough to see if I could make IT manager Cheers -- = Peter McLartyE-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = Boivin, Patrice J [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 27/12/2001 10:40 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Fax to: Subject:RE: Help - DBA interview questions I faced I am wondering how such people get into positions where they are responsible for hiring new staff, if they themselves know nothing. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, December 26, 2001 7:05 AM To: Multiple recipients of list ORACLE-L Subject: Re: Help - DBA interview questions I faced and eventually, when they realize they can't find that omniscient person, they come back to reality --- Robert Chin [EMAIL PROTECTED] wrote: I liked the interviews where they told me about their project, and I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn..We cannot know everything. That worked in the good old days (pre-2001), not any more, not by a long shot These days one is expected to be EXPERT of everything the employers list explicitly and implicitly (which seems to be getting longer...) plus this and that Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL Server ? Sybase ? MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps ? SAP? Essbase ? Cognos ? Informatica ? That's what's so freaky and hedious the job market for hands-on techies is. You ARE expected to know everything ! Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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
Re: Help - DBA interview questions I faced
Opinions vary, but often involve management fundament-snorkeling. --Scott Diver down! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 27, 2001 6:40 AM I am wondering how such people get into positions where they are responsible for hiring new staff, if they themselves know nothing. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 26, 2001 7:05 AM To: Multiple recipients of list ORACLE-L and eventually, when they realize they can't find that omniscient person, they come back to reality --- Robert Chin [EMAIL PROTECTED] wrote: I liked the interviews where they told me about their project, and I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn..We cannot know everything. That worked in the good old days (pre-2001), not any more, not by a long shot These days one is expected to be EXPERT of everything the employers list explicitly and implicitly (which seems to be getting longer...) plus this and that Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL Server ? Sybase ? MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps ? SAP? Essbase ? Cognos ? Informatica ? That's what's so freaky and hedious the job market for hands-on techies is. You ARE expected to know everything ! Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Help - DBA interview questions I faced
Dear Patrice Boivin and other list members, Thanks for your guidance. I am in the process of learning DBA stuff by reading concepts manual and I will try to experiment using personal oracle. Thanks and Regards. Dharan. --- Boivin, Patrice J [EMAIL PROTECTED] wrote: Dharan, Read the Concepts Manual again. If you can, go through the DBA 101 book and perhaps some of those Starter Kits Oracle Press has been cranking out lately. Are you administering Oracle database(s) now? Take time to poke around and see what is happening. Create a user account for yourself to experiment with, being careful not to cripple the rest of the system. You can do that by ensuring you don't have rights / privileges that give you too much freedom on the database. To understand, you need to read (know), but you also need to practice (experience). Once you will have done both, you will have learned from mistakes and you will understand what is happening. That will also give you a handle on which questions are relevant and which are not during interviews. Your next Oracle interview might be administered by someone who knows little or nothing about Oracle. (i.e. they are looking for a DBA, because their previous one left in disgust or they never had one). If you understand the basics of Oracle and you demonstrate during the interview that you do not consider saving face (putting up appearances) being more important than learning and fixing problems, you will have an honest chance at being hired as a junior DBA. At first you will have to live, eat, breathe, dream Oracle. You have to decide on this path and never give up. Never giving up is a crucial DBA trait. You have to be more stubborn than the server(s) you administer. You also have to be willing to change your approach if the previous one didn't work, the end result is what you aim for, and it is what you keep striving for until you get there. You have to take personal responsibility for the systems you administer. You must be reliable. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Dharani Ravi [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, December 25, 2001 7:45 AM To: Multiple recipients of list ORACLE-L Subject:Re: Help - DBA interview questions I faced Dear Rachel, Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two years ago. I am working for a small company where there are no seperate DBAs, System Administrators and Network Admins. Only three staff are identified to look after the abovementioned jobs in addition to development job. Most of our time goes for report generation, foxpro programs and other activities. I do not have a senior person from whom I can learn the job. Jobs like DB creation, maintanence, backup and recovery are done by me and I learned the job from manuals and by experience. I wanted to work in a production env where I can learn more about DBA job. I need your guidance and seniors guidance from this group. Hope you will appreciate my position and I sincerely request you to clarify my doubts. I will be grateful to you If you can clarify my mistakes made by me in the interview. I seek the support from this group to develop myself as a DBA. Merry Christmas. Regards. Dharan. --- Rachel Carmichael [EMAIL PROTECTED] wrote: Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about the database. Rachel --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions
Re: Help - DBA interview questions I faced
Dear Ramesh D Papnoi, Thanks for the info. I will buy it. Regards. Dharan. --- [EMAIL PROTECTED] wrote: Dear Ravi DBA 101 book - BY Gaja and kirti is available in India (indian edition). I already have one. Excelent book!! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] Dear Rachel, Thanks for your reply and guidance. Also thanks to Kirti Deshpande and Jenny Jacobson for their replies. In India Oracle DBA 101 book is not yet released. Once it is released I will defently purchase the book. Regarding Question No.1, I told that Server Process is the background process and sysauth or objauth view is used to check for username and password. The employer told me that I am wrong. Could you pl clarify. 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? Regards. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
you can get the documentation online. read it. according to the publishers, DBA 101 has been released in India. and it is available on the internet at any of the online book stores --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Rachel, Thanks for your reply and guidance. Also thanks to Kirti Deshpande and Jenny Jacobson for their replies. In India Oracle DBA 101 book is not yet released. Once it is released I will defently purchase the book. Regarding Question No.1, I told that Server Process is the background process and sysauth or objauth view is used to check for username and password. The employer told me that I am wrong. Could you pl clarify. 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? Regards. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
and eventually, when they realize they can't find that omniscient person, they come back to reality --- Robert Chin [EMAIL PROTECTED] wrote: I liked the interviews where they told me about their project, and I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn..We cannot know everything. That worked in the good old days (pre-2001), not any more, not by a long shot These days one is expected to be EXPERT of everything the employers list explicitly and implicitly (which seems to be getting longer...) plus this and that Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL Server ? Sybase ? MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps ? SAP? Essbase ? Cognos ? Informatica ? That's what's so freaky and hedious the job market for hands-on techies is. You ARE expected to know everything ! Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
Rachel, I'm Sorry for quoting wrong book. Actually I have both books and both are excellent! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] dba 101 is not by gaja and kirti -- that's performance tuning 101 which is indeed an excellent book dba 101 is theriault, carmichael and viscusi. --- [EMAIL PROTECTED] wrote: Dear Ravi DBA 101 book - BY Gaja and kirti is available in India (indian edition). I already have one. Excelent book!! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] Dear Rachel, Thanks for your reply and guidance. Also thanks to Kirti Deshpande and Jenny Jacobson for their replies. In India Oracle DBA 101 book is not yet released. Once it is released I will defently purchase the book. Regarding Question No.1, I told that Server Process is the background process and sysauth or objauth view is used to check for username and password. The employer told me that I am wrong. Could you pl clarify. 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? Regards. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
Dear Rachel, Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two years ago. I am working for a small company where there are no seperate DBAs, System Administrators and Network Admins. Only three staff are identified to look after the abovementioned jobs in addition to development job. Most of our time goes for report generation, foxpro programs and other activities. I do not have a senior person from whom I can learn the job. Jobs like DB creation, maintanence, backup and recovery are done by me and I learned the job from manuals and by experience. I wanted to work in a production env where I can learn more about DBA job. I need your guidance and seniors guidance from this group. Hope you will appreciate my position and I sincerely request you to clarify my doubts. I will be grateful to you If you can clarify my mistakes made by me in the interview. I seek the support from this group to develop myself as a DBA. Merry Christmas. Regards. Dharan. --- Rachel Carmichael [EMAIL PROTECTED] wrote: Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about the database. Rachel --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked me around 20 questions and the following are the questions where I have not fared well. Could Seniors help me by giving the appropriate answers for the following questions : 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? (I told server process, but could not remember the dictionary file and error msg file) 2) If you create a permanent tablespace and allot it to 5 users as temporary tablespace, how many extents will be allocated by oracle for each user ? (I answered that initial and next extent values will be alloted to the user. The employer told that my answer is not upto the mark) 3) When redo log contains both roll forward and rollback entries, why you require a separate rollback segment ? (I told that redo files are fixed in size and will be overwritten for large transaction, whereas rbs will grow to accommodate the entire transaction if autoextend is on and space is available) 4) When you insert or import 8 GB of data and your rollback segment is of 100 MB size (without autoextend), then what will happen to the transaction ? During inserts or import what entries will goto rollback segment ? (I told rbs has nothing to do with insert or import) 5) When deferred rollback segment is used ? ( I could not able to answer this question) 6) Is it possible to change ownership of Process IDs from oracle to the user who have invoked the process (for example all scott user processes are owned by Oracle user when you check in unix ps -ef |grep oracle command). Why the PIDs are owned by Oracle instead of the user who has invoked it ? (I answered - because the listener starts the process, the ownership is showing as oralce instead of the actual user. I could not able to answer how to change the ownership) 7) What are the other reasons for ORA-1555 error except rbs size is small ? 8) After starting database, where will the dictionary files will reside (memory or system tablespace datafile). If your answer is memory, then whether all the v$ and x$ and other dictionary files are loaded in memory ? ( I answered that it depeneds upon the size of SGA). 9) Where freelists are stored ? (I told that it is stored in datafile header) 10) Is 'direct_io' parameter is equal to raw device (I answered that to some extent it is true). Thanks in advance. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Re: Help - DBA interview questions I faced
Dear Rachel, Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two years ago. I am working for a small company where there are no seperate DBAs, System Administrators and Network Admins. Only three staff are identified to look after the abovementioned jobs in addition to development job. Most of our time goes for report generation, foxpro programs and other activities. I do not have a senior person from whom I can learn the job. Jobs like DB creation, maintanence, backup and recovery are done by me and I learned the job from manuals and by experience. I wanted to work in a production env where I can learn more about DBA job. I need your guidance and seniors guidance from this group. Hope you will appreciate my position and I sincerely request you to clarify my doubts. I will be grateful to you If you can clarify my mistakes made by me in the interview. I seek the support from this group to develop myself as a DBA. Merry Christmas. Regards. Dharan. --- Rachel Carmichael [EMAIL PROTECTED] wrote: Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about the database. Rachel --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked me around 20 questions and the following are the questions where I have not fared well. Could Seniors help me by giving the appropriate answers for the following questions : 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? (I told server process, but could not remember the dictionary file and error msg file) 2) If you create a permanent tablespace and allot it to 5 users as temporary tablespace, how many extents will be allocated by oracle for each user ? (I answered that initial and next extent values will be alloted to the user. The employer told that my answer is not upto the mark) 3) When redo log contains both roll forward and rollback entries, why you require a separate rollback segment ? (I told that redo files are fixed in size and will be overwritten for large transaction, whereas rbs will grow to accommodate the entire transaction if autoextend is on and space is available) 4) When you insert or import 8 GB of data and your rollback segment is of 100 MB size (without autoextend), then what will happen to the transaction ? During inserts or import what entries will goto rollback segment ? (I told rbs has nothing to do with insert or import) 5) When deferred rollback segment is used ? ( I could not able to answer this question) 6) Is it possible to change ownership of Process IDs from oracle to the user who have invoked the process (for example all scott user processes are owned by Oracle user when you check in unix ps -ef |grep oracle command). Why the PIDs are owned by Oracle instead of the user who has invoked it ? (I answered - because the listener starts the process, the ownership is showing as oralce instead of the actual user. I could not able to answer how to change the ownership) 7) What are the other reasons for ORA-1555 error except rbs size is small ? 8) After starting database, where will the dictionary files will reside (memory or system tablespace datafile). If your answer is memory, then whether all the v$ and x$ and other dictionary files are loaded in memory ? ( I answered that it depeneds upon the size of SGA). 9) Where freelists are stored ? (I told that it is stored in datafile header) 10) Is 'direct_io' parameter is equal to raw device (I answered that to some extent it is true). Thanks in advance. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Re: Help - DBA interview questions I faced
Dear Rachel, Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two years ago. I am working for a small company where there are no seperate DBAs, System Administrators and Network Admins. Only three staff are identified to look after the abovementioned jobs in addition to development job. Most of our time goes for report generation, foxpro programs and other activities. I do not have a senior person from whom I can learn the job. Jobs like DB creation, maintanence, backup and recovery are done by me and I learned the job from manuals and by experience. I wanted to work in a production env where I can learn more about DBA job. I need your guidance and seniors guidance from this group. Hope you will appreciate my position and I sincerely request you to clarify my doubts. I will be grateful to you If you can clarify my mistakes made by me in the interview. I seek the support from this group to develop myself as a DBA. Merry Christmas. Regards. Dharan. --- Rachel Carmichael [EMAIL PROTECTED] wrote: Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about the database. Rachel --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked me around 20 questions and the following are the questions where I have not fared well. Could Seniors help me by giving the appropriate answers for the following questions : 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? (I told server process, but could not remember the dictionary file and error msg file) 2) If you create a permanent tablespace and allot it to 5 users as temporary tablespace, how many extents will be allocated by oracle for each user ? (I answered that initial and next extent values will be alloted to the user. The employer told that my answer is not upto the mark) 3) When redo log contains both roll forward and rollback entries, why you require a separate rollback segment ? (I told that redo files are fixed in size and will be overwritten for large transaction, whereas rbs will grow to accommodate the entire transaction if autoextend is on and space is available) 4) When you insert or import 8 GB of data and your rollback segment is of 100 MB size (without autoextend), then what will happen to the transaction ? During inserts or import what entries will goto rollback segment ? (I told rbs has nothing to do with insert or import) 5) When deferred rollback segment is used ? ( I could not able to answer this question) 6) Is it possible to change ownership of Process IDs from oracle to the user who have invoked the process (for example all scott user processes are owned by Oracle user when you check in unix ps -ef |grep oracle command). Why the PIDs are owned by Oracle instead of the user who has invoked it ? (I answered - because the listener starts the process, the ownership is showing as oralce instead of the actual user. I could not able to answer how to change the ownership) 7) What are the other reasons for ORA-1555 error except rbs size is small ? 8) After starting database, where will the dictionary files will reside (memory or system tablespace datafile). If your answer is memory, then whether all the v$ and x$ and other dictionary files are loaded in memory ? ( I answered that it depeneds upon the size of SGA). 9) Where freelists are stored ? (I told that it is stored in datafile header) 10) Is 'direct_io' parameter is equal to raw device (I answered that to some extent it is true). Thanks in advance. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California--
Re: Help - DBA interview questions I faced
I didn't mean to demoralize you but if you read the manual two years ago, you need to re-read it. And I do suggest that you play with things in Oracle and read the manuals to understand what is going on. I still think you need to do research to get the answers to your questions but here are some of the answers. And you HAVE to read, we can't teach you everything you would need to know: 1) username and password can be found in the dba_users view. The password is stored encrypted and cannot be manually verified. Error messages displayed by the database processes are stored in the files in the ORACLE_HOME/rdbms/mesg directory 2) The question is misleading as extents are not automatically allocated to a user when they are assigned to a tablespace. When the users who have that tablespace as their temporary tablespace need temp segments, the allocation of extents will be based on the default storage parameters of the tablespace. If they wanted to know the maximum space a user could use in that tablespace, you would need to know the quota that was assigned to them -- in dba_ts_quotas. 3) Redo logs and rollback segments serve two different purposes. rollback segments are used within the database, to provide a consistent picture of a changing table to other users or to allow the user making changes to rollback their changes from the database. Redo logs are used when the database needs to do recovery. Oracle does NOT read the redo logs while the database is up and open, it only writes to them. 4) of course the rollback segment has something to do with inserts and imports as long as you are not doing them in nologging mode (even then, the rbs is written to for system metadata). The only time you don't write to a rollback segment is when you are doing a select -- and you might need to read them at that point. Rollback segments don't have autoextend -- I presume you mean the tablespace datafiles do not have autoextend. If you cannot get enough rollback space for the entire insert/import, and you are not doing an interim commit, you will lose the transaction and the changes you have made so far will be removed from the database when you fail to extend the rollback segment. If you have interim commits, you will a) need less rollback space and b) retain the data that has been committed. 5) deferred rollback segments are used for transactions in tablespaces that were taken offline while the transaction was in flight. 6) You cannot change the ownership of the process to the user who logged into the database because the user is not actually in the database, but is interfacing with an executing shared program which is owned by Oracle and therefore the process in the database is owned by oracle. 7) infrequent commits in a long-running transaction can be the cause of an 0ra-1555. Most of the time the problem is not that the rollback segment is too small. You can also have too few rollback segments. In general though, the problem is in the way the application(s) are coded and not within the database. 8) the tables are in both memory and the datafiles. 9) freelists are stored in the segment data block headers, NOT in the datafile headers --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Rachel, Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two years ago. I am working for a small company where there are no seperate DBAs, System Administrators and Network Admins. Only three staff are identified to look after the abovementioned jobs in addition to development job. Most of our time goes for report generation, foxpro programs and other activities. I do not have a senior person from whom I can learn the job. Jobs like DB creation, maintanence, backup and recovery are done by me and I learned the job from manuals and by experience. I wanted to work in a production env where I can learn more about DBA job. I need your guidance and seniors guidance from this group. Hope you will appreciate my position and I sincerely request you to clarify my doubts. I will be grateful to you If you can clarify my mistakes made by me in the interview. I seek the support from this group to develop myself as a DBA. Merry Christmas. Regards. Dharan. --- Rachel Carmichael [EMAIL PROTECTED] wrote: Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about
Re: Help - DBA interview questions I faced
What I have found is that interviewing for an Oracle DBA job is quite different from doing the actual job. I've been a contractor - and had to interview after each gig was over. My job consisted of action - entering the commands, people skills, collecting useful scripts just in case - and using them shortly afterwards. When a situation came up, it meant going through my spreadsheet of resources collected over the years. For interviewing, it can be more theoretical bookish - 1. What are the four essential background processes and how are they used. 2. How is an outer join different from an inner join. I liked the interviews where they told me about their project, and I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn. We cannot know everything. On my last project, we had seven Oracle DBAs. Each one had something to contribute. Sometimes I'd know something that the most seasoned, knowledgeable DBA would not know - because they had not learned new extensions to existing commands. What I do with difficult interviews - when I haven't done well, is to write down the questions as they are being asked. Research the answers, and be better prepared for the next interview. That's how I got my start in DBA-land. I eventually knew most of the answers to most questions. I even discovered DBAs who had the wrong answers to their own interview questions. What can you do - just keep in mind you're dealing with human beings. You will end up at the job that is best for you - and the client. Jenny Jacobson www.oracle-dba-consulting.com On Tue, 25 Dec 2001, Dharani Ravi wrote: Thanks for your reply. Initially I felt demoralised after reading your reply. Truth is always bitter. You are correct. My Oracle concepts knowledge needs to be improved. I read Oracle 8 concepts manual two -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
Dear Rachel, Thanks for your reply and guidance. Also thanks to Kirti Deshpande and Jenny Jacobson for their replies. In India Oracle DBA 101 book is not yet released. Once it is released I will defently purchase the book. Regarding Question No.1, I told that Server Process is the background process and sysauth or objauth view is used to check for username and password. The employer told me that I am wrong. Could you pl clarify. 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? Regards. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
Dear Ravi DBA 101 book - BY Gaja and kirti is available in India (indian edition). I already have one. Excelent book!! Regards, Ramesh D Papnoi Oracle DBA @ Chemtex Global Engineers Pvt. Ltd., Mumbai, India (BrainBench Brainbuzz Certified Oracle 8/8i DBA Developer) http://www22.Brinkster.com/rpapnoi -- Original Text -- To: internet[Multiple recipients of list ORACLE-L [EMAIL PROTECTED]] Dear Rachel, Thanks for your reply and guidance. Also thanks to Kirti Deshpande and Jenny Jacobson for their replies. In India Oracle DBA 101 book is not yet released. Once it is released I will defently purchase the book. Regarding Question No.1, I told that Server Process is the background process and sysauth or objauth view is used to check for username and password. The employer told me that I am wrong. Could you pl clarify. 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? Regards. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
I liked the interviews where they told me about their project, and I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn..We cannot know everything. That worked in the good old days (pre-2001), not any more, not by a long shot These days one is expected to be EXPERT of everything the employers list explicitly and implicitly (which seems to be getting longer...) plus this and that Oracle guru ? you'd wish it's so simple...so Mr Xyz, do you know SQL Server ? Sybase ? MQ ? Java ? EJB? ASP? Data Warehousing ? data modeling ? Oracle Apps ? SAP? Essbase ? Cognos ? Informatica ? That's what's so freaky and hedious the job market for hands-on techies is. You ARE expected to know everything ! Robert Chin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Chin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
[OT] Re: Help - DBA interview questions I faced
-- Robert Chin [EMAIL PROTECTED] on 12/25/01 22:30:20 -0800 I told them how I could contribute - strengths and weaknesses. I'm great at *. I don't know much about YYY, but I'm willing to learn..We cannot know everything. That worked in the good old days (pre-2001), not any more, not by a long shot These days one is expected to be EXPERT of everything the employers list Well, at least you have to know more than the person asking the questions :-). As a consultant I regularly run across people who have taken the 20-minute-online-CD prep and gotten mid-level DBA jobs. Once in they're a rather inoperable form of cancer. I've actually had better luck in most cases by explicitly knowing what I don't know. e.g., for Oracle [at least slightly on topic] I don't claim to understand all of the memory managlement and trigger changes from 8.1.X to 9.0. I also don't claim to know all the foibles of their new substitute construction system. This beats not knowing about it at all. -- Steven Lembark 2930 W. Palmer Workhorse Computing Chicago, IL 60647 +1 800 762 1582 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Help - DBA interview questions I faced
Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked me around 20 questions and the following are the questions where I have not fared well. Could Seniors help me by giving the appropriate answers for the following questions : 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? (I told server process, but could not remember the dictionary file and error msg file) 2) If you create a permanent tablespace and allot it to 5 users as temporary tablespace, how many extents will be allocated by oracle for each user ? (I answered that initial and next extent values will be alloted to the user. The employer told that my answer is not upto the mark) 3) When redo log contains both roll forward and rollback entries, why you require a separate rollback segment ? (I told that redo files are fixed in size and will be overwritten for large transaction, whereas rbs will grow to accommodate the entire transaction if autoextend is on and space is available) 4) When you insert or import 8 GB of data and your rollback segment is of 100 MB size (without autoextend), then what will happen to the transaction ? During inserts or import what entries will goto rollback segment ? (I told rbs has nothing to do with insert or import) 5) When deferred rollback segment is used ? ( I could not able to answer this question) 6) Is it possible to change ownership of Process IDs from oracle to the user who have invoked the process (for example all scott user processes are owned by Oracle user when you check in unix ps -ef |grep oracle command). Why the PIDs are owned by Oracle instead of the user who has invoked it ? (I answered - because the listener starts the process, the ownership is showing as oralce instead of the actual user. I could not able to answer how to change the ownership) 7) What are the other reasons for ORA-1555 error except rbs size is small ? 8) After starting database, where will the dictionary files will reside (memory or system tablespace datafile). If your answer is memory, then whether all the v$ and x$ and other dictionary files are loaded in memory ? ( I answered that it depeneds upon the size of SGA). 9) Where freelists are stored ? (I told that it is stored in datafile header) 10) Is 'direct_io' parameter is equal to raw device (I answered that to some extent it is true). Thanks in advance. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Help - DBA interview questions I faced
Dharan, Answering just those questions will not give you enough knowledge to truly be able to answer Oracle questions in an interview. Based on the answers you gave, it seems to me that you do not understand the concepts behind how Oracle works at all. I would suggest you read the documentation (specifically the Concepts and Administrator's manuals to start) to get a better understanding of Oracle. I would also suggest you talk to the senior DBA where you are and ask him or her to help you learn about the database. Rachel --- Dharani Ravi [EMAIL PROTECTED] wrote: Dear Seniors, I am a junior DBA and last weekend I attended a interview for DBA post. The following questions were asked to me and I could not able to answer to the employers satsifaction. He asked me around 20 questions and the following are the questions where I have not fared well. Could Seniors help me by giving the appropriate answers for the following questions : 1) When you enter 'sqlplus scott/tiger' which background process checks for authentication ? From which table/view it checks for authentication ? If password is wrong from where oracle throws the msg ? (I told server process, but could not remember the dictionary file and error msg file) 2) If you create a permanent tablespace and allot it to 5 users as temporary tablespace, how many extents will be allocated by oracle for each user ? (I answered that initial and next extent values will be alloted to the user. The employer told that my answer is not upto the mark) 3) When redo log contains both roll forward and rollback entries, why you require a separate rollback segment ? (I told that redo files are fixed in size and will be overwritten for large transaction, whereas rbs will grow to accommodate the entire transaction if autoextend is on and space is available) 4) When you insert or import 8 GB of data and your rollback segment is of 100 MB size (without autoextend), then what will happen to the transaction ? During inserts or import what entries will goto rollback segment ? (I told rbs has nothing to do with insert or import) 5) When deferred rollback segment is used ? ( I could not able to answer this question) 6) Is it possible to change ownership of Process IDs from oracle to the user who have invoked the process (for example all scott user processes are owned by Oracle user when you check in unix ps -ef |grep oracle command). Why the PIDs are owned by Oracle instead of the user who has invoked it ? (I answered - because the listener starts the process, the ownership is showing as oralce instead of the actual user. I could not able to answer how to change the ownership) 7) What are the other reasons for ORA-1555 error except rbs size is small ? 8) After starting database, where will the dictionary files will reside (memory or system tablespace datafile). If your answer is memory, then whether all the v$ and x$ and other dictionary files are loaded in memory ? ( I answered that it depeneds upon the size of SGA). 9) Where freelists are stored ? (I told that it is stored in datafile header) 10) Is 'direct_io' parameter is equal to raw device (I answered that to some extent it is true). Thanks in advance. Dharan. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dharani Ravi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
SAP Interview Questions
We are looking to hire an SAP Systems Analyst. Can anyone suggest some good questions/answers specific to SAP? I have seen lists of Oracle interview questions so I was wondering if anyone has seen any on SAP? Or, if you just know some good questions/answers, please send them to me. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Connie Milliken INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).