Answer Posted / ameya aloni

TRUNCATE:
1. Faster - does its work in single execution by
deallocating the data pages used by the table and reducing
the resource overhead of logging the deletions, as well as
the number of locks acquired.
2. Is DDL command
3. Removes all data
4. Does not make entries in a LOG file
3. Can't be rolled-back
4. Can't filter using WHERE clause
5. Can't call DML triggers
6. Can't ensure data consistency in case of foreign-key
references
7. Resets the IDENTITY back to the SEED

DELETE:
1. Slower - does its work by deleting rows one at a time,
logging each row in the transaction log, maintaining log
sequence number (LSN) information and consuming more
database resources and locks.
2. Is DML command
3. Removes data row-by-row
4. Makes entry per row in a LOG file
3. Can use COMMIT or ROLLBACK
4. Can filter using WHERE clause
5. Can call DML triggers
6. Ensures data consistency in case of foreign-key references
7. Does not reset the IDENTITY

Is sqlexception checked or unchecked?

918

---

How to create a menu in sqlplus or pl/sql?

1063

---

Why do we use cursors?

919

---

How many indexes can be created on a table in sql?

985

---

Is grant a ddl statement?

854

---

Is the primary key an index?

981

---

What are the types of join in sql?

1027

---

What is cost in sql execution plan?

904

---

What is a column in a table?

1061

---

What is sql and explain its components?

1007

---

Is sql developer case sensitive?

944

---

What is a clob in sql?

967

---

How to run pl/sql statements in sql*plus?

1021

---

What are the different sql commands?

1001

---

What is percent sign in sql?

1213

---