Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
291What 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?
310If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
284Which is the best option used to move database from one server to another serve on same network and why?
257What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
317The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
298The 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?
293You 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?
280Post New Oracle DBA (Database Administration) Questions
What are the goals of dba?
You have taken a manual backup of a datafile using os. How rman will know about it?
What do you understand by a control file?
What skills should a dba have?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
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 pct free/pct used/pct increase parameter in segment? What is growth factor?
You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?
How can you find out how many users are currently logged into the database? How can you find their operating system id?
Which is the best option used to move database from one server to another serve on same network and why?
What are the beneficial tools for administering the database?
What does a senior database administrator do?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
What are the different types of backup available in the oracle?
Can you remove an open file under unix?