Answer / Dawer Husain

SQL join types include INNER JOIN (joins only matching rows), LEFT JOIN (returns all rows from the left table and matching rows from the right table), RIGHT JOIN (returns all rows from the right table and matching rows from the left table), FULL OUTER JOIN (returns all rows when there is a match in either the left or right table), and CROSS JOIN (produces the Cartesian product of two tables). Oracle join syntax is similar, with minor differences. For example, Oracle uses NATURAL JOIN instead of SQL's INNER JOIN.

Explain different types of lock modes in sql server 2000?

1 Answers  

---

What is the function of sql server agent windows service?

1 Answers  

---

What are the types of subquery?

1 Answers  

---

What happens if null values are involved in boolean operations?

1 Answers  

---

How secure is sql server database?

1 Answers  

---

How to Get the last identity value used

4 Answers  

---

How to insert data with null values?

1 Answers  

---

What do you mean by an execution plan? How would you view it?

1 Answers  

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---

What are the five major components of a dbms?

1 Answers  

---

Difference between connected and disconnected database in .net with sql server?

1 Answers   Infosys,

---