Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
285What 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?
302If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
277Which is the best option used to move database from one server to another serve on same network and why?
249What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
311The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
291The 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?
286You 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?
273Post New Oracle DBA (Database Administration) Questions
When should an artificial (or derived) primary key be used?
What is the full form of dba?
What are the different types of database users?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What are dba privileges?
What is the difference between a database and instance? What is the relation between them?
When using oracle export/import what character set concerns might come up? How do you handle them?
What do you mean by oracle dba?
What is end user in database?
What database block size should I use?
When should you increase copy latches? What parameters control copy latches?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
What is da in database?
What are database skills?
Does dba need to know programming?