Multiple choice technology databases

Which statements excute without error(select all)

  1. select ename||',is the'||job from emp

  2. select ename,||'is the||job from emp

  3. select 'ename'||'is the'||'job' from from emp

  4. select ename||concat('is the',job) from emp

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

Option A correctly uses concatenation with || operator to combine columns and strings. Option C correctly concatenates string literals (quoted strings) - the column name 'ename' in quotes is a literal string, not a column reference, but this is valid SQL syntax. Options B and D have syntax errors.