Test Difficulty Level: Easy

Syllabus of Test

Multiple Table Queries - Equality and Non - Equality Joins, Cartesian Joins, Outer Joins, Self - Join, Using Set Operators. Subqueries - Single - Row and Multiple - Row Subqueries. NULL Values in Subqueries. Multiple - Column Subqueries. Subqueries in the FROM Clause.

Sample Question from this online test:

Question: Which line of code has an error ?

Option A: SELECT dname, ename

Option B: FROM emp e, dept d

Option C: WHERE emp.deptno = dept.deptno

Option D: ORDER BY 1, 2;

To answer, click the "Start This Test" button below.

Start this Test