IBM IBM Certified Solution Developer C2090-545 Questions & Answers

• Question 21:

  Given the following code

  

  What would be value of parm2 if the following proc1 called as call proc1(3, ?)?

  A. 0

  B. 10

  C. 3

  D. 8

  Correct Answer: B

• Question 22:

  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 a type of a table column.

  D. The index data type for an associated array must be an integer.

  Correct Answer: C

• Question 23:

  Which statement is true about the NUMBER data type?

  A. In DB2, theNUMBER data type has maximum precision of 31; in Oracle, it has a maximum precision of 38.

  B. In DB2, the NUMBER data type is the same as in Oracle, provided the DB2 database was created in Oracle compatibility mode.

  C. Declaring a column as NUMBER(10,-2)is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.

  D. Declaring a column as NUMBER(6,8) is valid both in Oracle and in DB2 provided the DB2 database was created in Oracle compatibility mode.

  Correct Answer: A

• Question 24:

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

  A. The value of the USER special register is the implicit schema name of the DGTT

  B. B. The DGTT must be stored in a system temporary table space

  C. SESSION is the implicit schema name of the DGTT

  D. The data in a DGTT cannot be compressed.

  Correct Answer: C

• Question 25:

  If the following SQL statements were executed in the order shown:

  

  What would be the values of RET_CODE1 and RET_CODE2 after executing the SIZEPRINTERprocedure?

  A. 100, 100

  B. 100 , 1

  C. 123, 123

  D. 100, 0

  Correct Answer: B

• Question 26:

  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 primary key.

  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 tableboth have ACTIVITY as a primary key.

  C. For activities whose description has 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 27:

  Which tool can be used to get quick static SQL Explain data from packages?

  A. db2expln

  B. db2exfmt

  C. Control Center

  D. DB2 command center

  Correct Answer: A

• Question 28:

  Which two DB2 commands can be performed using the ADMIN_CMD procedure? (Choose two.)

  A. RUNSTATS

  B. BACKUP

  C. RESTORE

  D. RECOVER

  E. CREATE DATABASE

  Correct Answer: AB

• Question 29:

  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

  Correct Answer: C

• Question 30:

  Which two types of storedprocedures can be developed in IBM Data Studio? (Choose two.)

  A. SQL

  B. PHP

  C. PL/SQL

  D. Perl

  E. Ruby

  Correct Answer: AC