Answer Posted / rajan

full form is xp is eXperience and it is 100% right

What are indexes in sql?

580

---

Explain transaction server auto commit?

537

---

How to create hyperlink from returned sql query ?

627

---

What are number line correlation administrators will use while working with a subquery?

629

---

What is the difference between commit and rollback?

508

---

---

is there a column to which a default can't be bound? : Sql server database administration

541

---

What is use of except clause? How it differs from not in clause?

604

---

Explain different types of Normalization.

601

---

How to replace the Query Result 'Null Value' with a text ?

567

---

What are alternate keys?

576

---

Please differentiate between a local and a global temporary table?

573

---

Explain the difference between functions and stored procedures in sql server?

483

---

How to delete existing triggers using "drop trigger"?

560

---

Explain about thread and memory management process of SQL?

542

---

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

544

---