Interested to Buy Any Domain ? << Click Here >> for more details...
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
539What happens when the default and temp tablespace clauses are left out from create user statements?
543When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
565What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
554How can you find out how many users are currently logged into the database? How can you find their operating system id?
489You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
566I am getting error "no communication channel" after changing the domain name? What is the solution?
551Post New Oracle DBA (Database Administration) Questions
What are functions of dba?
How do you install statspack?
What 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?
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 dba why is this position necessary?
When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
What exactly does a dba do?
What is the difference between sga and pga?
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?
What are the daily activities of oracle dba?
What is an artificial (derived) primary key?
What are roles in oracle?
Does a dba have to file taxes?
Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?
