Answer / Sanjay Rathour

A view is a virtual table based on the result-set of an SQL statement. It does not store data itself but provides a simplified and secured way to query data from one or more tables. A view can be used to restrict access to specific columns, hide sensitive data, improve readability, and simplify complex queries. Views cannot be directly inserted, updated, or deleted because they do not contain actual data. However, you can perform these operations on the base table(s) underlying the view.

What are different types of schemas?

1 Answers  

---

How do you create a clustered index?

1 Answers  

---

Do you know the cursor types?

1 Answers  

---

What is row by row processing ?

2 Answers  

---

Can you explain full-text query in sql server?

1 Answers  

---

What is system stored procedures?

1 Answers  

---

Tell me about normalization in DBMS.

1 Answers   Honeywell, Zomato,

---

Explain what is analysis service repository?

1 Answers  

---

What is a covered index?

1 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

2 Answers   ADP,

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1 Answers  

---