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?
If you know the answer to the following questions then you are a nominee for a senior DBA
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?