Which of the following is an accurate statement about packages?

Given the following information:
Protocol: TCP/IP
Port Number: 5000
Host Name: DB_SERVER
Database Name: TEST_DB
Database Server Platform: Linux
Which of the following will allow a client to access the database stored on the server?

Which object may be used during query optimization to improve the performance for a subset of
SELECT queries?

A DRDA host database resides on a z/OS or an i5/OS system and listens on port 446. The TCP/IP
address for this system is 192.168.10.1 and the TCP/IP host name is myhost. Which of the
following commands is required to update the local node directory so that a DB2 client can access
this DRDA database?

Given the following ALTER SEQUENCE statement:
ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5
ORDER

Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the
following is true?

Within the application MY_APP the following PREVIOUS VALUE expression references the
sequence MY_SEQ:
PREVIOUS VALUE FOR my_seq
After which of the following events will the most recently generated value of MY_SEQ persist so
that it can be returned to the active MY_APP application?

A declared temporary table is used for which of the following purposes?

Which of the following DB2 objects is NOT considered executable using SQL?

Which of the following is NOT an accurate statement about views?

Which of the following SQL statements can be used to create a DB2 object to store numerical data
as EURO data?