Answer Posted / shakila

Ya it's right

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

587

---

Do you know the isolation level that sql server support?

519

---

What is the default port for SQL Server over a firewall?

581

---

Tell me what is difference between clustered and non clustered index?

552

---

How sql server enhances scalability of the database system?

579

---

---

Are resultset updatable?

520

---

What is inline table-value user-defined function?

578

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

498

---

What is truncate table?

544

---

Explain triggers?

550

---

How to create dbo table in sql server?

504

---

How many databases Microsoft SQL server provides?

600

---

How will you go about resolving deadlocks?

536

---

Which is the main third-party tool used in sql server?

470

---

How does clustered and non clustered index work?

509

---