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 is cold backup and hot backup (in case of oracle)?

0 Answers  

---

Who proposed the relational model?

0 Answers  

---

What is database url?

0 Answers  

---

What is cursor and where do you use them?

2 Answers   eBay,

---

How easy is netlib to use?

0 Answers  

---

---

What is database management system explain?

0 Answers  

---

how to solve cardinality in dbms...many to many ralationships

0 Answers  

---

difference between generalisation,specialisation and aggregation? with examples.

0 Answers  

---

Write a note on File based system/ Data base system

2 Answers  

---

Describe two phases of Two-phase commit ?

2 Answers  

---

What is data modelling techniques?

0 Answers  

---

Is it possible to Disable the Parameter form while running the report ?

1 Answers  

---