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
- 6138 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 some disadvantages of a standard language such as sql?
Why is maintaining a database important?
What is the difference between horizontal and vertical partitioning?
What are stored-procedures? And what are the advantages of using them.
What does partition mean in database?
How do you set a primary key?
What is tuple with example?
What are collection pools? What are the advantages?
What is tuple in dbms?
Why do we need to use a database?
What is db dialect?
dear sir please provide what question will be asked in bank it officer interview
Explain the term entity set in dbms?
What information can be stored in a database?
What is rank in database?
