Interested to Buy Any Domain ? << Click Here >> for more details...
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
580Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
817What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
601Is it necessary to have database in archive log mode in configuration dataguard , if yes then why?
622Post New Oracle DBA (Database Administration) Questions
Who is a database user?
What are the possible ways to gain information regarding the control file?
A user is getting an ora-00942 error yet you know you have granted them permission on the table, what else should you check?
What is main function of database administrator?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
You have just started a new instance with a large sga on a busy existing server. Performance is terrible, what should you check for?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
You are getting busy buffer waits. Is this bad? How can you find what is causing it?
What is pga_aggregate_target?
What skills do you need to be a database administrator?
What is explain plan and how is it used?
What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
