Answer Posted / lakshminarayana reddy

used to retrieve desired data from more than 1 table we use
join.
joins types:- 1.Equi join
2.non-Equi join
3.outer join
4.Self join

what are the authentication modes in sql server? : Sql dba

535

---

What is a pl/sql block?

595

---

How many subqueries can be nested in a statement?

505

---

What is procedure and function in sql?

534

---

What are different joins used in sql?

556

---

---

What is cost in sql execution plan?

490

---

Why we use cross join?

543

---

What is a native sql query?

496

---

What is dense_rank?

540

---

What is primary key secondary key alternate key candidate key?

546

---

What is rowid in sql?

512

---

Is sql injection illegal?

597

---

What are different methods to trace the pl/sql code?

544

---

How to run sql statements with oracle sql developer?

625

---

Are dml statements autocommit?

554

---