DB2 考试 730培训模拟试题

DB2 考试 730 模拟试题 1. Which of the following is NOT true about XML columns? A.Data can be retrieved by SQL. B.Data can be retrieved by XQuery. C.XML columns must be altered to accommodate additional parent and child relationships. D.Access to any portion of an XML document can be direct, without reading the whole document. Answer: C 2. 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? A.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 446 B.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 446 C.CATALOG TCPIP NODE myhost REMOTE db2srv SERVER 192.168.10.1 D.CATALOG TCPIP NODE mydb2srv REMOTE myhost SERVER 192.168.10.1 Answer: B 3.