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 > > 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 > === message truncated === __________________________________________________ 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).