Answer / nashiinformaticssolutions

• 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.

Answer / glibwaresoftsolutions

• 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.

Answer / 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.

What is pl/sql tables?

7 Answers   TCS,

---

What is the difference between function and procedure in pl/sql?

0 Answers  

---

Which one is better subquery or joins?

0 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

Which is faster truncate or drop?

0 Answers  

---

How to recompile a already made trigger?

2 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

What is full join?

0 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

what is a database lock ? : Sql dba

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

In pl/sql, what is bulk binding, and when/how would it help performance?

0 Answers  

---