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 Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Important Links

Privacy Policy

Refund Policy

Terms & Conditions

About Us

Contact Us