What is the difference between truncate and delete? How would a full table scan behave after?
No Answer is Posted For this Question
Be the First to Post Answer
While taking hot backup (begin end backup) what will happens back end?
How can you tell if an index on particular table is used or not used in 9i?
How do you use automatic pga memory management with oracle 9i and above?
What is the relation between database and instance?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
What is the advantage of using rman?
What does >> do?
What degree do database administrators need?
What does the no logging option do? Why would we be careful of using it?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
How can you find dead processes?