Which of the following will be a consequence of defining the column IDCOL2 in TABLE2 as a foreign key referencing the primary key (IDCOL1) of TABLE1?

• A. When inserting a row in TABLE2, the only values that DB2 will allow for IDCOL2 are the existing values of IDCOL1.
• B. When inserting a row in TABLE2, DB2 will only allow foreign values forIDCOL2, that is values which do not exist in IDCOL1.
• C. When a SELECT statement joins TABLE1 with TABLE2, DB2 will automatically add the condition TABLE1.IDCOL1=TABLE2.IDCOL2 if not specified in the statement.
• D. DB2 will no longer allow updating the value of IDCOL1 in TABLE1.

Which of the following products is used to shred extensible markup language documents?

• A. DB2 Text Extender
• B. DB2 XML Extender
• C. DB2 AVI Extender
• D. DB2 Spatial Extender

If the following SQL statements are executed:
CREATE TABLE tab1 (id SMALLINT NOT NULL PRIMARY KEY,
name VARCHAR(25));
CREATE TABLE tab2 (empid SMALLINT,
weekno SMALLINT,
payamt DECIMAL(6,2),
CONSTRAINT const1 FOREIGN KEY (empid)
REFERENCES taba(id) ON UPDATE NO ACTION);
Which of the following statements is true?

• A. The updating of values in the ID column of table TAB1 is not allowed
• B. Only values that exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2
• C. When values that exist in the ID column of table TAB1 are updated, corresponding values in the EMPID column of table TAB2 are updated as well
• D. Only values that do not already exist in the ID column of table TAB1 are allowed to be inserted in the EMPID column of table TAB2

Given the following CREATE TABLE statement:
CREATE TABLE customer(custid INTEGER, info XML)
And the following INSERT statements:
INSERT INTO customer VALUES (1000,
'<customerinfo xmlns="http://custrecord.dat" custid="1000">
<name>John Doe</name>
<addr country="United States">
<street>25 East Creek Drive</street>
<city>Raleigh</city>
<state-prov>North Carolina</state-prov>
<zip-pcode>27603</zip-pcode>
</addr>
<phone type="work">919-555-1212</phone>
<email>[email protected]</email>
</customerinfo>');
INSERT INTO customer VALUES (1000,
'<customerinfo xmlns="http://custrecord.dat" custid="1001">
<name>Paul Smith</name>
<addr country="Canada">
<street>412 Stewart Drive</street>
<city>Toronto</city>
<state-prov>Ontario</state-prov>
<zip-pcode>M8X-3T6</zip-pcode>
</addr>
<phone type="work">919-555-4444</phone>
<email>[email protected]</email>
</customerinfo>');
What is the result of the following XQuery expression?
XQUERY declare default element namespace "http://custrecord.dat"; for
$info in db2-fn:xmlcolumn('CUSTOMER.INFO')/customerinfo where
$info/addr/state-prov="Ontario" return $info/name/text();

• A. Paul Smith
• B. <customerinfo xmlns="http://custrecord.dat" custid="1001"><name xmlns="http://custrecord.dat">Paul Smith</name>
• C. <namexmlns="http://custrecord.dat">Paul Smith</name>
• D. <customerinfo xmlns="http://custrecord.dat" custid="1001">Paul Smith</customerinfo>