Definition of an Oracle DBA?

[newbie]

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?

[agasimani]

Simple, if I join the organization before you, I will be called Senior DBA and you will be Assistant DBA.

[adewri]

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?

[SANJAY_G]

"Information's pretty thin stuff unless mixed with experience." ~Clarence Day, The Crow's Nest

[adewri]

Yep and answer to such question comes with experience.

:-)

[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.

[dknight]

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?

[jovery]

Originally posted by dknight
Which one *is* the bigger idiot?

That's probably too close to call

[SANJAY_G]

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 ??

[julian]

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 :-)