16.
A UDT is a data type which .................
- A.must contain unique values.
- B.cannot be CAST to other data types.
- C.is created using the CREATE TYPE command.
- D.contains a value that was automatically calculated from values in other columns.
- Answer
- Report
Answer : [C]
17.
Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?
- A.INSERT INTO tab1 SELECT cx, cy FROM tab2
- B.INSERT INTO tab1 VALUES (tab2.cx, tab2.cy)
- C.INSERT INTO tab1 VALUES (SELECT cx, cy FROM tab2)
- D.INSERT INTO tab1 (c1, c2) VALUES (SELECT cx, cy FROM tab2)
- Answer
- Report
Answer : [A]
18.
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
- Report
Answer : [B]
19.
Which of the following is NOT true about XML columns?
- A.Data can be retrieved by SQL.
- B.Data can be retrieved by XQuery or XPath.
- 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
- Report
Answer : [C]
20.
Which of the following is the lowest cost DB2 product that can be legally installed on a Windows server that has 2 CPUs?
- A.DB2 Everyplace
- B.DB2 Express Edition
- C.DB2 Workgroup Server Edition
- D.DB2Enterprise Server Edition
- Answer
- Report
Answer : [B]
|
|
||||||||||||||||||||||||||||
