Answer / Virendra Pal

{"shared_locks": "Shared locks are used when multiple transactions need to read the same data concurrently. They allow other transactions to also read the data, but prevent them from modifying it until the current transaction has finished reading."

What is difference between inner join and full join?

1 Answers  

---

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

1 Answers  

---

What are the different types of triggers in SQL SERVER?

1 Answers  

---

Tell me what is a linked server?

1 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

1 Answers   Informatica,

---

System variable and temporary variables

1 Answers   Wipro,

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1 Answers  

---

Write a sql query to sort on different column name according to the parameters passed in the function?

1 Answers  

---

What do you mean by stored techniques? How would we use it?

1 Answers  

---

Define Check points and End Points?

1 Answers  

---

How to create new table with "create table" statements?

1 Answers  

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---