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?
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
Which is the best database?
Explain the term generalization.
What is record in a database?
Explain bcnf (boyce-codd normal form)?
Is it possible to break netlibs encryption?
How do you copy a database?
What is the full form of rdbms?
What are its two major subsystems of r?
What is a field in database?
Define sub-query.
Define a relation schema and a relation.
What is netlib for clipper?
What are the importance of partitioning in dbms?
How to debug stored procedures?
What is compound key?