IBM IBM Certified Solution Developer C2090-545 Questions & Answers

• Question 91:

  In the code segment shown below:

  

  Which statement accurately describes the result?

  A. For activities whose description has not changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primarykey.

  B. For activities whose description has changed, update the description in the ARCHIVE table. For new activities, insert into the ARCHIVE table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.

  C. For activities whose descriptionhas changed, update the description in the ACTIVITY table. For new activities, insert into the ACTIVITIES table. The ARCHIVE and ACTIVITIES table both have ACTIVITY as a primary key.

  D. The statement will fail since MERGE is not a supported operator.

  Correct Answer: B

• Question 92:

  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.

  Correct Answer: B

• Question 93:

  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

  Correct Answer: B

• Question 94:

  In which type of table space must global temporary tables be created?

  A. REGULAR

  B. LONG

  C. SYSTEM TEMPORARY

  D. USER TEMPORARY

  Correct Answer: D

• Question 95:

  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.

  Correct Answer: BE

• Question 96:

  Which CREATE PROCEDURE statement option should be used if you plan on issuing a DECLARE GLOBAL TEMPORARY TABLE statement from within the SQL procedure body?

  A. CONTAINS SQL

  B. READS SQL DATA

  C. MODIFIES SQL DATA

  D. LANGUAGE SQL

  Correct Answer: C

• Question 97:

  Click on the Exhibit button.

  

  Referring to the exhibit, what is the OUT_PHONENUMBERS result set when the SQL procedure is invoked by the call statement shown below?

  CALLfind_customers(ARRAY[?16-305-3745?

  ?05-416-4565?

  ?16-305-3746?

  '905-414-4566'],

  ?16??)

  A. [?16-305-3745??05-416-4565? ?16-305-3746']

  B. [?16-305-3745??05-416-4565? ?16-305-3746? '905-414-4566']

  C. [?05-416-4565? '905-414-4566']

  D. [?16-305-3745? ?16-305-3746[?16-305-3745? ?16-305-3746?

  Correct Answer: D

• Question 98:

  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

  Correct Answer: A

• Question 99:

  Given the two SQL procedures shown below:

  

  What is the expected output if procedure S1 is invoked with the value 1provided for parameter V1?

  A. NULL

  B. 2

  C. 5

  D. 7

  Correct Answer: D

• Question 100:

  If this statement was used tocreate an SQL procedure named P_EXIT: What will the return status be?

  

  A. 10

  B. 20

  C. 99

  D. NULL

  Correct Answer: C