Answer / Veerendra Kumar

Views can be used for data security by restricting user access to specific subsets of data, simplifying complex queries by encapsulating complex logic, improving performance through pre-computation and caching, enforcing business rules, and providing an easy way to update multiple tables at once.

What is the maximum row of a size?

1 Answers  

---

Which command executes the contents of a specified file?

2 Answers   ABC, InfoMedia,

---

How can you find out which stored procedures are recompiling?

1 Answers  

---

How to achieve Paging of records in SQL SERVER?

1 Answers   Petranics Solutions,

---

What is a transaction and what are ACID properties?

14 Answers   Config Systems, IBM, TCS, Virtusa,

---

How to create Clustered Primary Key to table?

2 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

Explain what is the use of custom fields in report?

1 Answers  

---

What are the operating modes in which database mirroring runs?

1 Answers  

---

What is the difference between grant and with grant while giving permissions to the user?

1 Answers  

---

How to download and install microsoft .net framework version 2.0?

1 Answers  

---

If no size is defined while creating the database, what size will the database have?

1 Answers  

---