Multiple choice technology databases

What will be the output of- "Select 1 from dual UNION Select 'A' from dual"

  1. 1,A

  2. A

  3. Error

  4. 1

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

A UNION query requires that corresponding columns in both select statements have compatible data types. Here, the first SELECT returns a numeric value (1) while the second returns a character value ('A'), resulting in a data type mismatch error.