Answer Posted / amedela chandra sekhar

Truncate Delete
1)it is DDl command it is DML command
2)it delete records permanently it delete records temporarly
we can't roll back we can roll back the data

How do I sort a table in sql?

599

---

how to shutdown mysql server? : Sql dba

568

---

What is error ora-01000: maximum open cursors exceeded

604

---

What is a sql schema used for?

546

---

Can you sum a count in sql?

559

---

---

What is a design view?

522

---

How to check if a column is nullable before setting to nullable?

584

---

Why stored procedure is better than query?

511

---

Can procedure in package be overloaded?

612

---

Name some usages of database trigger?

564

---

What is view explain with example?

519

---

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

524

---

What is the best sql course?

534

---

Is pl sql a scripting language?

592

---

What is difference between hql and sql?

509

---