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?
582What happens when the default and temp tablespace clauses are left out from create user statements?
574When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -how do you correct it?
601What does a hard one-to-one relationship mean (one where the relationship on both ends is "must")?
593How can you find out how many users are currently logged into the database? How can you find their operating system id?
539You 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?
604I am getting error "no communication channel" after changing the domain name? What is the solution?
600Post New Oracle DBA (Database Administration) Questions
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 is a production dba?
What is ora-1555 snapshot too old error? Explain in detail?
Tell me about standby database? What should we watch out for?
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?
Which date function is used to find the difference between two dates?
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?
Discuss row chaining, how does it happen?
What are the skills required for oracle dba?
Does a dba have to file taxes?
Give one method for transferring a table from one schema to another?
What operator tests column for the absence of data?
Which process writes data from data files to database buffer cache?
What is main function of database administrator?
Discuss row chaining, how does it happen? How do you correct it?
