Answer / Meenakshi

The Master database is essential for the proper functioning of an SQL Server instance as it stores system-level metadata and provides a consistent view of the server's objects.

Do you know what are the restrictions that views have to follow?

1 Answers  

---

Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

1 Answers  

---

What are examples of triggers?

1 Answers  

---

define and explain the differences between clustered and non-clustered indexes.

1 Answers   Microsoft,

---

How to get a list of columns in a view using "sys.columns" in ms sql server?

1 Answers  

---

How to find the date and time of last updated table?

6 Answers   Teledata,

---

What is PROJECTION Operation?

1 Answers   Infosys,

---

can we give the identity for existing column of the table? (already table contains 10(1-10) unique randam records)

2 Answers  

---

What is the maximum size of a dimension? : sql server analysis services, ssas

1 Answers  

---

Mention the different types of triggers?

1 Answers  

---

How do I find my localdb version?

1 Answers  

---

How do you create a clustered index?

1 Answers  

---