Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released C2090-545
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/C2090-545.html

DB2 9.7 SQL Procedure Developer

Question No: 21 – (Topic 2)

Which statement is true about the NUMBER data type?

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

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

  3. 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.

  4. 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.

Answer: A

Question No: 22 – (Topic 2)

Which code fragment illustrates the proper way to capture and save SQL error handler values so they can be used to control procedure logic?

  1. DECLARE CONTINUE HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND

    SET retcode = SQLCODE;

  2. DECLARE ERROR HANDLER FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = EXCEPTION;

  3. DECLARE ERROR HANDLING SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLERRN;

  4. DECLARE ERROR HANDLING FOR SQLEXCEPTION, SQLWARNING, NOT FOUND SET retcode = SQLMSG;

Answer: A

Question No: 23 – (Topic 2)

What is the correct order for declarations in a compound statement defined by BEGIN and END?

  1. variable, cursor, handler, condition

  2. variable, condition, cursor, handler

  3. variable, condition, handler, cursor

  4. variable, cursor, condition, handler

Answer: B

Question No: 24 – (Topic 2)

Inthe given text below:

Ensurepass 2018 PDF and VCE

What will be the value of the output variable BONUS?

A. 500

B. 1000

C. 5200

D. 5500

Answer: A

Question No: 25 – (Topic 2)

Given the procedure shown below:

Ensurepass 2018 PDF and VCE

How many rows will be inserted in thetable?

  1. 0

  2. 1

  3. 2

  4. 3

Answer: A

Question No: 26 – (Topic 2)

Click the Exhibit button.

Ensurepass 2018 PDF and VCE

How many rows will be in table INFO2 after the procedure MOVE_DATA shown in the exhibit is executed?

  1. 0

  2. 4

  3. 5

  4. 7

Answer: B

Question No: 27 – (Topic 2)

Which of the following statement isTRUE about a REPEAT loop?

  1. The condition is checked at the end of the loop.

  2. The condition is checked at the beginning of the loop.

  3. A REPEAT loop behaves like a WHILE loop.

  4. A REPEAT loop behaves like a FOR loop.

Answer: A

Question No: 28 – (Topic 2)

Which command can be used to optimize static SQL statements containing parameterized queries?

  1. SET CURRENT EXPLAINMODE=REOPT

  2. SET CURRENT EXPLAIN MODE=EXPLAIN

  3. SET CURRENT EXPLAIN MODE=YES

  4. SET CURRENT EXPLAIN MODE=PARAM

Answer: A

Question No: 29 – (Topic 2)

Which two statements are true? (Choose two.)

  1. SQL procedures can contain static and/or dynamic SQL statements.

  2. Static or dynamic SQL execution is not associated with a package.

  3. The SQL procedure isalways associated with a package that contains access paths of

    SQL statements in the procedure.

  4. It is necessary for an end-user to have object level privileges if that user has execute privileges on an associated package and the SQL procedure.

  5. SQL procedures can have COMMIT or ROLLBACK within atomic compound statements.

Answer: A,C

Question No: 30 – (Topic 2)

Which declaration is not valid?

  1. DECLARE var1 DECIMAL(9,2);

  2. DECLARE var1 VARCHAR(20);

  3. DECLARE var1 CHAR;

  4. DECLARE var1 INTEGER DEFAULT;

Answer: D

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

EnsurePass 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

Your email address will not be published. Required fields are marked *

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