Answer Posted / aravinda

query: query is single time validation of conditions for
entire result once result is fetched there no further
validation of records.

corelated sub query : each record is validated with inner
query aftr fetch.

1) outer query will execute first and pass a value to inner
query.
2) based on outer query value inner query will execute.
3) based on inner query value the outer query record will be
validated.

inner query will execute for every record of outer query( if
outer query has 10 records inner query will execute 10 times)

What are the types of variable use in pl sql?

1010

---

How many tables can a sql database have?

925

---

What is cross join sql?

866

---

does sql support programming? : Sql dba

990

---

Is it possible to link two groups inside a cross products after the cross products group has been created?

953

---

How many sql databases can you have on one server?

1016

---

what is query cache in mysql? : Sql dba

991

---

What are the different dml commands in sql?

1085

---

What is the difference between clustered and non-clustered indexes?

1026

---

what is the difference between delete and truncate statement in sql? : Sql dba

1127

---

What is the advantage of nosql?

994

---

What is a Mapplet?

1057

---

What is the starting oracle error number?

996

---

Difference between truncate, delete and drop commands?

1023

---

How to get list of all tables from a database?

1107

---