Free IBM A2090-543 Practice Test & Real Exam Questions
Which CLI/ODBC function would be used to update multiple rows in a table?
Correct Answer: A
Vote an answer
You have created a stored procedure (MULTIRESULTS()) on the server which will return multiple
result sets. Whiledeveloping a PHP application using the IBM_DB2 extension, you want to call the
stored procedure. The code shown below will execute the stored procedure:
$stmt = db2_exec($conn, 'CALL multiResults()');
How can you fetch all of the result sets from $stmt?
result sets. Whiledeveloping a PHP application using the IBM_DB2 extension, you want to call the
stored procedure. The code shown below will execute the stored procedure:
$stmt = db2_exec($conn, 'CALL multiResults()');
How can you fetch all of the result sets from $stmt?
Correct Answer: C
Vote an answer
Given the two tables shown below: TAB1 LETTER GRADE A 80 B 70 C 60 TAB2 LETTER GPA A 4 C 2 D 1 and the successful execution of the following query: SELECT * FROM tab1 FULL OUTER JOIN tab2 ON tab1.letter = tab2.letter; How many rows will be returned?
Correct Answer: B
Vote an answer
Which statement(s) will create and bind the package for the program myprogram.sqc?
Correct Answer: B
Vote an answer
Click the Exhibit button. CREATE FUNCTION deptemployees (idept VARCHAR(3)) RETURNS TABLE (empno CHAR(6), firstnameVARCHAR(12), lastnameVARCHAR(15)) LANGUAGE SQL READS SQL DATA NO EXTERNAL ACTION DETERMINISTIC RETURN SELECT empno, firstnme, lastname FROM employee WHERE workdept = deptemployees.idept; Referring to the exhibit, what contains the proper way to invoke the DEPTEMPLOYEES() user-defined function to return all of the employees that work in department D11?
Correct Answer: D
Vote an answer
Which two statements are true regarding performing batch updates in JDBC? (Choose two.)
Correct Answer: B,C
Vote an answer
What is the final result of executing the statements shown below?
CREATE SEQUENCE order_seq
START WITH 100
INCREMENT BY 25
MAXVALUE 150
CYCLE;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
CREATE SEQUENCE order_seq
START WITH 100
INCREMENT BY 25
MAXVALUE 150
CYCLE;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
VALUES NEXT VALUE FOR order_seq;
Correct Answer: C
Vote an answer
.You have set your data types as CHAR(10), VARCHAR(20). Given the operation shown below: CHAR(10) UNION VARCHAR(20)What will be the final data type?
Correct Answer: A
Vote an answer
Which standard is used for XML document validation in DB2?
Correct Answer: C
Vote an answer
An application uses the statement shown below to give employees in department "E11" a bonus equal to 10 of their salary: UPDATE emp SET bonus = (SELECT .10 * salary FROM emp y WHERE empno = y.empno) WHERE CURRENT OF c1; Which statement should be used to define cursor C1?
Correct Answer: D
Vote an answer
