Interested to Buy Any Domain ? << Click Here >> for more details...
What is a dba certification?
- 0 Answers
- 582 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Which process writes data from data files to database buffer cache?
You 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?
How do you prevent output from coming to the screen?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
Show one instance when you encountered an error in alert log and you overcome that error. What actions you took to overcome that error.
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
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?
When should the default values for oracle initialization parameters be used as is?
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?
Explain the wait events in statspack report 'db sequential real'?
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 are database skills?
Oracle General 
