IBM C2090-730 Free Practice Exam & Test Training

Question 1

N NO:149 -
Which of the following is a valid wildcard character in a LIKE clause of a SELECT statement?

A. %
B. *
C. ?
D. \

Answer : A

Question 2

Which product must be installed on z/OS to allow a COBOL program running on that machine to access data on a remote DB2 for z/OS server?

A. DB2 for z/OS
B. DB2 Run-Time Client for z/OS
C. DB2 Connect Enterprise Edition for z/OS
D. z/OS Application Connectivity to DB2 for z/OS and OS/390

Answer : A

Question 3

Which tool must be used to analyze all of the database operations performed by an application against a DB2 for i5/OS database?

A. Visual Explain
B. Activity Monitor
C. SQL Performance Monitor
D. DB2 Performance Monitor

Answer : C

Question 4

Given the following function:
CREATE FUNCTION emplist ()
RETURNS TABLE ( id CHAR(6)
, firstname VARCHAR(12)
, lastname VARCHAR(15) )

LANGUAGE SQL -

BEGIN ATOMIC -

RETURN -
SELECT EMPNO, FIRSTNME, LASTNAME

FROM EMPLOYEE -
WHERE WORKDEPT IN ('A00', 'B00');

END -
How can this function be used in an SQL statement?

A. SELECT TABLE(EMPLIST()) FROM EMPLOYEE
B. SELECT TABLE(EMPLIST()) AS t FROM EMPLOYEE
C. SELECT EMPLIST(id, firstname, lastname) FROM EMPLOYEE
D. SELECT id, firstname, lastname FROM TABLE(EMPLIST()) AS t

Answer : D

Question 5

A sequence was created with the DDL statement shown below:
CREATE SEQUENCE my_seq START WITH 10 INCREMENT BY 10 CACHE 10
User USER1 successfullyexecutes the following statements in the order shown:
VALUES NEXT VALUE FOR my_seq INTO :hvar;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
User USER2 successfully executes the following statements in the order shown:
ALTER SEQUENCE my_seq RESTART WITH 5 INCREMENT BY 5 CACHE 5;
VALUES NEXT VALUE FOR my_seq INTO :hvar;
After users USER1 and USER2 are finished, user USER3 executes the following query:
SELECT NEXT VALUE FOR my_seq FROM sysibm.sysdummy1
What value will be returned by the query?

A. 5
B. 10
C. 20
D. 30