What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different responsibilities of a dba?
Users get the following error: ora-00055 maximum number of dml locks exceeded? What is the problem and how do you fix it?
When using oracle export/import what character set concerns might come up? How do you handle them?
What is the main function of database?
What are some indications that you need to increase the shared_pool_size parameter?
Which dba certification is best?
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 is dba and functionalities of dba?
How should a many-to-many relationship be handled?
What are the types of locks in database?
What is dba training?
What is different type of rman backup?