AdAsia Communications IT Consultant Interview Questions | Glassdoor

Find jobs for IT Consultant

AdAsia Communications IT Consultant Interview Questions

Interviews at AdAsia Communications

1 Interview Review

Experience

Experience
100%
0%
0%

Getting an Interview

Getting an Interview
100%

Difficulty

0.0
Average

Difficulty

Hard
Average
Easy

Interviews for Top Jobs at AdAsia Communications

More

 

IT Consultant Interview

Anonymous Employee in Berlin (Germany)
Accepted Offer
Positive Experience

Application

I applied through other source. The process took 4+ weeks. I interviewed at AdAsia Communications (Berlin (Germany)) in September 2014.

Interview

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;

Negotiation

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;

Don't Miss Out On a Job You Love
Upload a resume to easily apply to jobs from anywhere. It's simple to set up.