Answer Posted / vikash kr pandey

view is a virtual table , which provides to a subset of columns from one or more tables. in which doesn't have its own data.
yes view is updatbable in a single update statement

What is difference between inner join and full join?

1040

---

What is filtered index?

1075

---

how many layers of tcp/ip protocol combined of? : Sql server database administration

980

---

Explain the rules for designing files and file groups in sql server?

965

---

Explain what is the difference between a local and a global temporary table?

979

---

Explain about protocol layer present in SQL server?

1172

---

What are the new features of sql server 2012 reporting service?

131

---

Explain sql server service broker?

954

---

What is mapping schema?

1010

---

how many clustered indexes can be created on a table? : Sql server database administration

1127

---

What is a hint?

971

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1033

---

What are the differences between decimal and float in ms sql server?

1206

---

Write a code to select distinct records without using the DISTINCT keyword.

1095

---

What are dml (data manipulation language) statements in ms sql server?

962

---