Answer Posted / priyank

xp stands for Extended Procedure

How to provide login information for a new odbc dsn?

540

---

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

535

---

What is meant by indexing files?

584

---

What is the difference between ddl and dml?

572

---

Explain external key management in sql server 2008

504

---

---

What is the purpose of the tempdb database?

575

---

What is difference between drop truncate and delete?

558

---

How do you create type- insensitive operator?

572

---

What is an entity-relationship diagram (erd)?

592

---

Is it possible to call a stored procedure within a stored procedure?

558

---

What is transaction server explicit transaction?

546

---

How to create an inline table-valued function?

540

---

Explain an incremental backup?

596

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

544

---

What are the different types of locks in the database?

488

---