Choose the two illegal statements. The two correct statements produce identical
ID: 3643711 • Letter: C
Question
Choose the two illegal statements. The two correct statements produce identical results. The two illegal statements will cause an error to be raised:Choose at least one answer.
A. SELECT DEPARTMENT_ID II 'represents the ' II DEPARTMENT_NAME II ' Department' as "Department Info" FROM DEPARTMENTS;
B. SELECT DEPARTMENT_ID || 'represents the || DEPARTMENT_NAME || 'Department' as "Department Info" FROM DEPARTMENTS;
C. Select department_id || 'represents the ' || department_name || 'Department' "department Info" From departments;
D. SELECT DEPARTMENT_ID represents the DEPARTMENT_NAME department as "Department Info" FROM DEPARTMENTS;
Explanation / Answer
D. SELECT DEPARTMENT_ID represents the DEPARTMENT_NAME department as "Department Info" FROM DEPARTMENTS;