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 roles and responsibilities of oracle dba?
Do you need a commit after ddl statements?
How does one create a new database?
What is the main function of database?
What do you understand by the term 'normalization'? Explain the various modes of normalization?
How can you find all the processes on your system?
What happens if a tablespace clause is left off of a primary key constraint clause?
If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
What is the difference between truncate and delete? How would a full table scan behave after?
What are the five functions of a database?
Which function is used to find the largest integer less than or equal to aspecific value?
As an oracle dba what are the entire unix file you should be familiar with?