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
- 6029 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
How can you get the alternate records from the table in the sql?
What is sql in database management system?
Operators used in select statements are?
What do you mean by query evaluation engine?
Why do we need to use a database?
What is the purpose of a database table?
How is data stored in a relational database?
What is 3nf in the dbms?
Explain the terms ‘attribute’ and ‘relations’
How to tell firebird to only accept conections from xyz host or network?
Why do we need database normalization?
Do I need ccp4?
Explain the importance of database partitioning.
What is the difference between star flake and snow flake schema?
write a query to retrieve the last day of next month in oracle.
