Click the Exhibit button.

Referring to the exhibit, which two statements are correct? (Choose two.)

• A. If the EMPLOYEE_TEMP table exists, the execution order is 1,2,3.
• B. If the EMPLOYEE_TEMP table does not exist, the execution order is 1,4,3.
• C. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.
• D. If the messages table does not exist, the SQL procedure will still compile.
• E. If the EMPLOYEE_TEMP table exists, the execution order is 4,1,2,3.

Which action is supported by Data Studio in the SQL procedure lifecycle?

• A. Use auto complete SQL statements.
• B. Create global temporary tables to use in the SQL procedure.
• C. Debug the SQL procedure.
• D. Create user-define types in the SQL procedure.

Which statement is TRUE about associative arrays?

• A. Associative array values can be stored in table columns.
• B. The index data type for an associated array must be an integer.
• C. Associative array cannot be a type of a table column.
• D. The index values for an associative array must be a continuous set of integer values.

Which procedure demonstrates the correct use of dynamic SQL?

• A. CREATE PROCEDURE update_count2 (IN tab_name VARCHAR(128), IN new_count
  INTEGER, IN item_code INTEGER)
  BEGIN
  DECLARE v_dynSQL VARCHAR(200);
  SET v_dynSQL = 'UPDATE ? SET quantity_on_hand=? WHERE item_number=?';
  PREPARE v_stmt1 FROM v_dynSQL;
  EXECUTE v_stmt1 USING tab_name, new_count, item_code;
  END
• B. CREATE PROCEDURE update_count4 (IN tab_name VARCHAR(128), IN col_name1
  VARCHAR(128), IN col_name2 VARCHAR(128), IN
  new_count INTEGER, IN item_code INTEGER)
  BEGIN
  DECLARE v_dynSQL VARCHAR(200);
  SET v_dynSQL = 'UPDATE ? SET ?=? WHERE ?=?';
  PREPARE v_stmt1 FROM v_dynSQL;
  EXECUTE v_stmt1 USING tab_name, col_name1, new_count, col_name2, item_code;
  END
• C. CREATE PROCEDURE update_count1 (IN new_count INTEGER, IN item_code INTEGER)
  BEGIN
  DECLARE v_dynSQL VARCHAR(200);
  SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=? WHERE item_number=?';
  PREPARE v_stmt1 FROM v_dynSQL;
  EXECUTE v_stmt1 USING new_count, item_code;
  END
• D. CREATE PROCEDURE update_count5 (IN new_count INTEGER, IN item_code INTEGER)
  BEGIN
  DECLARE v_dynSQL VARCHAR(200);
  DECLARE v_col_name VARCHAR(128);
  SET v_col_name = 'item_number';
  SET v_dynSQL = 'UPDATE stock SET quantity_on_hand=? WHERE ?=?';
  PREPARE v_stmt1 FROM v_dynSQL;
  EXECUTE v_stmt1 USING new_count, v_col_name, item_code;
  END