PrepAway - Latest Free Exam Questions & Answers

Which SQL statement will retrieve XML documents from the CUSTOMER table and convert them to character strings?

A table named CUSTOMER has an XML column named CUSTINFO that contains
several XML documents.
Which SQL statement will retrieve XML documents from the CUSTOMER table and
convert them to character strings?

PrepAway - Latest Free Exam Questions & Answers

A.
SELECT XMLTEXT(custinfo AS VARCHAR(350)) FROM customer

B.
SELECT XMLCAST(custinfo AS VARCHAR(350)) FROM customer

C.
SELECT XM LP AR S E (c u sti nf o AS VARCHAR(350)) FROM customer

D.
SELECT XM LS E RIALIZE (c u sti nf o AS VARCHAR(350)) FROM customer


Leave a Reply