Dept wise avrage salary

Question Posted / chinna

Answers were Sorted based on User's Feedback

Dept wise avrage salary..

Answer / suraj

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

Is This Answer Correct ?

6 Yes

0 No

Dept wise avrage salary..

Answer / naresh

select avg(sal) from emp group by deptno;

Is This Answer Correct ?

1 Yes

0 No

More Database Management Interview Questions

What are the four objects in a database?

What is the use of drop command and what are the differences between drop, truncate and delete commands?

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

What are the differences between drop, truncate and delete commands?

What are cursors and what are the situations you will use them?

What is relational database ? Give me an example !

What is the difference between a delete command and truncate command?

What is service based database?

Explain the difference between two and three-tier architectures.

What are the advantages of database software?

What are the main components of a database system?

What are the advantages and disadvantages of views in the database?

For more Database Management Interview Questions Click Here