> > >

Oracle 12c Admin MCQs

Find the error in the following query. if the Students table contains several records.

select name from students where name = (select name from students order by name);

= should be replaced with an in operator

The order by clause in the subquery should be preceded by a group by clause

The order by clause in the subquery can be used only if the where and group by clauses have been applied

Group by clause should be applied tthe outer query

An order by clause is not allowed in a subquery

Answer

Correct Answer: Group by clause should be applied tthe outer query

Explanation:

Note: This question has more than 1 correct answers

Note: This Question is unanswered, help us to find answer for this one

Oracle 12c Admin Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it