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 magic table?

6 Answers  

---

How do I clear the screen in sql plus?

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

If the base table structure is changed what will happen to join index????

2 Answers  

---

What is a relationship and what are they?

0 Answers  

---

How can i insert data inro a table with 3 columns using FORALL?

2 Answers   Oracle,

---

What are sql commands?

0 Answers  

---

What is orm in sql?

0 Answers  

---

What is a scalar value in sql?

0 Answers  

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

i want to display 1 to 10 numbers using one select statement.

18 Answers   HCL, Nyros, Oracle,

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---