What are the types of locks in database?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the wait events in statspack report 'db sequential real'?
Does dba need to know programming?
What is the main function of database?
How can you tell if a tablespace has excessive fragmentation?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
What is the difference between cold backup and hot backup?
What is a production dba?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
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?
How long does it take to learn database administration?
What is tkprof and how is it used?
What is dba software?