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
You have installed oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
As an oracle dba what are the entire unix file you should be familiar with?
Explain procedure to change characterset of a database.
Why do we need a database?
Do you need a commit after ddl statements?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What are bind variables and why are they important?
What is dump destination? What are bdump, cdump and udump?
What is the meaning of database backup?
When should the default values for oracle initialization parameters be used as is?