[Free] 2018(Jan) Dumps4cert Examcollection IBM C2090-545 Dumps with VCE and PDF 11-20

By | February 1, 2018

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released C2090-545
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/C2090-545.html

DB2 9.7 SQL Procedure Developer

Question No: 11 – (Topic 2)

Which statement will create a scalar function named FCN1?

  1. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3)

  2. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

    ?CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

  3. CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3) ?CREATE SCALAR FUNCTION fcn1(v1 CHAR(3)) RETURNS ROW CONTAINING CHAR(3)

  4. CREATE FUNCTION fcn1(v1 CHAR(3)) RETURNS CHAR(3) ?CREATE FUNCTIONfcn1(v1 CHAR(3)) RETURNS CHAR(3)

Answer: D

Question No: 12 – (Topic 2)

Which statement is TRUE about associative arrays?

  1. Associative array values can be stored in table columns.

  2. The index values for an associative array must be a continuous set of integer values.

  3. Associative array cannot be a type of a table column.

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

Answer: C

Question No: 13 – (Topic 2)

Which of the following can be used to assign multiple values to a row data type variable?

  1. A SELECT * statement, a VALUES * statement, or a FETCH * statement.

  2. A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.

  3. A DIRECT ASSIGNMENT statement.

  4. D. A VARIABLE VALUES statement.

Answer: B

Question No: 14 – (Topic 2)

ION NO: 54

Which rule applies to the REFERENCING clause in a CREATE TRIGGER statement?

  1. The OLD correlation-name and the OLD TABLE identifier can be used if the trigger event is an INSERT operation.

  2. The scope of each correlation-name and identifierused is the entire trigger definition.

  3. The OLD TABLE or NEW TABLE identifiers can be defined in a BEFORE trigger.

  4. A NEW correlation-name can be specified more than once for a trigger.

Answer: B

Question No: 15 – (Topic 2)

Given the following code

Dumps4Cert 2018 PDF and VCE

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

  1. 0

  2. 10

  3. 3

  4. 8

Answer: B

Question No: 16 – (Topic 2)

Given the following DDL:

Dumps4Cert 2018 PDF and VCE

what will the SALARY be?

  1. salary * 1.03

  2. salary * 1.05

  3. salary * 1.10

  4. salary * 1.50

Answer: D

Question No: 17 – (Topic 2)

Given the function:

Dumps4Cert 2018 PDF and VCE

What is the output of the statement: VALUES LENGTH(fcn1(#39; one good day #39;))?

  1. #39;one good day#39;

  2. 12

  3. #39; one good day #39;

  4. 14

Answer: B

Question No: 18 – (Topic 2)

Which code fragment illustrates the proper way to perform error checking in SQL stored procedures?

A. … IF

EXCEPTION lt; 0 ELSE THEN; NULL;

ENDIF;

B. … BEGIN

EXCEPTION lt; 0 ELSE;

NULL; END;

C.

IF SQLCODE lt; 0 THEN RETURN -6786;

END IF;

D. … BEGIN

IF SQLCODE lt;0 THEN RETURN -6786

END;

Answer: C

Question No: 19 – (Topic 2)

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

  1. REPLACE MODULE salesModule

  2. UPDATE salesModule MODULE FOR

  3. ALTER MODULE salesModule

  4. CREATE OR REPLACE selesModule UPDATE salesFunc

Answer: C

Question No: 20 – (Topic 2)

Given the following statements in an SQL procedure:

Dumps4Cert 2018 PDF and VCE

Which of the following assignment statements is valid?

  1. SET c1 = VALUES (1, 2, 3);

  2. SET c1 = CURSOR FOR VALUES (1, 2, 3);

  3. c1 = CURSOR VALUES (1, 2, 3);

  4. SET VALUES (1, 2, 3)for CURSOR c1;

Answer: B

100% Dumps4cert Free Download!
Download Free Demo:C2090-545 Demo PDF
100% Dumps4cert Free Guaranteed!
C2090-545 Dumps

Dumps4cert ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.