Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
611What 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?
620If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
637Which is the best option used to move database from one server to another serve on same network and why?
583What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
709The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
624The 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?
612You 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?
640Post New Oracle DBA (Database Administration) Questions
If you see statistics that deal with "undo" what are they really talking about?
What are the five functions of a database?
What are database skills?
Can you remove an open file under unix?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
I am getting error "no communication channel" after changing the domain name? What is the solution?
What causes the "snapshot too old" error? How can this be prevented or mitigated?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
How should a many-to-many relationship be handled?
While taking hot backup (begin end backup) what will happens back end?
How do I become an administrator?
What are functions of dba?
How can you find out how many users are currently logged into the database?
When should you increase copy latches? What parameters control copy latches?
What is the difference between internal & external schema?