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
- 5972 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 network and hierarchical database model?
How do I keep my database up to date?
How rdbms is different from dbms?
What are the benefits of database?
What is db context?
Can you explain the select into statement?
What is rank in database?
Why rdbms is called relational?
Explain the Surrogate Key in DBMS.
Plz send me Oracle Pl/Sql [1z0-147] dumps to this mail? sivakumarr1987@gmail.com
Can you have more than one cursor open at any one time in a program ?
What is package in dbms?
What are the different types of database?
What are the two types of database?
How does a database partition work?
