Answer / sudipta santra

Inline query :
select * from emp where empno=(select max(empno) from emp);

Co-Related sub query:

Select * from emp where dob> (select distinct dob where
deptno= 10);

Note: In the Inline subquery , The main query depends upon
the outcome value of the inline sub query which is in-lined
but in case of co-related sub query the main query and sub
query both run simultaneously then the check occurs.

Tell us about some Dot operator queries?

0 Answers   Atos Origin,

---

Explain the Normalized Relations?

0 Answers  

---

What is oracle block? Can two oracle blocks have the same address?

0 Answers  

---

Define truncate and delete commands?

0 Answers  

---

Does google have a database like access?

0 Answers  

---

What is system r?

0 Answers  

---

How many database systems are there?

0 Answers  

---

How to find the size of database?

0 Answers   MCN Solutions,

---

What are different cursor types in dbms?

0 Answers  

---

What are indexes? Mention the differences between the clustered and non-clustered index?

0 Answers  

---

What is difference between sql and rdbms?

0 Answers  

---

What is database management used for?

0 Answers  

---