Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / nandini sett
Both delete and Trunate are DML or Data Manupilating
Language.
Both statements --- Delete table_name and Truncate table
table_name --- deletes all rows.
Truncate Table works faster than delete.
Truncate table does not support where clause and truncate
doe not fire a trigger. When truncate is used the deleted
rows are not entered in transaction log.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can a table contain multiple foreign key’s?
Is sql developer case sensitive?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
How to run sql statements with oracle sql developer?
What are the types of subqueries?
What pl/sql package consists of?
Is sqlite good enough for production?
What is the usage of distinct keyword?
What do we need to check in database testing?
What is plpgsql language?
What is difference between inner join and self join?
What is delimiter sql?
How to use boolean type in select statement?
Can you have more than one trigger on a table?
What are the types of join in sql?
