Answer Posted / swapnareddy

Main Differences between Truncate and Delete:
Truncate:
1:Truncate removes all records but using this we cannot
remove a particular record.
2:Truncate is ddl command(data definiton language command)
3:Rollback cannot be done when we use this command.
4:Truncate cannot fire a trigger.
Delete:
1:delete can remove all records or a particular record.
2:delete is a dml command(data manipulation language command)
3:rollback is possible when we use this command.
4:delete can fire a trigger

What is the advantage of index in sql?

972

---

Define implicit and explicit cursors.

1144

---

Is delete faster than truncate?

1002

---

What are the set operators in sql?

1072

---

What is an emotional trigger?

1005

---

what is the syntax used for partition in tsql? : Transact sql

1014

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

---

State few characteristics of pl/sql?

971

---

What is t sql used for?

1014

---

What are properties of the transaction?

998

---

Does a join table need a primary key?

954

---

What are instead of triggers?

1046

---

What is the difference between microsoft access and sql?

1024

---

What is the difference between distinct and unique in sql?

950

---

Is oracle and sql same?

1013

---