Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between DELETE, TRUNCATE, and DROP?
- 3 Answers
- 1568 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
• DELETE:
o Deletes specific rows from a table.
o Can have a WHERE clause.
o DML command (can be rolled back).
• TRUNCATE:
o Deletes all rows from a table.
o Faster than DELETE (does not log individual row deletions).
o DDL command (cannot be rolled back).
• DROP:
o Removes a table entirely (schema + data).
o DDL command.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Write the alter statement to enable all the triggers on the t.students table.
Why do we use sql constraints?
What is the difference between join and natural join?
How to display Row Number with Records in Oracle SQL Plus?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
How to process query result in pl/sql?
Where not exists in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
How many types of functions are there in sql?
How can you fetch first 5 characters of the string?
Show the cursor attributes of pl/sql.
What are different categories of sql commands?
What is normalisation in sql?
Why should I use postgresql?
What is sql and its types?
