Answer Posted / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

What is usually the first word in a sql query?

583

---

Define inner join in sql server joins?

522

---

How many types of objects are there?

490

---

How many types of triggers are there?

558

---

What is the use of @@spid?

563

---

---

What is the default fill factor value?

568

---

What is sql profiler. What are the default templates with it? : sql server database administration

507

---

How to connect a database with sql express.?

555

---

Why use “in” clause in sql server?

546

---

What is extent? Types of extents?

578

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

509

---

What is difference between drop truncate and delete?

534

---

What are the dmvs?

558

---

How to convert a numeric expression from one data type to another?

487

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

684

---