IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 71:

  Which two statements are true with regards to nesting SQL procedures? (Choose two.)

  A. An SQL procedure cannot invoke procedures built in other languages (e.g., C, Java).
  B. An SQL procedure can invoke the same SQL procedure more than once.
  C. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the READS SQL DATA clause.
  D. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the MODIFIES SQL DATA clause.
  E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause.
  B. An SQL procedure can invoke the same SQL procedure more than once.
  E. An SQL procedure defined with the CONTAINS SQL clause can invoke an SQL procedure defined with the NO SQL clause.

• Question 72:

  Which of the following steps are required to debug a stored procedure using IBM Data Studio?

  A. Deploy the stored procedure from the data development project, debug the stored procedure.
  B. Debug the stored procedure from the Data Source Explorer.
  C. Deploy the stored procedure from the data development project, choose option for debugging and then debug.
  D. Debug the stored procedure from the IBM Data Studio command line console.
  C. Deploy the stored procedure from the data development project, choose option for debugging and then debug.

• Question 73:

  Click the Exhibit button.

  

  A trigger was created as shown in the exhibit.

  The UPDATE statement shown below is executed. UPDATE dept SETsales_id = '300' WHERE sales_id = '200'

  How many row(s) are updated in the EMPLOYEE table?

  B. 1
  C. 2
  D. 3
  B. 1

• Question 74:

  Click the Exhibit button.

  

  If the procedure TEST1 shown in the exhibit is called with the value 'A00'specified for the SOMEID parameter, what is the expected return code?

  B. -1
  C. -2
  D. -3
  A

• Question 75:

  Given the procedure shown below:

  

  How many rows will be inserted in thetable?

  B. 1
  C. 2
  D. 3
  A

• Question 76:

  Click the Exhibit button.

  

  A user-defined function was created using the statement shown in theexhibit.

  Which additional option can be added to the CREATE FUNCTION statement to tell the optimizer that the function does not always return the same results for a given argument value?

  A. NO EXTERNAL ACTION
  B. NOT FENCED
  C. NOT DETERMINISTIC
  D. STATICDISPATCH
  C. NOT DETERMINISTIC

• Question 77:

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

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

• Question 78:

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

  

  A. 500
  B. 1000
  C. 5200
  D. 5500
  A. 500

• Question 79:

  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');
  A. IF (c1 = c2)THEN ?END;

• Question 80:

  Given that CREATEMODULE salesModule statement has been successfully executed, what is the correct method to manage this MODULE?

  A. REPLACE MODULE salesModule
  B. UPDATE salesModule MODULE FOR
  C. ALTER MODULE salesModule
  D. CREATE OR REPLACE selesModule UPDATE salesFunc
  C. ALTER MODULE salesModule