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
- 5324 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 advantages of database?
What are databases what are the uses of databases?
Is driver a software?
Is database a data structure?
What is the purpose of a model?
Is sql a database?
Why normalisation is required?
dear sir please provide what question will be asked in bank it officer interview
does pl/sql support “overloading”? Explain
what is storage manager?
What is difference between database and website?
What is a checkpoint and When does it occur in database?
What is in a database?
Explain dml (data manipulation language)?
How to use events with zebedee, ssh or stunnel?
