KCRT_REQUEST_DETAILS Request_type_id Request_id Batch_No Visible_parameter41 Visible_parameter31 --------------- ----------- --------- ------------------- ------------------- 1 31300 1 Online (null) 1 31300 2 Batch (null) 1 31300 3 Manually (null) 2 31301 1 2010-03-17 11:55:00 99 2 31301 2 2009-11-09 14:00:00 55 2 31301 3 2010-05-27 11:55:00 789 3 31302 1 TCS ACCM1 3 31302 2 INFOSYS BAPP1 3 31302 3 CTS IT1 KCRT_REQUEST_TYPES Request_Type_Id Request_Type_Name --------------- ----------------- 1 AXA_RT_Application_Demand 2 AXA_RT_Application_Definition 3 AXA_RT_Support_Release Choose the update statement to update visible_parameter41 (Batch_No 3) by visible_parameter31 (Batch_No 2) for all the request_id in table KCRT_REQUEST_DETAILS whose request_type_name is ‘AXA_RT_Application_Demand’?

technology databases

  1. update KCRT_REQUEST_DETAILS reqd set reqd.visible_parameter41 = (select reqd1.visible_parameter31 from kcrt_request_details reqd1 where reqd1.batch_number= '2' and reqd1.request_id = reqd.request_id) where reqd.batch_number ='3' and reqd.request_id in (se

  2. Update KCRT_REQUEST_DETAILS set visible_parameter41 = (select visible_parameter31 from KCRT_REQUEST_DETAILS where batch_number =2) where request_type_id = (select request_type_id from KCRT_REQUEST_TYPES where request_type_name = ‘AXA_RT_Application_Demand

  3. Update KCRT_REQUEST_DETAILS set visible_parameter41 = (select visible_parameter31 from KCRT_REQUEST_DETAILS where batch_number =2) where batch_number = 3 and request_type_id = (select request_type_id from KCRT_REQUEST_TYPES where request_type_name = ‘AXA_

  4. Update KCRT_REQUEST_DETAILS set visible_parameter41 = (select visible_parameter31 from KCRT_REQUEST_DETAILS where batch_number =2 and and request_type_id = (select request_type_id from KCRT_REQUEST_TYPES where request_type_name = ‘AXA_RT_Application_Deman

Show answer
Correct Option: A

Find more quizzes: