Answer Posted / anandkumar

DDL and DML Triggers

What is difference between rank () row_number () and dense_rank () in sql?

583

---

Why truncate is faster than delete?

567

---

Is ms sql is free?

534

---

Cite the differences between execution of triggers and stored procedures?

626

---

Why are indexes and views important to an organization?

529

---

---

Can function return multiple values in sql?

533

---

What is %type in sql?

522

---

What is range partitioning?

522

---

What is varray in pl sql?

568

---

what is the difference between char_length and length? : Sql dba

576

---

What is trigger point?

540

---

What is record in pl sql?

597

---

Which join condition can be specified using on clause?

517

---

What are the types of join in sql?

520

---

Are stored procedures compiled?

525

---