Answer Posted / debi

1.when we use delete command then the records from the
table is not deleted permanently so that when we further
use rollback command the records are again available in the
table but in case of truncate the data is permenently
deleted from the table.
2.in case of truncate data deletion is faster as compared
to delete
3.
we can't use ant where condition in case if truncate

Can we call dml statement in function?

1061

---

Is nosql relational?

947

---

Is sql a programming?

978

---

Does pdo prevent sql injection?

935

---

Can we perform dml on view?

1047

---

What are different types of tables in sql?

999

---

Explain unique key in sql.

1017

---

What is pl/sql language case sensitive?

1131

---

What are the different dcl commands in sql?

1177

---

Mention what does plv msg allows you to do?

1124

---

What is a primary key example?

965

---

Differentiate between % rowtype and type record.

1311

---

what is a trigger? : Sql dba

1033

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1060

---

How can I change database name in sql?

1087

---