IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 51:

  The CREATE OR REPLACE PROCEDURE statement is similar semantically to which of the following combined statements?

  A. DROP andCREATE PROCEDURE
  B. ALTER and CREATE PROCEDURE
  C. UPDATE and CREATE PROCEDURE
  D. DROP and ALTER PROCEDURE
  A. DROP andCREATE PROCEDURE

• Question 52:

  Which statement can be used to define variable that can beshared between procedures?

  A. DECLARE my_gl_var INTEGER DEFAULT 1
  B. CREATE OR REPLACE VARIABLE my_gl_var INTEGER
  C. DEFINE GLOBAL VARIABLE my_gl_var INTEGER
  D. CREATE GLOBAL VARIABLE my_gl_var
  B. CREATE OR REPLACE VARIABLE my_gl_var INTEGER

• Question 53:

  Which tool can be used to get quick static SQL Explain data from packages?

  A. db2expln
  B. db2exfmt
  C. Control Center
  D. DB2 command center
  A. db2expln

• Question 54:

  Which statement is true about the data types VARCHAR and VARCHAR2?

  A. The VARCHAR data type cannot be used with a database thathas been created in Oracle compatibility mode.
  B. The VARCHAR2 data type treats empty strings as null; the VARCHAR data type treats empty strings as not null with zero length.
  C. The VARCHAR2 data type length is limited to 2000 bytes; the VARCHAR data type length can be up to 32K.
  D. The VARCHAR2 data type cannot be used in a database that has not been created in Oracle compatibility mode.
  B. The VARCHAR2 data type treats empty strings as null; the VARCHAR data type treats empty strings as not null with zero length.

• Question 55:

  Click the Exhibit button.

  

  Which statement is true about the CASE statement shown in the exhibit?

  A. An employee with a rating of 1 receives a 10% salary increase.
  B. An employee with a rating of 3 receives no salary increase.
  C. An employee with a rating of 2 receives a 3%salary increase.
  D. All employees will receive at least a 5% salary increase.
  A. An employee with a rating of 1 receives a 10% salary increase.

• Question 56:

  Which procedure demonstrates the correct use of dynamic SQL?

  A. 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
  B. 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
  C. 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
  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 SETquantity_on_hand=? WHERE ?=?'; PREPARE v_stmt1 FROM v_dynSQL; EXECUTE v_stmt1 USING new_count, v_col_name, item_code; END
  A. 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

• Question 57:

  Given the variable declaration shown below: DECLARE v_mydate DATE; Which statement will assign a value to the variable V_MYDATE?

  A. VALUES (08262010) INTO v_mydate;
  B. VALUES CURRENT TIMESTAMP INTO v_mydate;
  C. SELECT CURRENTTIMESTAMP INTO v_mydate FROM SYSIBM.SYSDUMMY1;
  D. SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;
  D. SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;

• Question 58:

  Which statement is TRUE about associative arrays?

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

• Question 59:

  Which object is used to return a result set from an SQLprocedure?

  A. Temporary table
  B. Array
  C. Cursor
  D. Scratchpad
  C. Cursor

• Question 60:

  In the function shown below:

  

  Which statement can be used to invoke the function above?

  A. SELECT * FROM TABLE(fcn1('B01'))
  B. SELECT TABLE(fcn1('B01')) FROM SYSIBM.SYSDUMMY1
  C. SELECT * FROM fcn1('B01')
  D. SELECT fcn1('B01') FROM SYSIBM.SYSDUMMY1
  A. SELECT * FROM TABLE(fcn1('B01'))