Answer Posted / ameer mujahid

select rownum from employees;

What are the query optimization techniques?

538

---

How do you optimize a query?

540

---

What is the full form of sql?

539

---

Explain clause in sql?

564

---

what is the difference between a local and a global temporary table? : Sql dba

558

---

---

What are the advantages of indexing?

526

---

What is optimistic concurrency control? : Transact sql

553

---

Explain how exception handling is done in advance pl/sql?

561

---

What are the different type of joins in sql?

544

---

What are the ways on commenting in a pl/sql code?

514

---

Sql technical questions

779

---

How many types of cursors supported in pl/sql?

596

---

Explain alias in sql?

587

---

What is the max nvarchar size?

525

---

What is the difference between a procedure and a function?

495

---