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

Explain raise_application_error.

1088

---

How to write pl sql program in mysql command prompt?

1089

---

Is sql injection illegal?

1017

---

what are the join types in tsql? : Transact sql

1064

---

What is dml and ddl?

951

---

How many times can we commit in a loop?

1014

---

Which is faster view or stored procedure?

942

---

What is record data type?

910

---

What is recursive join in sql?

1004

---

What is primary key secondary key alternate key candidate key?

1033

---

Why use truncate instead of delete?

1013

---

Do we need to rebuild index after truncate?

1031

---

Can we create foreign key without primary key?

983

---

What is the function that is used to transfer a pl/sql table log to a database table?

1008

---

Can we alter stored procedure?

985

---