IBM C2090-730 - DB2 9 Family Fundamentals Exam
Page: 1 / 61
Total 301 questions
Question #1 (Topic: )
N NO:149
Which of the following is a valid wildcard character in a LIKE clause of a SELECT
statement?
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 (Topic: )
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?
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 (Topic: )
Which tool must be used to analyze all of the database operations performed by an
application against a DB2 for i5/OS database?
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 (Topic: )
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?
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 (Topic: )
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?
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
Answer: D
