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,

---

Mention the different types of triggers?

0 Answers  

---

Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,

---

What is dbcc updateusage?

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

What are the differences between having and where clause.

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---

Can we write a distributed query and get some data which is located on other server and oracle database?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

How to handle error or exception in sql?

0 Answers  

---

Explain what is the difference between a local and a global temporary table?

0 Answers  

---

What types of integrity are enforced by a foreign-key constraint

1 Answers  

---