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.

What do you understand by aggregation and atomicity?

0 Answers  

---

What do you understand by proactive, retroactive and simultaneous update?

0 Answers  

---

What are its two major subsystems of r?

0 Answers  

---

What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?

0 Answers  

---

What do you understand by cursor? Mention the different types of cursor?

0 Answers  

---

What are fact tables and dimension tables ? What is dimensional modeling and star schema design

0 Answers  

---

What is a database in a website?

0 Answers  

---

What is foreign key in database?

0 Answers  

---

Enlist various types of interactions created by dbms?

0 Answers  

---

Is driver a software?

0 Answers  

---

What is the use of ROWS option in EXP command ?

1 Answers  

---

What are the disadvantages of a database?

0 Answers  

---