Multiple choice technology databases

select visible_parameter1 from kcrt_table_entries where request_id = '64457' and parameter_set_field_id = ( select parameter_set_field_id from kcrt_request_details reqd , knta_parameter_set_fields psf where reqd.request_id = '64457' and psf.parameter_set_context_id = reqd.parameter_set_context_id and psf.parameter_token = 'AXA_RM_RTF_TCRELDEM') and seq = '1' If the subselect returns more than one row. This query will run fine?

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The WHERE clause uses '=' (single row comparison operator) with a subquery that can return multiple rows. This causes Oracle error ORA-01427: single-row subquery returns more than one row. Should use IN or EXISTS instead.

Keep practicing — related questions