INTERVIEW QUESTIONS: SUBQUERIES

7 programming challenges to help you master the fundamentals of DATABASE MANAGEMENT SYSTEM USING ORACLE.

1

What is a subquery in SQL?

Start Solving
2

What are the different types of subqueries?

Start Solving
3

What is the difference between a subquery and a join?

Start Solving
4

What is a single-row subquery?

Start Solving
5

What is a multi-row subquery?

Start Solving
6

EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

DEPT (DEPTNO, DNAME, LOC)

Display employees whose salary is greater than the average salary.

Start Solving
7

EMP (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

DEPT (DEPTNO, DNAME, LOC)

Display employees who earn more than employee ‘SMITH’.

Start Solving