Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
517What 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?
538If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
534Which is the best option used to move database from one server to another serve on same network and why?
500What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
591The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
516The 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?
527You 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?
556Post New Oracle DBA (Database Administration) Questions
How can you tell if an index on particular table is used or not used in 9i?
What is dump destination? What are bdump, cdump and udump?
What is dba in sound level?
What is the difference between sga and pga?
What is tkprof and how is it used?
A developer is trying to create a view and the database won’t let him. He has the "developer" role which has the "create view" system privilege and select grants on the tables he is using, what is the problem?
How can you determine the space left in a file system?
Guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?
What are four common errors found in an alert .log?
What database block size should I use?
What happens when the default and temp tablespace clauses are left out from create user statements?
Explain the various modes of normalization?
How can be determining the size of the log files?
What is the purpose of the import option ignore? What is its default setting?
What should a dba know?