Explain the difference between the truncate and delete commands?
Submitted by: AdministratorTruncate :
It is a DDL command, used to delete tables or clusters. Since it is a DDL command hence it is auto commit and Rollback can't be performed. It is faster than delete.
Delete:
It is DML command, generally used to delete a record, clusters or tables. Rollback command can be performed , in order to retrieve the earlier deleted things. To make deleted things permanently, "commit" command should be used.
Submitted by: Administrator
It is a DDL command, used to delete tables or clusters. Since it is a DDL command hence it is auto commit and Rollback can't be performed. It is faster than delete.
Delete:
It is DML command, generally used to delete a record, clusters or tables. Rollback command can be performed , in order to retrieve the earlier deleted things. To make deleted things permanently, "commit" command should be used.
Submitted by: Administrator
Read Online Ab Initio Job Interview Questions And Answers
Top Ab Initio Questions
| ☺ | How do you convert 4-way MFS to 8-way mfs? |
| ☺ | What is skew and skew measurement? |
| ☺ | What is local and formal parameter? |
| ☺ | What is the difference between rollup and scan? |
| ☺ | What does dependency analysis mean in Ab Initio? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
