PrepAway - Latest Free Exam Questions & Answers

Which of the following /data/dept.del import files will be accepted by DB2?

Consider the following IMPORT statement:
IMPORT FROM /data/dept.del of DEL
XML FROM /data/xmlfiles

INSERT INTO dept
The table dept contains three columns: CID (INTEGER), NAME(VARCHAR(10)), INFO(XML).
Which of the following /data/dept.del import files will be accepted by DB2?

PrepAway - Latest Free Exam Questions & Answers

A.
1000, “John Smith”, <XDS FIL=C1.xml/>
1001,”Jane Doe”, <XDS FIL=C2.xml/>
1002, “Mary David”, <XDS FIL=C3.xml/>

B.
1000, “John Smithson”, “<XDS FIL=’C1.xml’ />”
1001,”Jane Doe”, “<XDS FIL=’C2.xml’ />”
1002, “Mary David”, “<XDS FIL=’C3.xml’ />”

C.
1000, “John Smith”, “<XDS= ‘C1.xml’ />”
1001,”Jane Doe”, “<XDS= ‘C2.xml’ />”
1002, “Mary David”, “<XDS= ‘C3.xml’ />”

D.
1000, “John Smith”, “<XDS FIL=’C1.xml’ />”
1001,”Jane Doe”, “<XDS FIL=’C2.xml’ />”
1002, “Mary David”, “<XDS FIL=’C3.xml’ />”

Explanation:


Leave a Reply