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 sql ddl commands?

734

---

What are tuples in sql?

771

---

Can we use insert statement in function?

734

---

What is a behavioral trigger?

689

---

What is string join?

745

---

---

Is join same as left join?

750

---

What is the maximum database size for sql express?

709

---

Is sql difficult?

920

---

Which is better varchar or nvarchar?

729

---

Explain the difference between sql and mysql.

752

---

How do you change a value in sql?

738

---

Does a primary key have to be a number?

683

---

What are the advantages of normalization?

784

---

What will you get by the cursor attribute sql%found?

700

---

Which are the different types of indexes in sql?

746

---