Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
579What 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?
588If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
595Which is the best option used to move database from one server to another serve on same network and why?
550What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
675The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
581The 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?
581You 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?
606Post New Oracle DBA (Database Administration) Questions
If you see contention for library caches how you can fix it?
Does dba need to know programming?
Which process writes data from data files to database buffer cache?
If you have an example table, what is the best way to get sizing data for the production table implementation?
What do you understand by the term 'system change number (scn)'?
What do you understand by the term 'normalization'?
What is oracle dba role?
What is the finger command?
What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
How do I become a database administrator?
What are functions of dba?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
What is dump destination? What are bdump, cdump and udump?
What are the main benefits of using spfile over pfile?
What is mutated trigger? In single user mode we got mutated error, as a dba how you will resolve it?