Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

What is the difference between the application object and session object?

0 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 types of indexes available with SQL Server?

2 Answers   Standard Bank,

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---

what are the critical issues you have resloved in your company

0 Answers   Wipro,

---

In what sequence sql statement is processed?

0 Answers  

---

Explain Capacity planning to create a database? and how to monitor it?

0 Answers  

---

what is a cursor and what is its use?

2 Answers   L&T,

---

what is diffence between replicaion and logshipping?

1 Answers  

---

What will happen if a column containing char type data is changed to the nchar data type?

0 Answers  

---

What is Transparent Data Encryption?

0 Answers  

---