Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kiran.
Delete(DML) : All records not possible to Delete at a time,
Where clause is allowed.
structure of the table is available.
Roll Back is possible.
Truncate(DDL): All records possible to Delete at a time,
Where clause is not allowed.
structure of the table is not available.
Roll Back is possible.
>Truncate Table<tablename>;
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What does fetching a cursor do?
Can cursors be part of a trigger body?
What is pessimistic concurrency control? : Transact sql
How can you tell the difference between an index and a view?
Explain the working of primary key?
Is it possible to sort a column using a column alias?
Is sql open source?
What is sqlerrm?
Explain what is an index?
What are the advantages of indexing?
what is the difference between blob and text? : Sql dba
how do you tune the slow running queries in oracle db , explain the methodology
What is rank dense_rank and partition in sql?
Can we use ddl statements in stored procedure sql server?
Explain what is sql*plus?
