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
How can be determining the size of the log files?
What do you understand by a control file?
What are the main functions of dba?
You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?
How can you determine if an index needs to be dropped and rebuilt?
List five most important parameter in 9i affecting performance?
What is oracle log switch?
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 happens if a tablespace clause is left off of a primary key constraint clause?
How can you determine the space left in a file system?
What is the difference between raid 5 and raid 10? Which is better for oracle?
How can you tell if a tablespace has excessive fragmentation?