Answer Posted / rr

delete command delete the rows from table record by record but truncate removes all the records is nothing but it drops the table and creates table structure as it is

Is sql a scripting language?

509

---

What is a trigger word?

510

---

explain the advantages and disadvantages of stored procedure? : Sql dba

529

---

what is union? : Sql dba

577

---

Explain dml and ddl?

541

---

---

How does sql developer connect to oracle database?

514

---

What is varchar sql?

610

---

Is it possible to read/write files to-and-from PL/SQL?

650

---

What is input buffer in sql*plus?

633

---

How many joins in sql?

543

---

Define select, insert, create, delete, update, drop keywords

593

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

610

---

Does sql view stored data?

528

---

what is the functionality of the function htmlentities? : Sql dba

517

---

How do rank () and dense_rank () differ?

514

---