Answer / Sri Ram Yadav

Policy management in SQL Server refers to the process of defining and enforcing database-related rules and best practices. Policies can cover various aspects such as data security, auditing, maintenance, and performance tuning. Examples include database mail policies, encryption policies, and change data capture (CDC) policies.

Describe in brief databases and sql server databases architecture.

1 Answers  

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

How do you troubleshoot SQL Server if its running very slow?

2 Answers   HP,

---

Explain ranking functions?

1 Answers  

---

Distinguish between commit and rollback?

1 Answers  

---

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

1 Answers  

---

How to Insert multiple rows with a single insert statement?

1 Answers  

---

difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

3 Answers   Intel, Wipro,

---

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1 Answers  

---

How to use user defined functions in expressions?

1 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

1 Answers  

---

What is the difference between commit and rollback?

1 Answers  

---