Exam 1z0-071 All QuestionsBrowse all questions from this exam
Go to Exam
Question 79

Which two are true about a SQL statement using SET operators such as UNION? (Choose two.)

    Correct Answer: C, E

    In SQL, when using SET operators such as UNION, the data type of each column returned by the second query must be implicitly convertible to the data type of the corresponding column returned by the first query. This ensures that the UNION operation can take place without data type conflicts. Additionally, the number of columns must be identical for all select statements in the query, but the names of these columns do not need to match. This is necessary for the UNION operator to understand how to merge the result sets.

Discussion
dilshodOptions: CE

CE is 100% percent is correct

Fargo01Options: CE

CE for sure 100%

yaya32Options: AE

AE for me - I don't think they need to match exactly.

lucemqyOptions: AE

The data types does not need to match exactly

obsyOptions: AE

AE Correct

NelitaOptions: AE

AE are correct.

Viviana3184Options: DE

c is incorrect ->The set operators are not valid on columns of type BLOB, CLOB, BFILE, VARRAY, or nested table. i think D E are correct The UNION, INTERSECT, and MINUS operators are not valid on LONG columns. https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/The-UNION-ALL-INTERSECT-MINUS-Operators.html#GUID-B64FE747-586E-4513-945F-80CB197125EE

Viviana3184

sorry, AE are correct, not DE