Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
568What 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?
574If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
585Which is the best option used to move database from one server to another serve on same network and why?
538What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
659The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
562The 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?
565You 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?
593Post New Oracle DBA (Database Administration) Questions
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
If you are not sure what command does a particular unix function what is the best way to determine the command?
What does a senior database administrator do?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What is oracle full backup?
How can you tell if a tablespace has excessive fragmentation?
What does a dba stand for?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
How many control files should you have?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
What is a database instance?
What are dba privileges?
When should you increase copy latches?
What database block size should I use?
Which date function is used to find the difference between two dates?