SOLVED: In which scenario, below query will return an error message? SELECT * FROM EM ...

In which scenario, below query will return an error message? SELECT * FROM EMPLOYEES WHERE department = (SELECT department from employees where first_name = 'JANE';

When there are multiple records with first_name 'JANE'

It will never return an error

When there is no record with first_name='JANE'

When there is only one record with first_name 'JANE'

Verified Answer

Correct Option - a

To get all Infosys Certified Oracle PL/SQL Technical Consultant Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee