Question

1) In which clause of a query can a subquery not be used? (Choose two.)

2) The ORDER BY clause is allowed in an inline view true or false

3) the order by clause is not allowed in subqueries true or false

4) The operators IN and EXISTS are somewhat equivalent true or false

5) this Oracle error message? ORA-01427: single- row subquery returns more than one row >= = IN <=

6) SELECT 'TRUE' FROM dual WHERE 6 = ANY (6, 9); SELECT 'TRUE' FROM dual WHERE 6 IN (6, 9);

7) What is the result of the following query? SELECT 10 * ( SELECT 10 * (SELECT 10 * (SELECT COUNT(10 * 10 * 10) FROM dual) FROM dual) FROM dual) FROM dual); 8) What operator would you choose to prevent this Oracle error message? ORA-01427: single- row subquery returns more than one row

Answer 1

1. ORDER BY CLAUSE, HAVING CLAUSE

2. True

3. True

4. False

5. Yes, it is indeed an Oracle error message

6. SELECT 'TRUE' FROM dual WHERE 6 IN (6, 9);

7. Returns the number of sub records present in the last sub query

8. To resolve that error we must change query and try to use any of the following operator:

• ANY
• ALL
• IN
• NOT IN

Hope I answered the question.

If you have any doubts, or queries, feel free to ask

I'll respond to you as soon as I can.

Have a nice day