최신 IBM Specialist 000-545 무료샘플문제:

1. Given the variable declaration shown below: DECLARE v_mydate DATE; Which statement will assign a value to the variable V_MYDATE?

A) VALUES CURRENT TIMESTAMP INTO v_mydate;
B) SELECT CURRENT DATE INTO v_mydate FROM SYSIBM.SYSDUMMY1;
C) VALUES (08262010) INTO v_mydate;
D) SELECT CURRENT TIMESTAMP INTO v_mydate FROM SYSIBM.SYSDUMMY1;

2. Given the two SQL procedures shown below:

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

A) NULL
B) 5
C) 7
D) 2

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

A) SESSION is the implicit schema name of the DGTT
B) The data in a DGTT cannot be compressed.
C) The DGTT must be stored in a system temporary table space
D) The value of the USER special register is the implicit schema name of the DGTT

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

A) A DIRECT ASSIGNMENT statement.
B) A VARIABLE VALUES statement.
C) A SELECT * statement, a VALUES * statement, or a FETCH * statement.
D) A SELECT INTO statement, a VALUES INTO statement, or a FETCH INTO statement.

5. The cursor BASEINFO was defined as follow:

Which statement would be used to create a local variable named BASEINFOROW that can be used to store results from the BASEINFO cursor?

A) CREATE VARIABLE baseinforow ASSOCIATED WITH baseinfo
B) DECLARE baseinforow ANCHOR ROW baseinfo
C) DECLARE ROW baseinforow ASSOCIATED WITH CURSOR baseinfo
D) DEFINE ROW baseinforow FOR CURSOR baseinfo

질문과 대답: