Answer Posted / saurabh

When 1st main query is executed then the result of the main
query is used in teh where clause of subquery then this
type of subquery is called as co-related sub query.

What is primary key and foreign key?

534

---

Can a table contain multiple foreign key’s?

577

---

Can %notfound return null after a fetch?

593

---

What is rank function in sql?

534

---

What is optimistic concurrency control? : Transact sql

553

---

---

What packages(if any) has oracle provided for use by developers?

5038

---

which operator is used in query for pattern matching? : Sql dba

547

---

What is native sql query?

554

---

Can we use joins in subquery?

539

---

Explain the components of sql?

590

---

What is the execution plan in sql?

562

---

What does pl sql stand for?

658

---

What is the difference between drop and truncate commands?

491

---

What does the base_object_type column shows in the user.triggers data dictionary view?

576

---

Explain sql data types?

629

---