IBM IBM Certified Solution Developer C2090-545 Questions & Answers

• Question 81:

  Which statement can be used to declare a variable inside an SQL procedure that can be used to represent a monetary value?

  A. DECLARE v_money MONEY;

  B. DECLARE v_money DOUBLE;

  C. DECLARE v_money DECIMAL(9,2);

  D. DECLARE v_money CURRENCY;

  Correct Answer: C

• Question 82:

  Which statement will successfully create an SQL procedure that returns the name of the current month?

  A. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; SET (today = CURRENT_DATE); SET month = MONTHNAME(today); END

  B. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; SELECT (CURRENT_DATE) INTO today; SET month = MONTHNAME(today); END

  C. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN DECLARE today DATE; VALUES (CURRENT_DATE) INTO today; SET month = MONTHNAME(today); END

  D. CREATE PROCEDURE proc.current_month(OUT month VARCHAR(20)) BEGIN SET month = MONTHNAME(SELECT (CURRENT_DATE)) END

  Correct Answer: C

• 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

  Correct Answer: B

• Question 84:

  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 HANDLERFOR SQLEXCEPTION, SQLWARNING, NOTFOUND 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 ERRORHANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;

  Correct Answer: A

• Question 85:

  Given the following script:

  

  What would be result from the SELECT * FROM audi1?

  A. NLEVEL MESSAGE 1 FROM TRIGGER

  B. NLEVEL MESSAGE 2 FROM TRIGGER

  C. NLEVEL MESSAGE 2 TEST1

  D. NLEVEL MESSAGE 5 FROM TRIGGER

  Correct Answer: B

• Question 86:

  What is correct use of the MODULE?

  A. Encryption and encapsulation

  B. Grouping object definitions together that has a common business purpose

  C. Improving performance of transactions

  D. Supporting referential integrity

  Correct Answer: B

• Question 87:

  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.

  Correct Answer: C

• Question 88:

  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.

  Correct Answer: C

• Question 89:

  Which of the following statements is true for declared global temporary tables?

  A. Declared global temporary table descriptions are stored in the system catalog

  B. When a session terminates, all declared global temporary tables created in the session are dropped.

  C. Declared global temporary tables are persistent and can be shared with multiple sessions.

  D. Declared temporary tables support LONG VARCHAR columns.

  Correct Answer: B

• Question 90:

  Which statement can be used to define an array of 30 names that have a maximum size of 25characters each?

  A. CREATE TYPE names AS VARCHAR(25) ARRAY[30];

  B. CREATE ARRAY names[30] VARCHAR(25);

  C. CREATE TYPE names[30] VARCHAR(25);

  D. CREATE ARRAY names AS VARCHAR(25);

  Correct Answer: A