Interested to Buy Any Domain ? << Click Here >> for more details...
1)what is the difference between view and materilized view?
2)what is the difference between delete and truncate?
3)what is the difference between migration and upgration?
4)what is the difference between RMAN HOT BACKUP and normal
hot backup?
- 2 Answers
- 6059 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / praveen hattikal
2)Truncate is a DDL command, which has autocommit hence
cant be rolled back where as delete is DML with user commit
& roll back option. Truncate is faster then delete since it
wont store any data to backup tablespace. before delting.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the differences between a dbms and rdbms?
What is query in database?
What is cold backup, hot backup, warm backup recovery?
How do I create a database in open office?
What is the main difference between union and union all?
How do databases help businesses?
Why rdbms is called relational?
What is database host?
Is access a database program?
If I use netlib, will I find many other users to network with?
Why normalisation is required?
What is the use of drop command and what are the differences between drop, truncate and delete commands?
What are the four objects in a database?
Tell me about view, sequence and index in DBMS.
Operators used in select statements are?
