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.

Give the order of sql select?

0 Answers  

---

Is sql an operating system?

0 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

Which one of the following pairs of aggregate functions do you use with character fields? 1. COUNT(field) and MAX(field) 2. AVG(field) and COUNT(field) 3. MIN(field) and SUM(field) 4. AVG(field) and MAX(field) 5. COUNT(field) and SUM(field)

6 Answers   HCL,

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

Is nosql faster than sql?

0 Answers  

---

What is forward declaration in pl sql?

0 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

what is isam? : Sql dba

0 Answers  

---

What is sql*loader and what is it used for?

0 Answers  

---

What is a schema sql?

0 Answers  

---

What is rule base and cost base optimizer?

2 Answers   Thermotech,

---