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
- 5938 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 is entity relationship diagram?
What is called dbms?
Suppose database is running slow, what will you do?
i have cleared the nic test...please send me the interview questions if anyone have them.... my email id is v84priya@gmail.com
Does google have a database like access?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
What are 4 types of models?
How to improve query performance using index hunting?
What are the advantages of database?
Define primary and unique key?
How to move a multi-file database?
What are the four objectives of the selection of a data type?
How data are stored in database?
what is the difference between two and three-tier architectures?
Mention the differences between unique key and primary key
