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.

Explain a database server?

1 Answers  

---

What is a stretch database?

1 Answers  

---

How to reorder the table columns (fields)?

1 Answers  

---

What does DLL stands for ?

2 Answers   Nexus Technologies,

---

What are the three levels of data abstraction?

1 Answers  

---

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

1 Answers  

---

What is a database in a website?

1 Answers  

---

what the REPLACE('JACK AND JUE','J','BL') will return ?

1 Answers   HCL, IBM, Wipro,

---

What is the benefit of database?

1 Answers  

---

What do you understand by join?

1 Answers  

---

What do you mean by fill factor concept with respect to indexes?

1 Answers  

---

What is a SQL * NET?

2 Answers  

---