Answer Posted / test

select datename(month,getdate())

How to use linked server?

1191

---

What is the difference between clustered and non-clustered indexes in ms sql server?

1001

---

What is co-related sub query?

1021

---

Is it possible to update the views? If yes, how, if not, why?

1029

---

how many type of indexing in database?

979

---

Do you know what is xpath?

1083

---

How to how to convert numeric expression data types using the convert() function??

1048

---

how many bits ip address consist of? : Sql server database administration

898

---

Explain the various types of concurrency problem?

1190

---

What are the elements of dbms?

961

---

what's the maximum size of a row? : Sql server database administration

1080

---

What is data source view or dsv? : sql server analysis services, ssas

1000

---

Explain what is row_number function?

1029

---

Is there any difference between the primary key and unique key?

999

---

What is sparse columns of sql server 2008?

1052

---