Answer Posted / ram kumar

1.Both are same but a little bit difference between them

2.Truncate removes all the rows in the table and it cannot
be rolledback bcoz its a DDL

3.Delete removes the particular record u want in the table
and it can be rolledback bcoz its a DML

4.Truncate is Unconditional and Delete is Conditional

Regards,
Ram Kumar...

Write a unique difference between a function and a stored procedure.

924

---

Who developed sql?

960

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1001

---

What is oracle sql developer?

992

---

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

916

---

How run sql*plus commands that are stored in a local file?

975

---

What is difference between sql and excel?

1006

---

What are the various restrictions imposed on view in terms of dml?

909

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

991

---

how to dump a table to a file with 'mysqldump'? : Sql dba

982

---

What are types of joins?

908

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1014

---

What does data normalization mean?

897

---

What is tuple in sql?

1005

---

What are the various levels of constraints?

1059

---