IBM C2090-545 Online Practice Questions and Exam Preparation

IBM C2090-545 Online Questions & Answers

• Question 81:

  Click the Exhibit button.

  

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

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

  A. NO EXTERNAL ACTION
  B. NOT FENCED
  C. NOT DETERMINISTIC
  D. STATIC DISPATCH
  C. NOT DETERMINISTIC

• Question 82:

  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 atype of a table column.
  D. The index data type for an associated array must be an integer.
  C. Associative array cannot be atype of a table column.

• Question 83:

  Given the following statements: In the above given procedure, the statement in which line is not valid?

  

  A. 1
  B. 7
  C. 9
  D. 10
  B. 7

• Question 84:

  Which steps must be followed to return a result set from an SQL procedure?

  A. 1. Create the procedure using the DYNAMIC RESULT SETS clause. 2.Declare the cursor. 3. Open the cursor in the SQL procedure. 4. Close the cursor. 5. Return to the application.
  B. 1. Create the procedure using the DYNAMIC RESULT SETS clause. 2. Declare the cursor using the WITH RETURN clause. 3. Open the cursor in the SQL procedure. 4. Return to the application.
  C. 1. Create the procedure using the WITH RETURN clause. 2. Declare the cursor using the DYNAMIC RESULT SETS clause. 3. Open the cursor in the SQL procedure. 4. Return to the application.
  D. 1. Create the procedure using the WITH RETURN clause. 2. Declare the cursor using the DYNAMIC RESULT SETS clause. 3. Open the cursor in the SQL procedure. 4. Close the cursor.
  B. 1. Create the procedure using the DYNAMIC RESULT SETS clause. 2. Declare the cursor using the WITH RETURN clause. 3. Open the cursor in the SQL procedure. 4. Return to the application.

• Question 85:

  Using Optimistic Locking, both Transaction1 and Transaction 2 have read the same row including the RID_BIT and ROW CHANGE TOKEN values. Transaction 1 updates the row after ensuring that the row has not changed after the previous SELECT by adding a RID_BIT and ROW CHANGE TOKEN predicate to the UPDATE statement. Transaction 2 now tries to update that same row using the same predicate as transaction 1.

  What will be the result?

  A. The row will be found with the same ROW CHANGE TOKEN. Transaction 2 will now insert its values replacing those of transaction 1.
  B. The row will be found with a different ROW CHANGE TOKEN and Transaction 2 will overwrite the values set in transaction 1.
  C. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 has to retry in order to retrieve the current data.
  D. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 will complete with an insert of a new row.
  C. The row will not be found because the value of the ROW CHANGE TOKEN has changed in regard to the UPDATE of transaction 1. Transaction 2 has to retry in order to retrieve the current data.

• Question 86:

  Given the SQL statement shown below: Which privilege allows a user to execute the CREATE TRIGGER statement shown?

  

  A. SYSCTRL authority
  B. SELECT and UPDATE privilege on the EMPLOYEE table
  C. SYSMAINTauthority
  D. SELECT and ALTER privilege on the EMPLOYEE table
  B. SELECT and UPDATE privilege on the EMPLOYEE table

• Question 87:

  Given the following procedures:

  

  What would be value of the variable TOTAL_SCORE if the PROCESS_SCORES procedure is called with the value 23 provided as input?

  B. 6B.6
  C. 23C.23
  D. 10D.10
  B. 6B.6

• Question 88:

  Given the SQL statement shown below:

  

  Which statement correctly describesthe cursor MY_CURSOR?

  A. The cursor does not have sensitivity to insert, update, or delete operations that are made to rows in the underlying result table.
  B. The cursor will not be closed as a consequence of a commit operation.
  C. The result table of the cursor is intended to be used as a result set that will be returned from a procedure.
  D. The cursor can be used to perform positioned delete operations.
  D. The cursor can be used to perform positioned delete operations.

• Question 89:

  Given the function shown below:

  

  Which statement will execute successfully?

  A. SELECT to_upper('Seize the day!')
  B. SELECT * FROM to_upper_fcn('Seize the day!')
  C. SELECT to_upper('Seize the day!') FROM SYSIBM.SYSDUMMY1;
  D. SELECT * FROM TABLE(to_upper_fcn('Seize the day!')) AS T
  C. SELECT to_upper('Seize the day!') FROM SYSIBM.SYSDUMMY1;

• Question 90:

  Which two statements are true when working with triggers? (Choose two.)

  A. Triggers can be used to enforce data integrity rules.
  B. Triggers can be used with both tables and views.
  C. Triggers can be altered.
  D. Triggers can be used on Materialized Query Tables.
  E. Triggers can be used on Created Temporary Tables.
  A. Triggers can be used to enforce data integrity rules.
  B. Triggers can be used with both tables and views.