IBM IBM Certified Solution Developer C2090-545 Questions & Answers

• Question 71:

  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.

  Correct Answer: A

• Question 72:

  Click the Exhibit button.

  

  The procedure TEST5 shown in the exhibit was invoked. How many rows will be added to the DEPT table?

  A. 1

  B. 2

  C. 3

  D. 4

  Correct Answer: C

• Question 73:

  Assuming C1 and C2 are cursor type variables, which of the following operations cannot be performed?

  A. IF (c1 = c2)THEN ?END;

  B. SET c2 = c1;

  C. SET c1 = CURSOR FOR SELECT * FROM t;

  D. SET c1 = CURSOR FOR VALUES ('a', 'b', 'c');

  Correct Answer: A

• Question 74:

  The cursor BASEINFO was defined as follow:

  

  Which statement would be used to create a local variable named BASEINFOROW that can be used to store results from the BASEINFO cursor?

  A. DEFINE ROW baseinforow FOR CURSOR baseinfo

  B. DECLARE ROW baseinforow ASSOCIATED WITH CURSOR baseinfo

  C. DECLARE baseinforow ANCHOR ROW baseinfo

  D. CREATE VARIABLE baseinforow ASSOCIATED WITH baseinfo

  Correct Answer: C

• Question 75:

  Assuming EMP_ROW and NEW_HIRE have the same user-defined row data type, what is the best way to assign the elements of NEW_HIRE to EMP_ROW?

  A. emp_row.rowid = new_hire.rowid;

  B. emp_row.all = new_hire.all;

  C. SET emp_row = new_hire;

  D. SET emp_row.* = new_hire.*;

  Correct Answer: C

• Question 76:

  In thegiven text below: What will be the value of the output variable BONUS?

  

  A. 500

  B. 1000

  C. 5200

  D. 5500

  Correct Answer: A

• Question 77:

  Which of the following statements is true?

  A. A DATETIME value can be assigned to a DATE variable.

  B. Values cannot beassigned to variables inside ERROR HANDLERS.

  C. A TIMESTAMP value can be assigned to a TIME variable.

  D. The result of a GET DIAGNOSTICS statement cannot be assigned to a variable.

  Correct Answer: C

• Question 78:

  What values are generated each time an SQL statement is executed?

  A. SQLERRN and SQLMSG

  B. SQLSTATE and EXCEPTION

  C. EXCEPTION and SQLCODE

  D. SQLSTATE and SQLCODE

  Correct Answer: D

• Question 79:

  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;

  Correct Answer: D

• Question 80:

  If table TAB1 were created as follows:CREATE TABLE tab1 (col1 INT NOT NULL); Which statement illustrates the proper way to define an anchor variable that references column COL1 in table TAB1?

  A. DECLARE var1 REFERENCES tab1.col1

  B. DECLARE var1 tab1.col1%TYPE

  C. DECLARE var1 ANCHOR DATA TYPETO tab1.col1

  D. DECLARE var1 ANCHOR DATA TYPE TO tab1.col1%TYPE

  Correct Answer: C