Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
573What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
586If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
590Which is the best option used to move database from one server to another serve on same network and why?
547What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
668The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
577The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
575You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
601Post New Oracle DBA (Database Administration) Questions
Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
How do you analyze table partition using oracle provided package?
If you are not sure what command does a particular unix function what is the best way to determine the command?
Which process writes data from data files to database buffer cache?
What are the various ingredients of sga?
What are elements of administration?
What are the main benefits of using spfile over pfile?
How do you install statspack?
What degree do database administrators need?
What skills do you need to be an administrator?
What is the difference between sga and pga?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
How to uncatalog backup?
What is an artificial (derived) primary key?
What is da in database?