Answer Posted / deva

Truncate is a DDL command and hence cant be rolled back
where as delete is DML command and thus can be rolled back
if not necessary.

Can we use pl sql in mysql?

509

---

What is an invalid partition table?

550

---

Explain ddl statements in pl/sql?

568

---

how to create a new view in mysql? : Sql dba

484

---

What are different types of sql?

547

---

---

What does trigger mean in slang?

511

---

what are the differences between require and include, include_once and require_once? : Sql dba

511

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

497

---

Explain select statements in sql?

575

---

What is cost in sql execution plan?

476

---

How is indexing done in search engines?

517

---

Is sql between inclusive?

578

---

How many disk partitions should I have?

536

---

What is the example of procedure?

504

---

How do you select unique values in sql?

494

---