Question

Which of the following is/are false for RAW mode of FOR XML?

(a) XMLSCHEMA option does not returns an in-line XSD schema

(b) BINARY BASE32 returns the binary data in base32-encoded format

(c) Each row in the query result is transformed into an XML element

(d) None of the mentioned

I got this question at a job interview.

This intriguing question originated from Transformation of Relational Expressions topic in portion Query Processing Techniques of Database Management

Answer 1

Right answer is (b) BINARY BASE32 returns the binary data in base32-encoded format

Easiest explanation - XML was designed to transport and store data.