Answer / suraj

select deptno,trunc(avg(sal))as avg from emp group by deptno;

Answer / naresh

select avg(sal) from emp group by deptno;

Which is fastest database?

0 Answers  

---

What is normalization? What are different type of normalization?

0 Answers  

---

what are the different integrity rules present in the dbms?

0 Answers  

---

How is data stored in a relational database?

0 Answers  

---

Define union all operator and union.

0 Answers  

---

---

With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?

0 Answers   eBay,

---

What are the limitations of using a model?

0 Answers  

---

Enlist various transaction phases.

0 Answers  

---

What is the difference between shrink database and shrink file?

0 Answers  

---

What is a database in layman terms?

0 Answers  

---

What are the differences between a dbms and rdbms?

0 Answers  

---

What do you mean by transparent dbms?

0 Answers  

---