IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 21:

  If the following SQL statements were executed in the order shown:

  

  What would be the values of RET_CODE1 and RET_CODE2 after executing the SIZEPRINTERprocedure?

  A. 100, 100
  B. 100 , 1
  C. 123, 123
  D. 100, 0
  B. 100 , 1

• Question 22:

  Which two statements are true about SQL procedures? (Choose 2)

  A. SQL procedures reside outside of the database for easy portability.
  B. SQL procedurescannot be called from triggers.
  C. SQL procedures may return multiple result sets to the caller or to a client application.
  D. SQL procedures support recursion.
  E. SQL procedures support the PRINT statement.
  C. SQL procedures may return multiple result sets to the caller or to a client application.
  D. SQL procedures support recursion.

• Question 23:

  Which code fragment illustrates the proper way to perform error checking in SQL stored procedures?

  A. ... IF EXCEPTION < 0 ELSE THEN; NULL; ENDIF; ...
  B. ... BEGIN EXCEPTION < 0 ELSE; NULL; END; ...
  C. ... IF SQLCODE < 0 THEN RETURN -6786; END IF; ...
  D. ... BEGIN IF SQLCODE
  C. ... IF SQLCODE < 0 THEN RETURN -6786; END IF; ...

• Question 24:

  Which tool can be used to get an Explain plan for all SQL statements used in a unit of work?

  A. db2look
  B. DB2 Command Center
  C. Data Studio
  D. db2exfmt
  D. db2exfmt

• Question 25:

  Which code fragment illustrates the proper way to capture and save SQL error handler values so they can be used to control procedure logic?

  A. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLCODE;
  B. DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = EXCEPTION;
  C. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;
  D. DECLARE ERROR HANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;
  A. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLCODE;

• Question 26:

  How is the FOR statement distinct from other conditional statements?

  A. FOR statements are evaluated at the completion of each iteration of the loop.
  B. FOR statements are evaluated before each iteration of the loop.
  C. FOR statements have a terminating condition clause.
  D. FOR statements are used to iterate over rows in a defined read-only result set.
  D. FOR statements are used to iterate over rows in a defined read-only result set.

• Question 27:

  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 exists, the execution order is 4,1,2,3.
  D. If the EMPLOYEE_TEMP table does not exist, the execution order is 4,1,3.
  E. If the messages table does not exist, the SQL procedure will still compile.
  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.

• Question 28:

  Given the following SQL:

  

  Which statement is incorrect?

  A. The procedure declarationrequires the DYNAMIC RESULT SETS 1 clause in order to return a result set.
  B. The cursor declaration requires the WITH RETURN TO CLIENT clause in order to return a result set.
  C. The cursor declaration requires the WITH RETURN TO CALLER clause in order toreturn a result set.
  D. The cursor declaration requires the WITH RETURN clause in order to return a result set.
  A. The procedure declarationrequires the DYNAMIC RESULT SETS 1 clause in order to return a result set.

• Question 29:

  Click the Exhibit button.

  

  Given the user-defined function shown in the exhibit, what will the function return if invoked using the statement shown below? SELECT check_id(1) FROMSYSIBM.SYSDUMMY1

  A. Error: ID 1 is not valid
  B. Application Error
  C. SQLSTATE 80000 will be returned, with the custom error message "Error: ID 1 is not valid"
  D. NULL
  D. NULL

• Question 30:

  Given the statement shown below:

  

  What happens toNEWPROD if 'http://posample.org/product.xsd' is dropped?

  A. NEWPROD will validate against a new schema.
  B. NEWPROD will raise an exception.
  C. NEWPROD is marked as inoperative.
  D. NEWPROD is dropped.
  C. NEWPROD is marked as inoperative.