DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 25

Thread: Definition of an Oracle DBA?

  1. #1
    Join Date
    Mar 2001
    Posts
    149

    Definition of an Oracle DBA?

    Hello all, I have a non technical question that kind of puzzled my mind for the last little while. What's a true definition of a senior Oracle DBA? How are they different from intermediate DBA? Years? Age? Resposibility?

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304

    Talking

    Simple, if I join the organization before you, I will be called Senior DBA and you will be Assistant DBA.
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi

    If you know the answer to the following questions then you are a nominee for a senior DBA

    Regards
    Amar

    PS: Just kidding dont take it too seriously. These are few things that a seniour DBA must know. So you can judge yourself.

    Give one method for transferring a table from one schema to another:

    What are some of the Oracle provided packages that DBAs should be aware of?

    What is the proper method for disabling and re-enabling a primary key constraint?

    What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

    When should more than one DB writer process be used? How many should be used?

    You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?

    What causes the “snapshot too old” error? How can this be prevented or mitigated?

    A developer is trying to create a view and the database won’t let him. He has the “DEVELOPER” role that has the “CREATE VIEW” system privilege and SELECT grants on the tables he is using, what is the problem?

    If you have an example table, what is the best way to get sizing data for the production table implementation?

    How can you find out how many users are currently logged into the database? How can you find their operating system id?

    A user selects from a sequence and gets back two values, his select is:

    SELECT pk_seq.nextval FROM dual;

    What is the problem?

    How can you determine if an index needs to be dropped and rebuilt?

    How can you call a PL/SQL procedure from SQL?

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    "Information's pretty thin stuff unless mixed with experience." ~Clarence Day, The Crow's Nest
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  5. #5
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Yep and answer to such question comes with experience.

    :-)

  6. #6
    Join Date
    Mar 2002
    Posts
    200
    In simple words its like asking what is the difference between Vice President and Assitant Vice President. In my opinion, one is a bigger idiot than the other.

  7. #7
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Originally posted by quester
    In simple words its like asking what is the difference between Vice President and Assitant Vice President. In my opinion, one is a bigger idiot than the other.
    Which one *is* the bigger idiot?
    David Knight
    OCP DBA 8i, 9i, 10g

  8. #8
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by dknight
    Which one *is* the bigger idiot?
    That's probably too close to call
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  9. #9
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by quester
    In simple words its like asking what is the difference between Vice President and Assitant Vice President. In my opinion, one is a bigger idiot than the other.
    ..and what about President then ??
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by agasimani
    Simple, if I join the organization before you, I will be called Senior DBA and you will be Assistant DBA.
    That is not always true. I am a counterexample :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width