Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
531What 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?
545If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
545Which is the best option used to move database from one server to another serve on same network and why?
511What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
608The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
524The 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?
540You 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?
566Post New Oracle DBA (Database Administration) Questions
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What is the use of the drop option in the alter table command?
What are the different types of database users?
What is dump destination? What are bdump, cdump and udump?
What is the difference between sga and pga?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
How do I become a data manager?
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.
What is the difference between truncate and delete? How would a full table scan behave after?
What are the goals of dba?
How many control files should you have?
What is pga_aggregate_target?
What are the roles and responsibilities of oracle dba?
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?