IBM 000-704 exam content

The we offer 000-704 we IBM Senior Lecturer and expert preparation and testing, and contains all the real exam questions. We have been committed to providing the most good learning materials, to ensure that customers can be quick and easy to pass the exam. 000-704 exam content we provide professional and technical content of the highest standards, it can make your exam success.


2.A remote connection is being established from a Windows system running DB2 Connect to a DB2 for z/OS subsystem called DBX1. The following Node and database directory entries have already been cataloged: Node 1 entry: Node name = DBX1NODE Comment = Protocol = TCPIP Hostname = dbx1.company.com Service name = 2500 Database 1 entry: Database alias = DBX1 Database name = TEST Node name = DBX1NODE Database release level = 9.00 Comment = Directory entry type = Remote Authentication = SERVER Catalog node number = -1 Which of the following commands will catalog the DCS directory entry?

A.CATALOG DCS DATABASE test AS dbx1

B.CATALOG DCS DATABASE dbx1 AS test

C.CATALOG DCS DATABASE dbx1 AT dbx1node

D.CATALOG DCS DATABASE test AT dbx1node

Correct:A

3.Which of the following settings for the DB2MAXFSCRSEARCH registry variable ensures a complete search for space in the database tables, possibly making inserts slower?

A.1

B.5

C.-1

D.33554

Correct:C

4.Defining a table as VOLATILE indicates which of the following to the DB2 optimizer?

A.The table is frequently dropped and recreated.

B.The number of rows in the table typically varies significantly.

C.The table is the target of SELECT statements from a large number of users.

D.The entire table should be kept in the buffer pool so that DB2 can access it using table scans.

Correct:B