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

How many types of data are there?

What is super key in dbms?

how to pass values from one table to another by using Bulk collect?

Why is the use of dbms recommended?

Define database model.

What are the advantages of dbms?

What are the advantages of database system?

What are the different types of database keys?

What is a relation in dbms?

What are the elements of a database?

What is database management system(dbms) and why it is used?

Is this statement true or false? All databases must be in third normal form?

For more Database Management Interview Questions Click Here