Do you need a commit after ddl statements?
No Answer is Posted For this Question
Be the First to Post Answer
Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?
Which is the best option used to move database from one server to another serve on same network and why?
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 are database skills?
You see multiple extents in the temporary tablespace. Is this a problem?
You see a wait on lms process in statspack, what does that mean?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What are four common errors found in an alert .log?
What is a dba certification?
You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?
What are types of data model?
What do you understand by the term 'system change number (scn)'?