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 is database partitioning?

Mention the types of join?

describe and contrast a trigger and a procedure.

what is the difference between DBMS and RDBMS??

Describe the purposes and advantages stored procedure?

Explain by listing some major advantages of dbms.

What do you understand by query optimization?

How to determine who is and change the owner of database?

Describe the differences between vertical and horizontal portioning.

what are database files, control files and log files. How many of these files should a database have at least? Why?

What are foreign keys in database?

Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

For more Database Management Interview Questions Click Here