Joins And Subqueries - Online Test

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






Comments

Anu Desale on 2011-02-25 08:36:24 wrote,

cannot see any question in q.no 20.. only radio buttons are visible
:( :( so sad............

vinoth selvaraj on 2011-05-05 23:01:44 wrote,

good work

amit kharkia on 2011-07-19 04:47:04 wrote,

no table was provided in the qstn 9.

supriya b on 2011-09-30 07:25:44 wrote,

its not easy:(:(:( very difficult

supriya b on 2011-09-30 07:25:51 wrote,

its not easy:(:(:( very difficult

supriya b on 2011-09-30 07:25:53 wrote,

its not easy:(:(:( very difficult

Reddi Prasad on 2012-04-09 09:18:41 wrote,

difficult

Ram Manoj Reddy Bala on 2012-06-26 04:30:16 wrote,

Question No 9 doesn't have the tables..

Ram Manoj Reddy Bala on 2012-06-26 04:31:10 wrote,

No options for Q20..

Sandeep Kumar on 2013-05-15 03:29:22 wrote,

There is not question no 20. As there is no back button so it is not possible to refer to previous page tables, when question related to referring tables are asked. E.g of such case of question 9.

Thanks for uploading the test questions. Can you please upload more and may be related to Application Performance Tunning.

Thanks
Tinku

yashika GUGLANI on 2013-06-17 11:30:35 wrote,

no table was provided and cannot see ques no 20

vishnu viru on 2013-08-19 06:19:46 wrote,

what about q 9 tables and q 20????