AdAsia Communications interview questions

Bi Consulting questions one telephone interview, presentation and customer meet and a qualification tests . What is referential Integrity? 2. Display the names of the employees who earn highest salary in their respective departments. SQL> select ename,sal,deptno from emp e where sal in(select max(sal) from emp m where m.deptno = e.deptno); 3. Find out top 5 earners of company. SQL> select * from (select * from emp order by sal desc) where rownum <= 5; 4. Display the Employee name and Managers names. SQL> select e.ename employee, m.ename manager from emp e, emp m where m.empno=e.mgr;