Answer Posted / 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.

How many types of database language exist?

972

---

What is the purpose of normalization in dbms?

1086

---

Explain the use of assign statement in progress database?

862

---

What is service based database?

843

---

What are the three main types of models?

854

---

Can videos be stored in a database?

896

---

Is access a database program?

834

---

I have a table which has lot of inserts, is it a good database design to create indexes on that table?

841

---

What are the advantages of dbms?

886

---

Enlist the advantages of dbms.

915

---

What is system catalog or catalog relation?

1014

---

How do we select distinct values from a table?

876

---

What are the parts of a table?

917

---

What is database or database management systems (dbms)?

900

---

What's the best database software for mac?

873

---