Reynold has created a procedure for working with arrays. He has added the following script in the procedure and returning a table OUTPUT_TABLE with column names as ID and NAME. DECLARE ARR_CARID INTEGER ARRAY := ARRAY(101,102); DECLARE ARR_CARTYPE VARCHAR(50) ARRAY := ARRAY('Sedan','Luxury','Convertible'); OUTPUT_TABLE = UNNEST(:ARR_CARID,:ARR_CARTYPE) AS ("ID","NAME"); END; What will be the result when this procedure is executed?

UNNEST will convert the arrays into a table and values in the table will be 101 Sedan 102 Luxury ? Convertible
UNNEST will convert the arrays into a table and values in the table will be 101 Sedan 102 Luxury
UNNEST will convert the arrays into a table and values in the table will be 101 Sedan 102 Luxury 0 Convertible
UNNEST will convert the arrays into a table and values in the table will be 101 Luxury 102 Convertible
Correct Option - a

To get all Infosys Certified SAP HANA Basics 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.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in