Answer Posted / guruswamy

corelated query is refered by each an every value by
subquery.
normal query is referd by subquery one bulk amount to get a
main query

What is benefit of creating memory optimized table?

537

---

What is the non-clustered index in sql?

587

---

what are the features and advantages of object-oriented programming? : Sql dba

542

---

what are dynamic queries in t-sql? : Transact sql

557

---

How to get list of all tables from a database?

623

---

---

Can we rename a column in the output of sql query?

539

---

How can a pl sql block be executed?

528

---

Why do we use sqlite?

529

---

Why is pl sql used?

525

---

What is trigger and how to use it in sql?

536

---

Explain about various levels of constraint.

520

---

Why do we need pl sql?

548

---

What is the difference between a procedure and a function?

490

---

What is difference between inner join and self join?

588

---

what is sp_pkeys? : Transact sql

699

---