1Z0-051 - ORACLE Database 11g: SQL Fundamentals I Consider this statement: select last_name, (select count(*) from departments) from employees where salary = (select salary from employees); What is wrong with it? (Choose the best answer.) A- The statement will fail because the subquery in the SELECT list references a table that is not listed in the FROM clause. B- Nothing is wrong-the statement should run without error. C- The statement will fail if the second query returns more than one row. D- The statement will run but is extremely inefficient because of the need to run the second subquery once for every row in EMPLOYEES. iheadgo/Provas.aspx?ling=2&id_prova=24&idperg=9094
Posted on: Thu, 22 Jan 2015 02:09:37 +0000
Trending Topics
Recently Viewed Topics
© 2015