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