What is the difference between truncate and delete? Why is one faster?
No Answer is Posted For this Question
Be the First to Post Answer
What does the no logging option do? Why would we use it? Why would we be careful of using it?
What are the functions of administration?
What are dba privileges?
What are the various ingredients of sga?
Is oracle dba in demand?
What happens if a tablespace clause is left off of a primary key constraint clause?
If you see the value for reloads is high in the estat library cache report is this a matter for concern?
You see multiple fragments in the system tablespace, what should you check first?
What is ora-1555 snapshot too old error? Explain in detail?
What is the full form of dba?
If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)
What degree do database administrators need?