Given the following two tables:
TAB1
R1
—
ABCDE
TAB2
R2
—
ABCD
Which of the following queries returns the following result set?
RETVAL
——
E
A.
SELECT r1 ASretval FROM tab1
INTERSECT
SELECT r2 AS retval FROM tab2
B.
SELECT r1 ASretval FROM tab1
EXCEPT
SELECT r2 AS retval FROM tab2
C.
SELECT DISTINCT r1 ASretval
FROM tab1, tab2
WHERE r1 <> r2
D.
SELECT r1 ASretval FROM tab1
UNION
SELECT r2 AS retval FROM tab2
B.
SELECT r1 ASretval FROM tab1
EXCEPT
SELECT r2 AS retval FROM tab2
0
0
The XMLPARSE function parses the argument as an XML document and returns an XML value.
DOCUMENT
Specifies that the character string expression to be parsed must evaluate to a well-formed XML document that conforms to XML 1.0, as modified by the XML Namespaces recommendation (SQLSTATE 2200M).
string-expression
Specifies an expression that returns a character string or BLOB value. If a parameter marker is used, it must explicitly be cast to one of the supported data types.
STRIP WHITESPACE or PRESERVE WHITESPACE
Specifies whether or not whitespace in the input argument is to be preserved. If neither is specified, STRIP WHITESPACE is the default.
STRIP WHITESPACE
Specifies that text nodes containing only whitespace characters up to 1000 bytes in length will be stripped, unless the nearest containing element has the attribute xml:space=’preserve’. If any text node begins with more that 1000 bytes of whitespace, an error is returned (SQLSTATE 54059).
The whitespace characters in the CDATA section are also affected by this option. DTDs may have DOCTYPE declarations for elements, but the content models of elements are not used to determine if whitespace is stripped or not.
0
0